Issues with database integrity check

Revision as of 09:56, 6 December 2007 by Vagarwal (talk | contribs)

This Wiki is just an information about the errors you receive during an upgrade from ZCS 4.5.7 to 4.5.x. [Prior to ZCS 4.5.7 this error was not known].

The error which you will receive during the upgrade is:


Generating report 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=NU9WALN1TK110NnZZL7bLBGrI5GLyhV --auto-repair mysql.help_category

error    : Table upgrade required. Please do "REPAIR TABLE `help_category`" to fix it!
mysql.help_keyword
error    : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" to fix it!
mysql.help_topic
error    : Table upgrade required. Please do "REPAIR TABLE `help_topic`" to fix it!
mysql.user
error    : Table upgrade required. Please do "REPAIR TABLE `user`" to fix it!
zimbra.config
error    : Table upgrade required. Please do "REPAIR TABLE `config`" to fix it!
zimbra.mailbox_metadata
error    : Table upgrade required. Please do "REPAIR TABLE `mailbox_metadata`" to fix it!
zimbra.out_of_office
error    : Table upgrade required. Please do "REPAIR TABLE `out_of_office`" to fix it!
zimbra.service_status
error    : Table upgrade required. Please do "REPAIR TABLE `service_status`" to fix it!
zimbra.table_maintenance
error    : Table upgrade required. Please do "REPAIR TABLE `table_maintenance`" to fix it!
zimbra.volume
error    : Table upgrade required. Please do "REPAIR TABLE `volume`" to fix it!

Please DO NOT stop the upgrade due to this error because after this ZCS will run "mysql_upgrade" with the correct parameters to fix the issue.

After the upgrade you can then run "/opt/zimbra/libexec/zmdbintegrityreport" again to verify that there's really no more error.

You don't need to repair the tables manually prior to the upgrade.

The zmdbintegrityreport errors were caused by bug [19008] http://bugzilla.zimbra.com/show_bug.cgi?id=19008, which has been fixed in 4.5.7

Also the repair table on innoddb table will not work.

Jump to: navigation, search