DBMS frequently reloads without reason

Symptoms

The native MySQL or MariaDB database server restarts periodically, even though the DBMS service is active.

Causes

The “srvmon” utility, which monitors information on the PID file or the process name from the process list, restarts the service because it thinks it is not running. The causes can include:

• The database server was installed from a third-party repository rather than the panel;
• The database server PID (process identifier) settings were changed manually;
• An error in the monitoring system arose when determining the service status.

Solution

Specify the correct process name

Ensure that the correct process name for the DBMS is specified in the “Monitoring and logs” - “Services” - “mysql” or “mariadb” - “Change” field in the “Process name” section.

Specify the correct path to the PID file

You can also restore the correct value of the “pid-file” parameter in the configuration files of MySQL or MariaDB services if they have been manually changed or deleted.

Restoring the monitoring service

To restore proper service performance, open the “Notifications” section and remove any restart errors.

In the business version, clear the “problems” table in the panel database on the node causing problems. To do so, run the “sqlite3” utility (install it if not already installed) and execute the command:

sqlite3 /usr/local/mgr5/etc/ispmgrnode_problems.db 'delete from problems';

DBMS parameter table