Database errors found

[Labsy]

Hi,

when I tried with upgrade from ZCS 7.0.0 to 7.0.1 database integrity checker found these errors:

Verifying integrity of message store databases.  This may take a while.
mysqld is alive
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=cKminGdFnKfF7JgD425v1h1cYvQM                                                             --auto-repair
mysql.general_log
 Error    : You can't use locks with log tables.
 mysql.slow_log
 Error    : You can't use locks with log tables.

I run --auto-repair two times, but still same errors.
Is it safe to sontinue with upgrade?
What's this about "can't use locks with log tables"?

I mean, this bug was reported already for 5.1 version, so it's weird to me it's still present...
...or is it something wrong with my ZCS install?

[John Siu]

auto-repaire will not fix those.

Those error are generated by mysqlcheck, which is a mysql tool, not exactly a zimbra tool. And it is a well know "error" that is safe to ignore.

[Labsy]

thanx John,
I'll ignore it

[Houston]

if you want to remove the warning

Upgrade to Zimbra 7 - Table upgrade required

DARIO DALL'OMO: Zimbra - Error MySql Table upgrade required. Please do "REPAIR TABLE xxx" or dump/reload to fix it!

[demanl]

Originally Posted by John Siu

auto-repaire will not fix those.

Those error are generated by mysqlcheck, which is a mysql tool, not exactly a zimbra tool. And it is a well know "error" that is safe to ignore.

Ok..good..safe to ignore..I like it..sort of like ignoring wifey..