4.5 Upgrade failure

[brained]

Upgrading from zcs-4.0.5_GA_518.RHEL4 to zcs-4.5.0_GA_612.RHEL4 on Centos 4.4 results in the following error message:

ERROR 1146 (42S02) at line 9998: Table 'mysql.proc' doesn't exist
mysql invication failed, exit code = 1:  at /opt/zimbra/libexec/scripts/migrate20060911-MailboxGroup.pl line 84, 
 line 113.
Sat Jan 20 01:27:11 2007: Script failed with code 1 - exiting
UPGRADE FAILED - exiting

[jholder]

Please post the output of
df -h

[brained]

Originally Posted by wannabetenor

Please post the output of
df -h

Filesystem            Size  Used Avail Use% Mounted on
/dev/hda3             9.7G  2.6G  6.6G  29% /
/dev/hda1             190M   13M  168M   7% /boot
none                 1014M     0 1014M   0% /dev/shm
/dev/mapper/opt-ZOPT   58G  7.3G   48G  14% /opt

Seems to be plenty of space.

[jholder]

Hmm, I belive this is an issue that the team is working on.
I assume you have a backup, right?

Also, did you try re-running the upgrade?

[brained]

Ran the upgrade twice on two different days, same error each time. I ran the install on a backup copy of sorts so I could and did fall back to the live production version each time the backup failed.

[brained]

Has the team made any progress on this issue?
I desperately need the html client.

[jholder]

Please see this bug, and vote for it to track it
http://bugzilla.zimbra.com/show_bug.cgi?id=14146

[jholder]

EDIT: Scratch that.
Can you run a

ls -la /opt/zimbra/db/data/mysql

and post the results?

[brained]

This is from the production 4.0.5 - do you want the 4.5.0 also?

 ls -la /opt/zimbra/db/data/mysql
total 504
drwx------   2 zimbra zimbra   4096 Oct 24 12:55 .
drwxrwxr-x  64 zimbra zimbra   4096 Jan 30 13:05 ..
-rw-rw----   1 zimbra zimbra   8820 Oct 24 12:55 columns_priv.frm
-rw-rw----   1 zimbra zimbra      0 Oct 24 12:55 columns_priv.MYD
-rw-rw----   1 zimbra zimbra   1024 Oct 24 12:55 columns_priv.MYI
-rw-rw----   1 zimbra zimbra   9178 Oct 24 12:55 db.frm
-rw-rw----   1 zimbra zimbra   2598 Oct 24 12:55 db.MYD
-rw-rw----   1 zimbra zimbra   4096 Oct 24 13:00 db.MYI
-rw-rw----   1 zimbra zimbra   8665 Oct 24 12:55 func.frm
-rw-rw----   1 zimbra zimbra      0 Oct 24 12:55 func.MYD
-rw-rw----   1 zimbra zimbra   1024 Oct 24 12:55 func.MYI
-rw-rw----   1 zimbra zimbra   8700 Oct 24 12:55 help_category.frm
-rw-rw----   1 zimbra zimbra   1000 Oct 24 12:55 help_category.MYD
-rw-rw----   1 zimbra zimbra   3072 Oct 24 12:55 help_category.MYI
-rw-rw----   1 zimbra zimbra   8612 Oct 24 12:55 help_keyword.frm
-rw-rw----   1 zimbra zimbra   7472 Oct 24 12:55 help_keyword.MYD
-rw-rw----   1 zimbra zimbra  12288 Oct 24 12:55 help_keyword.MYI
-rw-rw----   1 zimbra zimbra   8630 Oct 24 12:55 help_relation.frm
-rw-rw----   1 zimbra zimbra   5751 Oct 24 12:55 help_relation.MYD
-rw-rw----   1 zimbra zimbra  11264 Oct 24 12:55 help_relation.MYI
-rw-rw----   1 zimbra zimbra   8770 Oct 24 12:55 help_topic.frm
-rw-rw----   1 zimbra zimbra 198020 Oct 24 12:55 help_topic.MYD
-rw-rw----   1 zimbra zimbra  15360 Oct 24 12:55 help_topic.MYI
-rw-rw----   1 zimbra zimbra   9148 Oct 24 12:55 host.frm
-rw-rw----   1 zimbra zimbra      0 Oct 24 12:55 host.MYD
-rw-rw----   1 zimbra zimbra   1024 Oct 24 12:55 host.MYI
-rw-rw----   1 zimbra zimbra   8925 Oct 24 12:55 tables_priv.frm
-rw-rw----   1 zimbra zimbra      0 Oct 24 12:55 tables_priv.MYD
-rw-rw----   1 zimbra zimbra   1024 Oct 24 12:55 tables_priv.MYI
-rw-rw----   1 zimbra zimbra   8636 Oct 24 12:55 time_zone.frm
-rw-rw----   1 zimbra zimbra   8624 Oct 24 12:55 time_zone_leap_second.frm
-rw-rw----   1 zimbra zimbra      0 Oct 24 12:55 time_zone_leap_second.MYD
-rw-rw----   1 zimbra zimbra   1024 Oct 24 12:55 time_zone_leap_second.MYI
-rw-rw----   1 zimbra zimbra      0 Oct 24 12:55 time_zone.MYD
-rw-rw----   1 zimbra zimbra   1024 Oct 24 12:55 time_zone.MYI
-rw-rw----   1 zimbra zimbra   8606 Oct 24 12:55 time_zone_name.frm
-rw-rw----   1 zimbra zimbra      0 Oct 24 12:55 time_zone_name.MYD
-rw-rw----   1 zimbra zimbra   1024 Oct 24 12:55 time_zone_name.MYI
-rw-rw----   1 zimbra zimbra   8686 Oct 24 12:55 time_zone_transition.frm
-rw-rw----   1 zimbra zimbra      0 Oct 24 12:55 time_zone_transition.MYD
-rw-rw----   1 zimbra zimbra   1024 Oct 24 12:55 time_zone_transition.MYI
-rw-rw----   1 zimbra zimbra   8748 Oct 24 12:55 time_zone_transition_type.frm
-rw-rw----   1 zimbra zimbra      0 Oct 24 12:55 time_zone_transition_type.MYD
-rw-rw----   1 zimbra zimbra   1024 Oct 24 12:55 time_zone_transition_type.MYI
-rw-rw----   1 zimbra zimbra   9992 Oct 24 12:55 user.frm
-rw-rw----   1 zimbra zimbra    628 Oct 24 12:55 user.MYD
-rw-rw----   1 zimbra zimbra   2048 Oct 24 13:00 user.MYI

[brained]

Used Option # 2:
> or
> -. upgrade in software only mode, edit migration script, run zmseup.pl
> 1. install.sh -s
> 2. edit /opt/zimbra/libexec/scripts/migrate20060911-
> MailboxGroup.pl and
> comment out lines 75-78
> 3. run /opt/zimba/libexec/zmsetup.pl

Worked flawlessly. I'll be cleaning out the orphaned tables over the next couple days in preparation for the 4.5.3 upgrade.