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

[servio]

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]

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]

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 ""

 

[cPanelMichael]

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.

 

[cPanelLauren]

Hello,


This issue was found to be an upstream issue and reported as such to the correct entity. The MySQL case ID is MySQL Bugs: #97276: MySQL startup hangs on /dev/random

Updates to this case can be found when checking in on that link.