Difference between revisions of "Issues with database integrity check"

(New page: 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 du...)
 
Line 35: Line 35:
 
You don't need to repair the tables manually prior to the upgrade.
 
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
+
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 worl.
+
Also the repair table on innoddb table will not work.

Revision as of 09:56, 6 December 2007

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