Results 1 to 10 of 36

Thread: 3.0 to 4.5.3 Upgrade failed (mysql error)

Hybrid View

  1. #1
    Join Date
    Sep 2005
    Posts
    36
    Rep Power
    10

    Default 3.0 to 4.5.3 Upgrade failed (mysql error)

    Hi! I encountered this error while upgrading 3.0 to 4.5.3:

    Code:
    ERROR 1005 (HY000) at line 2: Can't create table './mboxgroup67/#sql-515e_1f1.frm' (errno: 150)
    Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=SAoo20h4bjrUQusGVKJZ5cQJ8C --database=zimbra --batch --skip-column-names'. at /opt/zimbra/libexec/scripts/Migrate.pm line 220,  line 94.
    Tue Mar  6 11:40:50 2007: Script failed with code 1 - exiting
    UPGRADE FAILED - exiting
    What should I do?

    One more thing, at the start up of the upgrade where it shows my current configuration values, it seems that it cant get the value of my LDAPHOST and LDAPPORT configuration as shown below:
    Code:
    Setting defaults from saved config in /opt/zimbra/.saveconfig/config.save
       HOSTNAME=stiimail.stii.dost.gov.ph
       LDAPHOST=
       LDAPPORT=
       SNMPTRAPHOST=stiimail.stii.dost.gov.ph
       SMTPSOURCE=admin@stii.dost.gov.ph
       SMTPDEST=admin@stii.dost.gov.ph
       SNMPNOTIFY=yes
       SMTPNOTIFY=yes
       LDAPROOTPW=GBHZs9we
       LDAPZIMBRAPW=GBHZs9we
    Is this ok?

    Thanks!

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

    Default

    Looks like the migration script failed.
    I assume you have a backup. . .right????

  3. #3
    Join Date
    Sep 2005
    Posts
    36
    Rep Power
    10

    Default

    Quote Originally Posted by jholder View Post
    Looks like the migration script failed.
    I assume you have a backup. . .right????
    Yep, I'm restoring it now. So what should I do about it? (upgrade problem). Thanks!

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

    Default

    Well,
    I'd make sure you have enough space, clear out your /tmp folder, and try agian.

  5. #5
    Join Date
    Sep 2005
    Posts
    36
    Rep Power
    10

    Default

    Quote Originally Posted by jholder View Post
    Well,
    I'd make sure you have enough space, clear out your /tmp folder, and try agian.
    Hi! Yep, I believe my /tmp folder has enough space:
    Code:
    df -h
    Filesystem            Size  Used Avail Use% Mounted on
    /dev/sda2             5.7G  2.3G  3.2G  42% /
    /dev/sda1              99M   13M   81M  14% /boot
    /dev/shm              760M     0  760M   0% /dev/shm
    /dev/md0               59G   32G   24G  58% /opt
    what am i missing?

  6. #6
    Join Date
    Sep 2005
    Posts
    36
    Rep Power
    10

    Default Possible workaround: Export and Import Accounts and Mails

    I've been trying to upgrade my 3.0 installation to the 4.5 (4.5.1 and 4.5.3) for several times for the past month and never succeeded. Im thinking of a possible workaround that will involve the following steps:

    1.) Have a fresh install of the latest release (4.5.3) on a different machine, or on a virtual machine

    2.) Find a way to import user accounts (and preferences?) from the old server to the new one. Perhaps if I can make their LDAP talk to each other.

    3.) Migrate emails via imapsync.

    ** SINCE THE PRODUCTION SERVER MUST RESIDE ON THE MACHINE OF MY ZIMBRA 3.0**

    4.) Backup /opt/zimbra directory from the new server

    5.) Install 4.5.3 on the old server, overwriting all the data.

    6.) Copy the /opt/zimbra from the new server to the old server (now with a fresh install 4.5.3)

    7.) Re-run install.sh (or i can skip this one?)

    Are all these possible? Thanks!

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  2. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  3. M3 problem with shares
    By titangears in forum Users
    Replies: 4
    Last Post: 01-12-2006, 01:01 PM
  4. Building native libraries on MacOS X
    By ajmas in forum Developers
    Replies: 3
    Last Post: 10-15-2005, 12:00 AM
  5. Insallation failed (Debian server)
    By popui007 in forum Installation
    Replies: 5
    Last Post: 09-29-2005, 03:27 PM

Posting Permissions

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