[CPANEL-29935] MySQL® service failures after update to latest version

Status
Not open for further replies.

servio

Member
Jun 6, 2019
8
0
1
UK
cPanel Access Level
Root Administrator
Hello,

On my 15 OVZ 6 containter MySQL service stop working after latest night cPanel cron

Newest kernel on one node, older on 2nd node

[moderator note: removed pasted output]
 

servio

Member
Jun 6, 2019
8
0
1
UK
cPanel Access Level
Root Administrator
Not sure why moderator removed output but each upcp logs have this error

[2019-10-14 03:36:10 +0000] E [/usr/local/cpanel/scripts/mysqlconnectioncheck] The “/usr/local/cpanel/scripts/mysqlconnectioncheck” command (process 13983) reported error number 1 when it ended.

Also e-mails from cPanel Monitoring service

The chkservd process has become non-responsive.


The chkservd subprocess with PID “26185” ran for “5 minutes and 1 second”. The system terminated this sub-process when it exceeded the time allowed between checks, which is “5 minutes”. To determine why, check the “ /var/log/chkservd.log ” and “ /usr/local/cpanel/logs/tailwatchd_log ” files.


One OVZ node restarted and nothing happend

I think that is global issue because both OVZ 6 servers hosted in another companies with different hardware specs and different kernels.. Centos 7 template from openvz.org templates for each, oldest containter = 432 days, newest = 4 days
 

icandoit

Well-Known Member
Dec 21, 2010
79
1
58
I had the same issue I checked my.cnf and I noticed /etc/my.cnf
the end line I had added
sql_mode=""
the "" had disappeard so there was no arguments passed resulting in the error
so I fixed it by putting back ""
 
  • Like
Reactions: cPanelLauren

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,203
363
Hello Everyone,

We're currently investigating reports of MySQL® failing to start after the update to MySQL® version 5.7.28. For reference, the internal case number is CPANEL-29935. I'll monitor this case and update this thread with more information as soon as it's available.

In the meantime, please open a support ticket if MySQL® is failing to start and we'll take a closer look at the affected system.

Thank you.
 
Last edited:

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,297
1,251
313
Houston
Status
Not open for further replies.