Results 1 to 2 of 2

Thread: MySQL Tables upgrade after upgrade to 7.1.0

  1. #1
    Join Date
    Oct 2008
    Location
    Portugal, Castelo Branco
    Posts
    63
    Rep Power
    7

    Talking MySQL Tables upgrade after upgrade to 7.1.0

    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:

    Code:
    (....)
    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
    Code:
    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

  2. #2
    Join Date
    Aug 2011
    Posts
    19
    Rep Power
    4

    Default

    HELP ME....


    /opt/zimbra/libexec/script/migrate20100913-Mysql51.pl

    Mon Jul 9 18:29:51 2012: 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.

    Code:
    [root@zimbra mysql]# /opt/zimbra/libexec/zmdbintegrityreport -v
    Database errors found.
    /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=XXXXXXXX
    zimbra.config
     error    : Table upgrade required. Please do "REPAIR TABLE `config`" or dump/reload to fix it!
     zimbra.deleted_account
     error    : Table upgrade required. Please do "REPAIR TABLE `deleted_account`" or dump/reload to fix it!
     zimbra.mailbox
     error    : Table upgrade required. Please do "REPAIR TABLE `mailbox`" or dump/reload to fix it!
     zimbra.mailbox_metadata
     error    : Table upgrade required. Please do "REPAIR TABLE `mailbox_metadata`" or dump/reload to fix it!
     zimbra.out_of_office
     error    : Table upgrade required. Please do "REPAIR TABLE `out_of_office`" or dump/reload to fix it!
     zimbra.scheduled_task
     error    : Table upgrade required. Please do "REPAIR TABLE `scheduled_task`" or dump/reload to fix it!
     zimbra.table_maintenance
     error    : Table upgrade required. Please do "REPAIR TABLE `table_maintenance`" or dump/reload to fix it!

    Quote Originally Posted by feiticeir0 View Post
    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:

    Code:
    (....)
    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
    Code:
    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

Similar Threads

  1. Replies: 5
    Last Post: 05-11-2012, 02:16 PM
  2. Upgrade from 6.0.10 to 7 beta4
    By alex70 in forum Installation
    Replies: 14
    Last Post: 05-11-2012, 02:02 PM
  3. Replies: 6
    Last Post: 03-14-2011, 04:21 AM
  4. [SOLVED] New zcs 7 install : database errors founds
    By dkbk in forum Administrators
    Replies: 4
    Last Post: 03-01-2011, 05:49 AM
  5. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 12:42 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
  •