Issue Help!! Server Error500 Plesk\Exception\Database

[Space Monkey]

Server operating system version

Ubuntu 22.04

Plesk version and microupdate number

18.0.54.4

I don't know wth happened, first time in 3 years, anyway, haven't checked my WP project in a month or 2 and when I checked today I see the WP message cant connect to database..ok strange, let me log into plesk.

I get a screen saying:

Server Error
500 Plesk\Exception\Database

DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Type    Plesk\Exception\Database
Message    DB query failed: SQLSTATE[HY000] [2002] No such file or directory
File    Mysql.php
Line    79

When I press the repair kit it asks for my username and PW, entered it, doesn't accept it.
So to the terminal it is. I try plesk repair all and get the following:

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

What on earth happened?? Because I haven't touched or changed anything the last time I logged and then everything was still working.

 

[Space Monkey]

took a screenshot from the startup and it seems mariadb dont start. Tried what it said:
systemct1 status mariadb.service
But says command not found

 

[Kaspar]

[...] What on earth happened?? Because I haven't touched or changed anything the last time I logged and then everything was still working.

Could be a multitude of things. Perhaps MySQL got corrupted, or maybe you've ran out of disk space for MySQL to run? Could be other things too.

Here are some support article that match the error that might help you.

https://support.plesk.com/hc/en-us/articles/12377525077399-Plesk-and-websites-are-not-accessible-ERROR-Zend-Db-Adapter-Exception-SQLSTATE-HY000-2002-No-such-file-or-directory

https://support.plesk.com/hc/en-us/articles/12377562126743-MySQL-fails-to-start-when-a-Plesk-server-lacks-disk-space-SQLSTATE-HY000-No-space-left-on-device-500-Plesk-Exception-Database

https://support.plesk.com/hc/en-us/articles/12377510689943-The-error-in-Plesk-ERR-panel-SQLSTATE-HY000-2002-No-such-file-or-directory-Can-t-connect-to-local-MySQL-server-through-socket

https://support.plesk.com/hc/en-us/articles/12377589709463-Plesk-shows-SQLSTATE-HY000-2002-No-such-file-or-directory-on-Linux-InnoDB-Unable-to-lock-ibdata1-error-11

 

[Space Monkey]

Could be a multitude of things. Perhaps MySQL got corrupted, or maybe you've ran out of disk space for MySQL to run? Could be other things too.

Here are some support article that match the error that might help you.

https://support.plesk.com/hc/en-us/articles/12377525077399-Plesk-and-websites-are-not-accessible-ERROR-Zend-Db-Adapter-Exception-SQLSTATE-HY000-2002-No-such-file-or-directory

https://support.plesk.com/hc/en-us/articles/12377562126743-MySQL-fails-to-start-when-a-Plesk-server-lacks-disk-space-SQLSTATE-HY000-No-space-left-on-device-500-Plesk-Exception-Database

https://support.plesk.com/hc/en-us/articles/12377510689943-The-error-in-Plesk-ERR-panel-SQLSTATE-HY000-2002-No-such-file-or-directory-Can-t-connect-to-local-MySQL-server-through-socket

https://support.plesk.com/hc/en-us/articles/12377589709463-Plesk-shows-SQLSTATE-HY000-2002-No-such-file-or-directory-on-Linux-InnoDB-Unable-to-lock-ibdata1-error-11

Got more than enough diskspace, 32gb disk and its just plesk and a WP site with nothing on it yet. Ill check some of the others, I want to fix it although, I could just as easily just wipe the server and start over gheghe but that's the easy way.

 

[Space Monkey]

Tried commands from the articles, says everywhere no such file or directory. I think this happened when I upgraded the mariaDB as the current version wasn't supported anymore.

Fortunately I have a snapshot before I upgraded gheghe so going to restore it. Strange thing is, I also upgraded the DB on a other server but that one is working fine.

 

[Peter Debik]

It's not "systemct1", but "systemctl".

 

[Space Monkey]

It's not "systemct1", but "systemctl".

Dumb me!! Soon I'm going to learn all these commands! Ty for the correction!

 

[AntoineZ]

I don't know wth happened, first time in 3 years, anyway, haven't checked my WP project in a month or 2 and when I checked today I see the WP message cant connect to database..ok strange, let me log into plesk.

I get a screen saying:

Server Error
500 Plesk\Exception\Database

DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Type    Plesk\Exception\Database
Message    DB query failed: SQLSTATE[HY000] [2002] No such file or directory
File    Mysql.php
Line    79

When I press the repair kit it asks for my username and PW, entered it, doesn't accept it.
So to the terminal it is. I try plesk repair all and get the following:

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

What on earth happened?? Because I haven't touched or changed anything the last time I logged and then everything was still working.

Same situation here, on multiple servers running Ubuntu and Plesk. Suddenly all database interaction fails. Restarting the server doesn't help. I had to reinstall everything and restore a backup.

This happened on multiple servers all in the same week and I see other users experiencing the same problem. That can't be a coincidence. Could it be a bug in an update?

 

[Peter Debik]

This happened on multiple servers all in the same week and I see other users experiencing the same problem. That can't be a coincidence. Could it be a bug in an update?

With 380,000+ physical servers running Plesk and 11+ million websites naturally there are always others who happen to experience similar issues. If you want to find out the reason why MariaDB does not start, it is essential to check the log entries in journald or /var/log/messages (/var/log/syslog) for mariadb related lines.