[Case 185925] check_mysql sends a notification that databases are broken when they cannot be locked

AdamDresch

Well-Known Member
Jun 22, 2006
80
0
156
Hi all,

I just started getting a daily email with the following content:

cPanel & WHM has determined that the following database tables are corrupt:

Database

Error

mysql

mysql.general_log
Error : You can't use locks with log tables.
mysql.slow_log
Error : You can't use locks with log tables.
We recommend that you repair these tables with WHM’s “Repair a MySQL Database” interface (WHM Home » SQL Services » Repair a MySQL Database). If the repair fails, contact cPanel Support for further assistance.
Is anyone else getting these emails? and does anyone have any info on how to stop them?
There's obviously no corrupt tables, given that the two issues it mentions are log files
 

LostNerd

Well-Known Member
Mar 12, 2014
258
12
18
Hastings, East Sussex, UK
cPanel Access Level
Root Administrator
Twitter
Please see this part of the email...

We recommend that you repair these tables with WHM’s “Repair a MySQL Database” interface (WHM Home » SQL Services » Repair a MySQL Database). If the repair fails, contact cPanel Support for further assistance.
You can also try
Code:
mysqlcheck -r DATABASE_NAME
Contact cPanel support so that they can look in to it. :)
 

AdamDresch

Well-Known Member
Jun 22, 2006
80
0
156
Please see this part of the email...



You can also try
Code:
mysqlcheck -r DATABASE_NAME
Contact cPanel support so that they can look in to it. :)
Hiya
Yea I already ran a repair on that database, but the error isn't about corruption, for some reason it sees this message "Error : You can't use locks with log tables." as corruption of tables, when it shouldn't.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
Hello,

Internal case number 185925 is open to address an issue where /script/check_mysql sends out false errors for tables that complain about locks when mysqlcheck is run on their database. You can monitor our change log for the inclusion of this case number at:

cPanel - 11.50 Change Log

Thank you.
 

AdamDresch

Well-Known Member
Jun 22, 2006
80
0
156
Thanks Michael
We did upgrade whm/cpanel on this server, but it still emails us every morning with the same message
Restarting mysql also sends the email too.


cPanel & WHM has determined that the following database tables are corrupt:

Database

Error

mysql

mysql.general_log
Error : You can't use locks with log tables.
mysql.slow_log
Error : You can't use locks with log tables.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
We did upgrade whm/cpanel on this server, but it still emails us every morning with the same message
Restarting mysql also sends the email too.
Please post the output from:

Code:
cat /usr/local/cpanel/version
Thank you.
 

briansol

Active Member
Oct 31, 2007
39
1
58
ct
I also got it for the first time last night. I must've been upgraded by cron task as i haven't been in to whm in a few weeks.
Code:
With your current Update Settings, you will be upgrading to the latest release build.
Code:
# cat /usr/local/cpanel/version
11.50.0.10
I don't care if it's a BS email... but I also didn't get my backup complete email. It looks like the tar/gz files are there, but it's a bit disconcerting that the script didn't finish completely to send the email when done.


I'm looking to upgrade to maria 10, but with this lingering, i'm not sure
 
  • Like
Reactions: bremboy79

LostNerd

Well-Known Member
Mar 12, 2014
258
12
18
Hastings, East Sussex, UK
cPanel Access Level
Root Administrator
Twitter
Oddly, I didn't get one today but nothing has been upgraded or changed.

Ghosts in the machine...
cPanel updates nightly unless you have otherwise specified. It's possible that the update has fixed your issue.

I have a server that had the same email today.
11.50.0 build 10
Code:
/scripts/upcp --force
Give that a shot, hdctest.
 

cPanelNick

