[SOLVED] Database Integrity Check Report

Discuss your pilot or production implementation with other Zimbra admins or our engineers.
mmorse
Ambassador
Ambassador
Posts: 6036
Joined: Fri Sep 12, 2014 10:24 pm

[SOLVED] Database Integrity Check Report

Postby mmorse » Mon Feb 21, 2011 8:19 am

"You can't use locks with log tables" > ignore.
Running table checks implicitly locks the table (equivalent to executing 'LOCK TABLES') to prevent concurrency issues. The log engine is a table type (just like myisam and innodb) that was introduced in 5.1 which do not need - and thus do not support - locking. The mysql slow log and general log use said engine by default.
Long story short, the message you are seeing is harmless & will be addressed in MySQL Bugs: #30487: mysql_upgrade mislead. errors / mysqlcheck 'You can't use locks with log table.' or MySQL Bugs: #43829: mysql_upgrade and log tables


12237Dirk
Outstanding Member
Outstanding Member
Posts: 902
Joined: Fri Sep 12, 2014 10:10 pm

[SOLVED] Database Integrity Check Report

Postby 12237Dirk » Mon Feb 21, 2011 8:25 am

Well that worked:

[QUOTE].
Altered 83 mailbox groups in 378 seconds[/QUOTE]

I guess I can close the support call. Getting an error email with hundreds of errors in it late at night was just a little alarming.

Here's to a quiet night ;)
cpaul_carling
Posts: 33
Joined: Sat Sep 13, 2014 1:36 am

[SOLVED] Database Integrity Check Report

Postby cpaul_carling » Mon Feb 21, 2011 1:57 pm

@Dirk:
Just to clarify, you did not shut Zimbra services down while you ran that script, and everything worked correctly?
I would have been nice if the release notes had given more specifics about when to run the script (online/offline), etc.
phoenix
Ambassador
Ambassador
Posts: 26781
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

[SOLVED] Database Integrity Check Report

Postby phoenix » Mon Feb 21, 2011 2:01 pm

[quote user="cpaul_carling"]Just to clarify, you did not shut Zimbra services down while you ran that script, and everything worked correctly?[/QUOTE]You don't need to shutdown Zimbra to run the script.
Regards

Bill

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
sdrury
Advanced member
Advanced member
Posts: 163
Joined: Fri Sep 12, 2014 11:42 pm

[SOLVED] Database Integrity Check Report

Postby sdrury » Tue Feb 22, 2011 7:44 pm

I ran it on our server while it was running with no issues.
Sean.
batfastad
Outstanding Member
Outstanding Member
Posts: 281
Joined: Fri Sep 12, 2014 10:43 pm

[SOLVED] Database Integrity Check Report

Postby batfastad » Fri May 27, 2011 11:18 am

I've only just been alerted to these messages appearing in the admin mailbox, and we've been running v7 for a few months now.
Upgraded to 7.1.0 a few weeks ago and we're still getting these e-mails once per week.
Do I still need to run that script?

Completely missed that in the release notes.
Cheers, B
phoenix
Ambassador
Ambassador
Posts: 26781
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

[SOLVED] Database Integrity Check Report

Postby phoenix » Fri May 27, 2011 11:25 am

[quote user="batfastad"]I've only just been alerted to these messages appearing in the admin mailbox, and we've been running v7 for a few months now.[/QUOTE]Which messages are you talking about? The 'error' message message about table locks can be ignored and if it's the table 'upgrade' then you need to do the upgrade.
Regards

Bill

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
batfastad
Outstanding Member
Outstanding Member
Posts: 281
Joined: Fri Sep 12, 2014 10:43 pm

[SOLVED] Database Integrity Check Report

Postby batfastad » Sat May 28, 2011 4:54 am

Yeah it's the message about table upgrade required.
But since I'm running 7.1.0, should I still run the upgrade script at:

/opt/zimbra/libexec/scripts/migrate20100913-Mysql51.pl
Or is that just for 7.0.0?
Cheers, B
phoenix
Ambassador
Ambassador
Posts: 26781
Joined: Fri Sep 12, 2014 9:56 pm
Location: Liverpool, England

[SOLVED] Database Integrity Check Report

Postby phoenix » Sat May 28, 2011 5:43 am

If you're getting the message you need to run the table upgrade script.
Regards

Bill

Rspamd: A high performance spamassassin replacement

Per ardua ad astra
batfastad
Outstanding Member
Outstanding Member
Posts: 281
Joined: Fri Sep 12, 2014 10:43 pm

[SOLVED] Database Integrity Check Report

Postby batfastad » Sat May 28, 2011 6:05 am

Done. We'll see what happens!

Cheers, B

Return to “Administrators”

Who is online

Users browsing this forum: No registered users and 11 guests