MySql service in NetOps Portal fails to start

Products

• CA Performance Management - Usage and Administration
• DX NetOps

Issue/Introduction

The MySql service fails to stay running and times out trying to start.

The systemctl status output shows this. There are no errors in the MySql <hostname>.err log file.

[root@Portal_Host~]$ sudo systemctl status mysql
mysql.service - MySQL daemon
   Loaded: loaded (/etc/systemd/system/mysql.service; enabled; vendor preset: disabled)
   Active: failed (Result: timeout) since Thu 2023-03-09 02:16:08 UTC; 16h ago
  Process: 10443 ExecStart=/opt/CA/MySql/support-files/mysql.server start (code=killed, signal=TERM)
Mar 09 02:13:26 Portal_Host systemd[1]: Starting MySQL daemon...
Mar 09 02:14:56 Portal_Host systemd[1]: mysql.service start operation timed out. Terminating.
Mar 09 02:16:08 Portal_Host mysql.server[10443]: Starting MySQL..........................................................................................
Mar 09 02:16:08 Portal_Host systemd[1]: Failed to start MySQL daemon.
Mar 09 02:16:08 Portal_Host systemd[1]: Unit mysql.service entered failed state.
Mar 09 02:16:08 Portal_Host systemd[1]: mysql.service failed.

Environment

All supported DX NetOps Performance Management Portal web server releases

Cause

MySql is slow to start on the system.

Resolution

Add "TimeoutSec=300" to the /etc/systemd/system/mysql.service file.

Restart the mysql service.

Additional Information

Most often seen in 21.2.8+ releases running the newer MySql 8.x release.