Results 1 to 10 of 10

Thread: 4.5 Upgrade failure

  1. #1
    brained is offline Loyal Member
    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
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

    Please post the output of
    df -h

  3. #3
    brained is offline Loyal Member
    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
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    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
    brained is offline Loyal Member
    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
    brained is offline Loyal Member
    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
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    Default

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

  8. #8
    jholder's Avatar
    jholder is offline Former Zimbran
    Join Date
    Oct 2005
    Location
    Thatcher, AZ
    Posts
    5,606
    Rep Power
    20

    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 04:52 PM.

  9. #9
    brained is offline Loyal Member
    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
    brained is offline Loyal Member
    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.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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, 09:51 PM
  2. Replies: 9
    Last Post: 01-26-2007, 06:31 AM
  3. Replies: 8
    Last Post: 01-22-2007, 10: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, 08: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
  •