[SOLVED] Zimbra 7.0.1 Database Issue after upgrade

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
Post Reply
n.bochev
Posts: 25
Joined: Sat Sep 13, 2014 12:39 am

[SOLVED] Zimbra 7.0.1 Database Issue after upgrade

Post by n.bochev »

We recently updated few of our servers to 7.0.1 ( OS ) and we got warnings about database errors. Running the upgrade script again ( 7.0.1 -> 7.0.1 ), shows the following :


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!

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!

mboxgroup1.appointment

note : The storage engine for the table doesn't support repair

mboxgroup1.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup1.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup1.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup1.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup10.appointment

note : The storage engine for the table doesn't support repair

mboxgroup10.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup10.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup10.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup10.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup11.appointment

note : The storage engine for the table doesn't support repair

mboxgroup11.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup11.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup11.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup11.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup12.appointment

note : The storage engine for the table doesn't support repair

mboxgroup12.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup12.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup12.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup12.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup13.appointment

note : The storage engine for the table doesn't support repair

mboxgroup13.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup13.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup13.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup13.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup14.appointment

note : The storage engine for the table doesn't support repair

mboxgroup14.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup14.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup14.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup14.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup15.appointment

note : The storage engine for the table doesn't support repair

mboxgroup15.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup15.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup15.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup15.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup16.appointment

note : The storage engine for the table doesn't support repair

mboxgroup16.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup16.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup16.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup16.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup17.appointment

note : The storage engine for the table doesn't support repair

mboxgroup17.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup17.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup17.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup17.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup18.appointment

note : The storage engine for the table doesn't support repair

mboxgroup18.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup18.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup18.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup18.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup19.appointment

note : The storage engine for the table doesn't support repair

mboxgroup19.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup19.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup19.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup19.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup2.appointment

note : The storage engine for the table doesn't support repair

mboxgroup2.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup2.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup2.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup2.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup3.appointment

note : The storage engine for the table doesn't support repair

mboxgroup3.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup3.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup3.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup3.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup4.appointment

note : The storage engine for the table doesn't support repair

mboxgroup4.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup4.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup4.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup4.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup5.appointment

note : The storage engine for the table doesn't support repair

mboxgroup5.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup5.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup5.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup5.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup6.appointment

note : The storage engine for the table doesn't support repair

mboxgroup6.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup6.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup6.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup6.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup7.appointment

note : The storage engine for the table doesn't support repair

mboxgroup7.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup7.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup7.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup7.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup8.appointment

note : The storage engine for the table doesn't support repair

mboxgroup8.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup8.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup8.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup8.pop3_message

note : The storage engine for the table doesn't support repair

mboxgroup9.appointment

note : The storage engine for the table doesn't support repair

mboxgroup9.data_source_item

note : The storage engine for the table doesn't support repair

mboxgroup9.imap_folder

note : The storage engine for the table doesn't support repair

mboxgroup9.mail_item

note : The storage engine for the table doesn't support repair

mboxgroup9.pop3_message

note : The storage engine for the table doesn't support repair

zimbra.config

note : The storage engine for the table doesn't support repair

zimbra.deleted_account

note : The storage engine for the table doesn't support repair

zimbra.mailbox

note : The storage engine for the table doesn't support repair

zimbra.mailbox_metadata

note : The storage engine for the table doesn't support repair

zimbra.mobile_devices

note : The storage engine for the table doesn't support repair

zimbra.out_of_office

note : The storage engine for the table doesn't support repair

zimbra.scheduled_task

note : The storage engine for the table doesn't support repair

zimbra.table_maintenance

note : The storage engine for the table doesn't support repair

zimbra.volume

note : The storage engine for the table doesn't support repair


The errors persist after the upgrade. This is on ubuntu 10.04 x64 .

Any clues ?
n.bochev
Posts: 25
Joined: Sat Sep 13, 2014 12:39 am

[SOLVED] Zimbra 7.0.1 Database Issue after upgrade

Post by n.bochev »

The strange thing is a clean install of 7.0.1 does not have this issue. All of the installations that show those errors, are in fact upgraded from 6.x versions to 7.x .
phoenix
Ambassador
Ambassador
Posts: 27272
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

[SOLVED] Zimbra 7.0.1 Database Issue after upgrade

Post by phoenix »

[quote user="n.bochev"]We recently updated few of our servers to 7.0.1 ( OS ) and we got warnings about database errors. Running the upgrade script again ( 7.0.1 -> 7.0.1 ), shows the following :[/QUOTE]Why did you you do that? Read the Release Notes (you should always do this before an upgrade) or search the forums for what you should do next.
Regards

Bill

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
n.bochev
Posts: 25
Joined: Sat Sep 13, 2014 12:39 am

[SOLVED] Zimbra 7.0.1 Database Issue after upgrade

Post by n.bochev »

[quote user="10330phoenix"]Why did you you do that? Read the Release Notes (you should always do this before an upgrade) or search the forums for what you should do next.[/QUOTE]


Gotcha. I thought it would be upgraded automatically.

Thanks.
Post Reply