MySQL Tables upgrade after upgrade to 7.1.0

[feiticeir0]

Hi all !

I've done the upgrade and i think everything is ok. I'm only creating this post just for been sure.

I've done the upgrade as zimbra user and with the Zimbra server running

The first time i try to do the upgrade, i got the following error:

(....)
Adding mboxgroup98.tombstone to be optimized
Adding mboxgroup98.data_source_item to be optimized
Adding mboxgroup99.mail_item to be optimized
Adding mboxgroup99.appointment to be optimized
Adding mboxgroup99.imap_folder to be optimized
Adding mboxgroup99.imap_message to be optimized
Adding mboxgroup99.open_conversation to be optimized
Adding mboxgroup99.pop3_message to be optimized
Adding mboxgroup99.revision to be optimized
Adding mboxgroup99.tombstone to be optimized
Adding mboxgroup99.data_source_item to be optimized
Adding zimbra.volume to be optimized
Adding zimbra.current_volumes to be optimized
Adding zimbra.mailbox to be optimized
Adding zimbra.deleted_account to be optimized
Adding zimbra.mailbox_metadata to be optimized
Adding zimbra.out_of_office to be optimized
Adding zimbra.config to be optimized
Adding zimbra.table_maintenance to be optimized
Adding zimbra.scheduled_task to be optimized
Adding zimbra.mobile_devices to be optimized
Wed May 11 11:18:19 2011: DB: ALTER TABLE zimbra.mailbox ENGINE=InnoDB;: Lock wait timeout exceeded; try restarting transaction

Died at /opt/zimbra/libexec/scripts/Migrate.pm line 362, <OUTPUT> line 100.
[zimbra@weanoc ~]$ Wed May 11 11:18:23 2011: DB: ALTER TABLE mboxgroup90.mail_item ENGINE=InnoDB;: Lock wait timeout exceeded; try restarting transaction

And sqlMigration.log

Wed May 11 11:18:05 2011: ALTER TABLE mboxgroup27.mail_item ENGINE=InnoDB;
Wed May 11 11:18:10 2011: ALTER TABLE mboxgroup17.appointment ENGINE=InnoDB;
Wed May 11 11:18:11 2011: ALTER TABLE mboxgroup17.imap_folder ENGINE=InnoDB;
Wed May 11 11:18:11 2011: ALTER TABLE mboxgroup17.imap_message ENGINE=InnoDB;
Wed May 11 11:18:11 2011: ALTER TABLE mboxgroup17.open_conversation ENGINE=InnoDB;
Wed May 11 11:18:12 2011: ALTER TABLE mboxgroup17.pop3_message ENGINE=InnoDB;
Wed May 11 11:18:13 2011: ALTER TABLE mboxgroup17.revision ENGINE=InnoDB;
Wed May 11 11:18:13 2011: ALTER TABLE mboxgroup17.tombstone ENGINE=InnoDB;
Wed May 11 11:18:13 2011: ALTER TABLE mboxgroup17.data_source_item ENGINE=InnoDB;
Wed May 11 11:18:14 2011: ALTER TABLE mboxgroup27.appointment ENGINE=InnoDB;
Wed May 11 11:18:14 2011: ALTER TABLE mboxgroup18.mail_item ENGINE=InnoDB;
Wed May 11 11:18:19 2011: DB: ALTER TABLE zimbra.mailbox ENGINE=InnoDB;: Lock wait timeout exceeded; try restarting transaction

Wed May 11 11:18:23 2011: DB: ALTER TABLE mboxgroup90.mail_item ENGINE=InnoDB;: Lock wait timeout exceeded; try restarting transaction

Following the instructions, i've run the script again and everything went perfect.

don't know what could have happened, but i guess my upgrade is complete.

Cheers,

Bruno