[SOLVED] New zcs 7 install : database errors founds

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
dkbk
Advanced member
Advanced member
Posts: 67
Joined: Sat Sep 13, 2014 12:32 am

[SOLVED] New zcs 7 install : database errors founds

Postby dkbk » Mon Feb 28, 2011 8:19 am

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
Ambassador
Ambassador
Posts: 26407
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

[SOLVED] New zcs 7 install : database errors founds

Postby phoenix » Mon Feb 28, 2011 8:33 am

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

Bill

Rspamd: A high performance spamassassin replacement

If you'd like to see this implemented in a future version of ZCS then please vote on Bugzilla entries 97706 & 108168
dkbk
Advanced member
Advanced member
Posts: 67
Joined: Sat Sep 13, 2014 12:32 am

[SOLVED] New zcs 7 install : database errors founds

Postby dkbk » Mon Feb 28, 2011 8:41 am

[quote user="10330phoenix"]Run the MySQL table upgrade as mentioned in the Release Notes.[/QUOTE]
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
Advanced member
Advanced member
Posts: 194
Joined: Sat Sep 13, 2014 12:31 am

[SOLVED] New zcs 7 install : database errors founds

Postby borngunners » Tue Mar 01, 2011 7:44 am

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
Ambassador
Ambassador
Posts: 26407
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

[SOLVED] New zcs 7 install : database errors founds

Postby phoenix » Tue Mar 01, 2011 7:49 am

[quote user="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[/QUOTE]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.
Regards

Bill

Rspamd: A high performance spamassassin replacement

If you'd like to see this implemented in a future version of ZCS then please vote on Bugzilla entries 97706 & 108168

Return to “Administrators”

Who is online

Users browsing this forum: MSN [Bot] and 10 guests