Database Integrity check report: Errors found

[mcevoys]

Last week, I started getting the following email error report.

From: admin@domain.com [mailto:admin@domain.com]
Sent: Sunday, December 02, 2007 11:01 PM
To: admin@domain.com
Subject: Database Integrity check 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=password
mboxgroup4.open_conversation
error : Corrupt

When I run /opt/zimbra/mysql/bin/mysqlcheck --defaults-file=/opt/zimbra/conf/my.cnf -S /opt/zimbra/db/mysql.sock -A -C -s -u root --password=password, all I get back is:

mboxgroup4.open_conversation
error : Corrupt

Anyone have any ideas here? I want to have a clean database prior to the forthcoming Zimbra5 migration.

[mcevoys]

I think I found the related account. When they try to empty the trash, they get a network error:

msg - system failure: deleting contents for folder 3
code - service.FAILURE
method - ZmCsfeCommand.prototype.invoke
detail - soap:Receiver


I tried reindexing the mailbox, but it didn't correct the condition.

Still not sure how to correct this though...anyone?

[mcevoys]

Anyone have any suggestions?

[mcevoys]

Still requesting help here

[mcevoys]

Ping for help

[jholder]

Hey Sean-
Looks like you've got some bad issues going on. Did you have a power failure or something?

You can't repair those because they're innodb databases.

The only option you really have is to do a total dump. Here's the wiki article on disaster recovery:
Mysql Crash Recovery - Zimbra :: Wiki

Make sure you backup first. That should fix it.

[bhickey]

I take it they're not InnoDB for performance reasons?

[phoenix]

Originally Posted by bhickey

I take it they're not InnoDB for performance reasons?

I believe he said they are innodb databases.

[bhickey]

I misread the eariler post... InnoDB is usually more reliable than some of the other table types.