Database errors found

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
Labsy
Outstanding Member
Outstanding Member
Posts: 382
Joined: Sat Sep 13, 2014 12:52 am

Database errors found

Postby Labsy » Fri Apr 01, 2011 2:22 pm

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
Advanced member
Advanced member
Posts: 81
Joined: Sat Sep 13, 2014 1:52 am

Database errors found

Postby John Siu » Fri Apr 01, 2011 2:26 pm

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
Outstanding Member
Outstanding Member
Posts: 382
Joined: Sat Sep 13, 2014 12:52 am

Database errors found

Postby Labsy » Fri Apr 01, 2011 2:47 pm

thanx John,

I'll ignore it :)
Houston
Posts: 14
Joined: Fri Sep 12, 2014 11:39 pm

Database errors found

Postby Houston » Tue Aug 23, 2011 8:11 am

if you want to remove the warning

http://dariodallomo.blogspot.com/2011/08/zimbra-error-mysql-table-upgrade.html">DARIO
DALL'OMO: Zimbra - Error MySql Table upgrade required. Please do "REPAIR TABLE xxx" or dump/reload to fix it!
demanl
Advanced member
Advanced member
Posts: 72
Joined: Fri Sep 12, 2014 10:05 pm

Database errors found

Postby demanl » Mon Apr 30, 2012 5:43 am

[quote user="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.[/QUOTE]
Ok..good..safe to ignore..I like it..sort of like ignoring wifey..:D

Return to “Administrators”

Who is online

Users browsing this forum: Bing [Bot] and 12 guests