Missing /var/run/mariadb after reboot

[ryanz]

Hi,

Something strange I found recently.
Running Plesk Onyx 17.8.11 with Cloudlinux 7.6 on CentOS7

The server restarts but MariaDB/Mysql does not start.
The issue is that /var/run/mariadb folder does not exist after the reboot.

To solve temporarily, create the mariadb folder inside /var/run and change permissions to mysql:mysql

Then systemctl start mariadb and systemctl start mysqld

All good.
But missing again after a reboot.

[skhristich]

Hello Ryan!
Please check if you have entries about the need to create this directory in /usr/lib/tmpfiles.d/mysql.conf
for example:

> egrep -r /var/run /usr/lib/tmpfiles.d | grep mysql
> /usr/lib/tmpfiles.d/mysql.conf:d /var/run/mysqld 0755 mysql mysql -

mariadb:

> egrep -r /var/run /usr/lib/tmpfiles.d | grep mariadb

if not, try adding a line:

> d /var/run/mariadb 0755 mysql mysql -

If can you open a support ticket https://cloudlinux.zendesk.com/hc/en-us/requests/new so we can take a closer look at your system? You can post the ticket number here and well link this thread to it.

Thank you.