Zimbra offers Open Source email server software and shared calendar for Linux and the Mac
 
Go Back   Zimbra - Forums > Zimbra Collaboration Suite > Installation
Reload this Page 3.0 to 4.5.3 Upgrade failed (mysql error)

Welcome to the Zimbra - Forums!
Welcome, if you would like to post a comment please register. We also encourage you to explore all things Zimbra with our team and members of the community.

Reply
Page 1 of 4 1 23
 
LinkBack (1) Thread Tools Display Modes
  1 links from elsewhere to this Post. Click to view. #1 (permalink)  
Old 03-06-2007, 04:46 AM
Active Member
  
Posts: 36
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!
Reply With Quote
  #2 (permalink)  
Old 03-06-2007, 10:02 AM
Zimbra-Yahoo Consultant
  
Posts: 5,608
Default
Looks like the migration script failed.
I assume you have a backup. . .right????
Reply With Quote
  #3 (permalink)  
Old 03-06-2007, 04:22 PM
Active Member
  
Posts: 36
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!
Reply With Quote
  #4 (permalink)  
Old 03-06-2007, 05:13 PM
Zimbra-Yahoo Consultant
  
Posts: 5,608
Default
Well,
I'd make sure you have enough space, clear out your /tmp folder, and try agian.
Reply With Quote
  #5 (permalink)  
Old 03-06-2007, 08:02 PM
Active Member
  
Posts: 36
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?
Reply With Quote
  #6 (permalink)  
Old 03-06-2007, 08:15 PM
Active Member
  
Posts: 36
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!
Reply With Quote
  #7 (permalink)  
Old 03-06-2007, 08:17 PM
Zimbra-Yahoo Consultant
  
Posts: 5,608
Default
Hi Delt,
I think it's important for you to understand that you are attempting to treat the symptoms, and not address the problem.

I think your proposal may work, but the problem you should be concerned about is why the heck is your script failing.

Can you post your /opt/zimbra/.install_history ?

Thanks
john
Reply With Quote
  #8 (permalink)  
Old 03-06-2007, 08:30 PM
Active Member
  
Posts: 36
Default
Quote:
Originally Posted by jholder View Post
Hi Delt,
I think it's important for you to understand that you are attempting to treat the symptoms, and not address the problem.

I think your proposal may work, but the problem you should be concerned about is why the heck is your script failing.

Can you post your /opt/zimbra/.install_history ?

Thanks
john
Hi John!
I'm just considering my other options. It's getting to be quite frustrating not being able to successfully upgrade our server after n attempts. Anyway, I just restored my 3.0 backup, I think it has overwritten the .install_history of my failed upgrade. Are there any other files that we can look at? Anyway here's my current .install history :

Code:
1143111968: INSTALL SESSION START
1143111981: INSTALLED zimbra-core-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1143111983: INSTALLED zimbra-ldap-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1143111987: INSTALLED zimbra-logger-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1143111991: INSTALLED zimbra-mta-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1143111994: INSTALLED zimbra-snmp-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1143112001: INSTALLED zimbra-store-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1143112004: INSTALLED zimbra-apache-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1143112006: INSTALLED zimbra-spell-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1143112006: INSTALL SESSION COMPLETE
1143112070: CONFIG SESSION START
1143112070: CONFIGURED BEGIN
1143112084: CONFIGURED configLCValues
1143112086: CONFIGURED configCASetup
1143112090: CONFIGURED configCreateCert
1143112100: CONFIGURED configSetupLdap
1143112106: CONFIGURED configSaveCA
1143112111: CONFIGURED configInstallCert
1143112115: CONFIGURED configCreateServerEntry
1143112118: CONFIGURED configSpellServer
1143112121: CONFIGURED configSetServicePorts
1143112152: CONFIGURED configInstallZimlets
1143112155: CONFIGURED configSetMtaAuthHost
1143112186: CONFIGURED configCreateDomain
1143112199: CONFIGURED configInitSql
1143112232: CONFIGURED configInitLogger
1143112233: CONFIGURED configInitMta
1143112244: CONFIGURED configInitSnmp
1143112250: CONFIGURED configSetEnabledServices
1143112250: CONFIGURED setupCrontab
1143112363: CONFIGURED END
1143112363: CONFIG SESSION COMPLETE
1173203598: INSTALL SESSION START
1173203614: UPGRADED zimbra-core-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1173203616: UPGRADED zimbra-ldap-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1173203622: UPGRADED zimbra-logger-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1173203630: UPGRADED zimbra-mta-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1173203633: UPGRADED zimbra-snmp-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1173203640: UPGRADED zimbra-store-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1173203645: UPGRADED zimbra-apache-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1173203647: UPGRADED zimbra-spell-3.0.1_GA_160.FC4-20060216172118.i386.rpm
1173203647: INSTALL SESSION COMPLETE
1173204007: CONFIG SESSION START
1173204007: CONFIGURED BEGIN
1173204022: CONFIGURED configLCValues
1173204022: CONFIGURED configCASetup
1173204022: CONFIGURED configCreateCert
1173204027: CONFIGURED configSetupLdap
1173204034: CONFIGURED configSaveCA
1173204038: CONFIGURED configInstallCert
1173204041: CONFIGURED configCreateServerEntry
1173204045: CONFIGURED configSpellServer
1173204048: CONFIGURED configSetServicePorts
1173204078: CONFIGURED configInstallZimlets
1173204081: CONFIGURED configSetMtaAuthHost
1173204081: CONFIGURED configCreateDomain
1173204081: CONFIGURED configInitSql
1173204085: CONFIGURED configInitLogger
1173204086: CONFIGURED configInitMta
1173204097: CONFIGURED configInitSnmp
1173204104: CONFIGURED configSetEnabledServices
1173204104: CONFIGURED setupCrontab
1173204213: CONFIGURED END
1173204213: CONFIG SESSION COMPLETE
Reply With Quote
  #9 (permalink)  
Old 03-06-2007, 08:44 PM
Zimbra-Yahoo Consultant
  
Posts: 5,608
Default
We think that perhaps you may not have enough buffer space.
This causes an error in creation of foreign constants.

Take a look at /opt/zimbra/conf/my.cnf and set the innodb_buffer_pool_size = 1992294400
Reply With Quote
  #10 (permalink)  
Old 03-06-2007, 08:59 PM
Active Member
  
Posts: 36
Default
Quote:
Originally Posted by jholder View Post
We think that perhaps you may not have enough buffer space.
This causes an error in creation of foreign constants.

Take a look at /opt/zimbra/conf/my.cnf and set the innodb_buffer_pool_size = 1992294400
Ok. I'll try. Thanks. I'll post whatever the results here
Reply With Quote
Reply
Page 1 of 4 1 23

« Previous Thread | Today's Posts or Week's Posts | Next Thread »

Thread Tools
Display Modes
Linear Mode Linear Mode


Similar Threads

Product Information

Why Join?

Registering let's you ask questions, makes it easier to search, displays any files attached to posts, and notifies you about replies.

Zimbrablog.com


Home - Blog - Contact Us - Archive - Top


 

Search Engine Optimization by vBSEO 3.1.0