Administrator
Staff member
Mar 9, 2015
3,483
35
208
cPanel Access Level
DataCenter Provider
I also got it for the first time last night. I must've been upgraded by cron task as i haven't been in to whm in a few weeks.
Code:
With your current Update Settings, you will be upgrading to the latest release build.
Code:
# cat /usr/local/cpanel/version
11.50.0.10
I don't care if it's a BS email... but I also didn't get my backup complete email. It looks like the tar/gz files are there, but it's a bit disconcerting that the script didn't finish completely to send the email when done.


I'm looking to upgrade to maria 10, but with this lingering, i'm not sure

Hi briansol,

The spurious mysql check notice is solved in 11.50.0.12 (now available in CURRENT)

As for the backup completion email, you probably just need to adjust "Backup Successful" or "Successful Backup" (wording is different in some versions) in the Contact Manager in WHM to make the notification priority higher.

Please see the release notes:
http://documentation.cpanel.net/dis...tprioritiesforalertsinContactManagerinterface
In cPanel & WHM version 11.50, we improved error reports and created separate notifications for critical issues. As a result, we lowered the default priority level for several non-critical alerts in order to reduce the volume of notifications that require no action.

We strongly recommend that you review your alert preferences in WHM's Contact Manager interface (Home >> Server Contacts >> Contact Manager) and make any necessary adjustments.
 

Jay RIgby

Registered
Jun 21, 2015
1
0
1
London
cPanel Access Level
Root Administrator
I have this email - cPanel & WHM has determined that the following database tables are corrupt:
Code:
Database Error
mysql
mysql.help_category
error : Table upgrade required. Please do "REPAIR TABLE `help_category`" or dump/reload to fix it!
mysql.help_keyword
error : Table upgrade required. Please do "REPAIR TABLE `help_keyword`" or dump/reload to fix it!
mysql.help_topic
error : Table upgrade required. Please do "REPAIR TABLE `help_topic`" or dump/reload to fix it!
mysql.proc
error : Table upgrade required. Please do "REPAIR TABLE `proc`" or dump/reload to fix it!
mysql.procs_priv
error : Table upgrade required. Please do "REPAIR TABLE `procs_priv`" or dump/reload to fix it!
mysql.time_zone_name
error : Table upgrade required. Please do "REPAIR TABLE `time_zone_name`" or dump/reload to fix it!
But I cannot see how to under SQL Services » Repair a MySQL Database

Greatly appreciate a pointer!
 
Last edited by a moderator:

kcrnc

Registered
Jun 23, 2015
1
0
1
USA
cPanel Access Level
Root Administrator
This happened on a client site recently...the initial issue where general_log and slow_log report an error via automated emails, but upon repair it is really just a warning.

In my case, Cpanel/WHM was set to auto-upgrade and updated itself to the latest version. However, the mysql server was really old. Going to the SQL Services -> Repair Table section prompted a warning about the old version.

After backing everything up, I upgraded to a more recent version of mysql and the check table no longer reports the error. I believe the issues(along with a warning about Horde and no Innodb support) have been fixed.
 

Mostafaewig

Registered
Jun 24, 2015
3
0
1
UNited
cPanel Access Level
Root Administrator
after upgrade cpanel/whm i have this notification error
where can i find this key? and what should i do?

Code:
cPanel & WHM has determined that the following database tables are corrupt:

Database Error
eximstats
error : Found 12892 keys of 12891
error : Corrupt

We recommend that you repair these tables with WHM’s “Repair a MySQL Database” interface (WHM Home » SQL Services » Repair a MySQL Database). If the repair fails, contact cPanel Support for further assistance.
i did repair database but still i get notification
 

Apoc

Active Member
Mar 4, 2003
25
1
153
cPanel Access Level
DataCenter Provider
We've been getting a bunch more of these across different servers (which all have the latest build running) - looks like this is still ongoing.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,227
463
We've been getting a bunch more of these across different servers (which all have the latest build running) - looks like this is still ongoing.
Hello :)

Could you elaborate on the specific notification that you received? For instance, are you sure it's for the issue discussed on this thread and not because the database referenced is actually corrupted?

Thank you.