[SOLVED] New zcs 7 install : database errors founds

[dkbk]

Hi

Succesfully migrated from 6.07 to 7.0.0 last week. Did a database check prior to migration and all was fine.

However, I received this message at 11PM last night.

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=*****************************
mboxgroup1.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup1.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup1.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup1.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup1.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup10.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup10.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup10.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup10.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup10.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup11.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup11.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup11.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup11.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup11.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup12.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup12.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup12.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup12.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup12.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup13.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup13.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup13.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup13.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup13.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup14.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup14.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup14.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup14.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup14.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup15.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup15.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup15.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup15.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup15.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup16.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup16.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup16.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup16.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup16.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup17.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup17.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup17.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup17.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup17.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup18.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup18.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup18.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup18.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup18.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup19.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup19.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup19.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup19.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup19.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup2.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup2.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup2.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup2.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup2.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup20.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup20.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup20.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup20.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup20.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup21.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup21.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup21.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup21.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup21.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup22.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup22.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup22.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup22.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup22.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup23.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup23.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup23.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup23.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup23.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup3.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup3.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup3.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup3.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup3.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup4.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup4.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup4.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup4.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup4.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup5.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup5.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup5.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup5.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup5.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup6.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup6.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup6.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup6.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup6.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup7.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup7.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup7.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup7.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup7.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup8.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup8.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup8.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup8.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup8.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mboxgroup9.appointment
error : Table upgrade required. Please do "REPAIR TABLE `appointment`" or dump/reload to fix it!
mboxgroup9.data_source_item
error : Table upgrade required. Please do "REPAIR TABLE `data_source_item`" or dump/reload to fix it!
mboxgroup9.imap_folder
error : Table upgrade required. Please do "REPAIR TABLE `imap_folder`" or dump/reload to fix it!
mboxgroup9.mail_item
error : Table upgrade required. Please do "REPAIR TABLE `mail_item`" or dump/reload to fix it!
mboxgroup9.pop3_message
error : Table upgrade required. Please do "REPAIR TABLE `pop3_message`" or dump/reload to fix it!
mysql.general_log
Error : You can't use locks with log tables.
mysql.slow_log
Error : You can't use locks with log tables.
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.mobile_devices
error : Table upgrade required. Please do "REPAIR TABLE `mobile_devices`" 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!
zimbra.volume
error : Table upgrade required. Please do "REPAIR TABLE `volume`" or dump/reload to fix it!

To my knowledge, no disk errors happened on the server.

What could be the possible causes ?

The REPAIR TABLE option mentioned here is a zimbra function ? how do I activate this command line and make sure it doesn't happen again ?

Thanks.

[phoenix]

Run the MySQL table upgrade as mentioned in the Release Notes.

[dkbk]

Originally Posted by phoenix

Run the MySQL table upgrade as mentioned in the Release Notes.

My bad.

I totally skipped that section in the release notes as I had misread it as being part of the multi-server setup.

Thanks, I'll have it run next saturday night.

[borngunners]

I ran the mysql table upgrade last week and receive the same error message this week. Seems like the message is coming up on a weekly basis

[phoenix]

Originally Posted by borngunners

I ran the mysql table upgrade last week and receive the same error message this week. Seems like the message is coming up on a weekly basis

Once the table upgrade has been done the messages do not reappear, if you're seeing them again I'd suggest the upgrade didn't run correctly - check the MySQL table and see what happened to them.