Resolved Plesk won't start mariadb

[Sysop]

We had a problem on our server and all the free space got used up, which caused mariadb to stop.

After freeing up the space and trying to access the Plesk Panel we are presented with:

DB query failed: SQLSTATE[HY000] [2002] No such file or directory

Trying to restart the mariadb process ends in a "Gateway Timeout"

Trying from the command-line:

$ systemctl enable mariadb
$ systemctl start mariadb
... hangs and does nothing ...

Checking with journal -xe:

systemd[1]: Got notification message from PID 12472, but reception only permitted for main PID which is currently not known

Attempting to repair:

$ plesk repair db -y
DB query failed: SQLSTATE[HY000] [2002] Connection refused

Trying to go one step further:

$ plesk repair installation
DB query failed: SQLSTATE[HY000] [2002] No such file or directory

We're dead in the water it seems, what now? Thanks

 

[IgorG]

What kind of error messages in /var/log/mariadb/mariadb.log ?

 

[Sysop]

I ended up killing the "mysql" process and restarting the service after that. For whatever reason the root user for the db was lost somehow. I had to re-create the user and did the repair installation again. It seems to be working fine now.

I would say that maybe the support document regarding this error could be updated with more information as to why it happens and how to resolve the problem perhaps, thanks.