Failed upgrade from 4.0.5 to 4.5.2

[Rick Baker]

Upgrade failed.

This is the error message.

ERROR 1005 (HY000) at line 2: Can't create table './mboxgroup11/#sql-1107_9d.frm' (errno: 150)
Error while running '/opt/zimbra/bin/mysql --user=zimbra --password=[password here] --database=zimbra --batch --skip-co lumn-names'. at /opt/zimbra/libexec/scripts/Migrate.pm line 220,

line 21.
Sat Feb 24 13:21:26 2007: Script failed with code 1 - exiting
UPGRADE FAILED - exiting


Is this the same problem other poeple are having?

Is there a fix?

[jholder]

I edited your post because it contained your mysql password. . .and I assumed you didn't want that floating around

That is a different error.
You have a backup, right?

If so, can you restore, then erase everything in /tmp and try again?

-john

[Rick Baker]

I do have a full backup using zmbackup. Should I do a down grade then restore?

[jholder]

Yup.
I'm looking into what could cause your problem now.

-john

[jholder]

Can you post the following files:

/opt/zimbra/log/mysqld.log or /opt/zimbra/db/data/.err.
And your install.log would be helpful as well.

-john

[Rick Baker]

Here is the .com.err

070224 13:18:22 mysqld started
070224 13:18:23 InnoDB: Started; log sequence number 0 420624428
070224 13:18:23 [Note] /opt/zimbra/mysql/libexec/mysqld: ready for connections.
Version: '5.0.33-log' socket: '/opt/zimbra/db/mysql.sock' port: 7306 Source distribution

Here is the mysqld.log- This appears to be before the upgrade.

070208 19:12:44 mysqld ended

070208 19:13:11 mysqld started
070208 19:13:14 InnoDB: Started; log sequence number 0 377207864
/opt/zimbra/mysql/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/opt/zimbra/db/mysql.sock' port: 7306 Source distribution
070216 13:52:07 [Note] /opt/zimbra/mysql/libexec/mysqld: Normal shutdown

070216 13:52:07 InnoDB: Starting shutdown...
070216 13:52:09 InnoDB: Shutdown completed; log sequence number 0 399173266
070216 13:52:09 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

070216 13:52:09 mysqld ended

070216 13:54:45 mysqld started
070216 13:54:47 InnoDB: Started; log sequence number 0 399173266
/opt/zimbra/mysql/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/opt/zimbra/db/mysql.sock' port: 7306 Source distribution
070216 16:41:32 [Note] /opt/zimbra/mysql/libexec/mysqld: Normal shutdown

070216 16:41:32 InnoDB: Starting shutdown...
070216 16:41:35 InnoDB: Shutdown completed; log sequence number 0 399651359
070216 16:41:35 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

070216 16:41:35 mysqld ended

070216 16:44:10 mysqld started
070216 16:44:11 InnoDB: Started; log sequence number 0 399651359
/opt/zimbra/mysql/libexec/mysqld: ready for connections.
Version: '4.1.20-log' socket: '/opt/zimbra/db/mysql.sock' port: 7306 Source distribution
070224 13:15:39 [Note] /opt/zimbra/mysql/libexec/mysqld: Normal shutdown

070224 13:15:40 InnoDB: Starting shutdown...
070224 13:15:43 InnoDB: Shutdown completed; log sequence number 0 420624428
070224 13:15:43 [Note] /opt/zimbra/mysql/libexec/mysqld: Shutdown complete

070224 13:15:43 mysqld ended

[jholder]

Nothing odd. . .What about the other ones?

[Rick Baker]

See the attached install.log

[Rick Baker]

see attached

[jholder]

Attached where?