Issues with database integrity check
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 [[[1]]], which has been fixed in 4.5.7
Also the repair table on innoddb table will not worl.