SOLVED [CPANEL-27618/27634] False SQL service failure notifications in version 80

[cPanelMichael]

Hello Everyone,

Internal case CPANEL-27618 is open to address an issue where false SQL service failures are reported after the update to cPanel & WHM version 80.0.9 on systems where MariaDB is started improperly via the LSB init script.

Here's an example of how the service failure notification looks on affected systems:

Service Name mysql
Service Status failed
Notification The service “mysql” appears to be down.
Service Check Method The system’s command to check or to restart this service failed.

Here's an example of the output from the "systemctl status mysql" command on affected systems:

# systemctl status mysql
● mysql.service - LSB: start and stop MariaDB
Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)

The temporary workaround is to execute the following commands as root:

systemctl stop mariadb
/scripts/restartsrv_mysql --start

We're tentatively planning to publish a new build later today to correct this issue. I'll monitor the case and update this thread as soon as the new build is published.

Thank you.

 

[cPanelMichael]

Hello Everyone,

cPanel & WHM version 80.0.10 is now published to the RELEASE, CURRENT, and EDGE release tiers with the following fix:

Fixed case CPANEL-27618: Automatically restart MariaDB during maintenance on systemd-based systems if it was incorrectly started via the LSB init script.

An additional case, CPANEL-27634, is open to address an issue where MariaDB is reported as down after the update to cPanel & WHM version 80 on servers using CentOS/RHEL/CloudLinux 7.x with MySQL init scripts that do not redirect to call systemctl.

I'll update this thread with more information on the status of CPANEL-27634 as it becomes available.

Let us know if you have any questions.

Thank you.

 

[cPanelMichael]

Hello Everyone,

cPanel & WHM version 80.0.12 is now published to the CURRENT and EDGE release tiers with the following fix:

Fixed case CPANEL-27634: Improve MariaDB automatic restart handling when LSB init script was used on systemd-based systems.

I'll update this thread again once version 80.0.12 enters the RELEASE tier.

Let us know if you have any questions.

Thank you.