Results 1 to 10 of 10

Thread: 4.5 Upgrade failure

  1. #1
    Join Date
    Dec 2005
    Posts
    94
    Rep Power
    9

    Default 4.5 Upgrade failure

    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:
    Code:
    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

  2. #2
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    Please post the output of
    df -h

  3. #3
    Join Date
    Dec 2005
    Posts
    94
    Rep Power
    9

    Default

    Quote Originally Posted by wannabetenor View Post
    Please post the output of
    df -h
    Code:
    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.

  4. #4
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    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?

  5. #5
    Join Date
    Dec 2005
    Posts
    94
    Rep Power
    9

    Default

    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.

  6. #6
    Join Date
    Dec 2005
    Posts
    94
    Rep Power
    9

    Default

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

  7. #7
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

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

  8. #8
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    21

    Default

    EDIT: Scratch that.
    Can you run a

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

    and post the results?
    Last edited by jholder; 01-30-2007 at 03:52 PM.

  9. #9
    Join Date
    Dec 2005
    Posts
    94
    Rep Power
    9

    Default

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

    Code:
     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

  10. #10
    Join Date
    Dec 2005
    Posts
    94
    Rep Power
    9

    Default Fixed

    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.

Similar Threads

  1. Successful Mac OS X upgrade of 4.05 -> 4.5?
    By mbd in forum Installation
    Replies: 3
    Last Post: 02-14-2007, 08:51 PM
  2. Replies: 9
    Last Post: 01-26-2007, 05:31 AM
  3. Replies: 8
    Last Post: 01-22-2007, 09:54 AM
  4. Upgrade FROM 4.0.5 GA 518 to 4.5 GA 612 Failed
    By jcone in forum Installation
    Replies: 7
    Last Post: 01-18-2007, 07:51 PM
  5. Suse9 3.1.2 upgrade failure
    By DMRDave in forum Installation
    Replies: 10
    Last Post: 06-21-2006, 09:54 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •