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

[Samuel Desloges]

HI,
After upgrading MariaDB like here:

 How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.x on Linux?

Applicable to: Plesk for Linux Question How to upgrade MySQL 5.5 to 5.6/5.7 or MariaDB 5.5 to 10.X on Linux? Answer This article provides instructions for upgrading MySQL 5.5 to 5.6/5.7 and Mari...

support.plesk.com

I can't access to Plesk:

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	60

I can't restart MariaDB, with the ssh command:
# systemctl restart mariadb
Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.



How to repair access to plesk?

Thanks.

 

[G J Piper]

Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.

What were your details?

 

[Samuel Desloges]

Hi,
you can see "journalctl -xe here.

Thanks.

 

[Samuel Desloges]

systemctl status mysql.service
● mysql.service - LSB: start and stop MariaDB
Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)
Active: failed (Result: exit-code) since Sun 2020-05-03 09:44:04 CEST; 22min ago
Docs: man:systemd-sysv-generator(8)
Process: 21147 ExecStart=/etc/rc.d/init.d/mysql start (code=exited, status=1/FAILURE)

May 03 09:44:02 ns397050.ip-94-23-52.eu systemd[1]: Starting LSB: start and s...
May 03 09:44:02 ns397050.ip-94-23-52.eu mysql[21147]: Starting MariaDB.200503...
May 03 09:44:02 ns397050.ip-94-23-52.eu mysql[21147]: 200503 09:44:02 mysqld_...
May 03 09:44:04 ns397050.ip-94-23-52.eu mysql[21147]: ./etc/rc.d/init.d/mysql...
May 03 09:44:04 ns397050.ip-94-23-52.eu mysql[21147]: ERROR!
May 03 09:44:04 ns397050.ip-94-23-52.eu systemd[1]: mysql.service: control pr...
May 03 09:44:04 ns397050.ip-94-23-52.eu systemd[1]: Failed to start LSB: star...
May 03 09:44:04 ns397050.ip-94-23-52.eu systemd[1]: Unit mysql.service entere...
May 03 09:44:04 ns397050.ip-94-23-52.eu systemd[1]: mysql.service failed.
Hint: Some lines were ellipsized, use -l to show in full.

 

[Samuel Desloges]

Is it maybe possible to restore MariaDB with the dump created before the upgrade corruption?
Yesterday, before the upgrade, the system was ok!

 

[G J Piper]

is there any hint in /var/log/messages ?

It looks to me like you have serious problems even starting mysql.

This shows it didn't successfully start:

systemctl status mysql.service
● mysql.service - LSB: start and stop MariaDB
  Loaded: loaded (/etc/rc.d/init.d/mysql; bad; vendor preset: disabled)
  Active: failed (Result: exit-code) since Sun 2020-05-03 09:44:04 CEST; 22min ago
    Docs: man:systemd-sysv-generator(8)
 Process: 21147 ExecStart=/etc/rc.d/init.d/mysql start (code=exited, status=1/FAILURE)

The database data may be intact already so a dump may not be the place to start.

 

[Samuel Desloges]

Thank you so much to Nelson. He was so patient and sorted out the issue I had with Plesk and my server.
Nelson is highly professional and dedicated.
Neslon is an expert and I would recommend him to all users.

 

[G J Piper]

Maybe you could post the solution if possible so others can benefit from it?

 

[boosterfan]

Yes, same error here... Suddenly without doing anything error:

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

Can not restart mariadb service...

What can we do? Very urgent...

 

[casperxs]

hi there, i have the same issue, is there anyone an answer? or how to solve, i've been try this

You could first try:
# plesk repair db -y

Then, if that did not solve the issue,
# plesk repair installation

If the issue still exist:
# plesk installer --select-release-current --reinstall-patch --upgrade-installed-components

but nothing

 

[casperxs]

Thank you so much to Nelson. He was so patient and sorted out the issue I had with Plesk and my server.
Nelson is highly professional and dedicated.
Neslon is an expert and I would recommend him to all users.

Share us your solution please!!!

 

[casperxs]

Yes, same error here... Suddenly without doing anything error:

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

Can not restart mariadb service...

What can we do? Very urgent...

are you resolve this issue?

 

[Murat Tamer]

I just installed a new plesk and I saw not working in the morning. Is there a workaround for that? I only installed plesk to a fresh ubuntu 18.04 that's it.

 

[Murat Tamer]

Still no solution. Topic says "solved" but how?

 

[IgorG]

Error message "DB query failed: SQLSTATE[HY000] [2002] No such file or directory" is just an indicator that something wrong with your SQL server. A lot of reason for this failure can be there and no only one common solution. This error means that you have to investigate mysql log and find a reason why mysql server can't start. After that, you have to fix the issue. Some reasons and ways to fix them can be found by a simple search in the KB articles. This is the answer to the question:

Is there a workaround for that?

 

[Murat Tamer]

The thing is. I installed a fresh ubuntu 18.04 and installed fresh plesk. It worked. And then in the morning it was not running.
I installed fresh ubuntu and fresh plesk again. Now it is not working again. So it is the installation problem. That's why I am asking if there's a workaround.

 

[Murat Tamer]

Zero domain inside. after first installation on ubuntu result DB query failed: SQLSTATE[HY000] [2002]

 

[IgorG]

Have you troubleshooted why your MySQL server is stopped there?

 

[Murat Tamer]

No IPV6 on the system

/var/log/mysql/error.log output like that:
2020-06-16 7:18:13 140488270560384 [ERROR] Failed to create a socket for IPv6 '127.0.0.1': errno: 97.
2020-06-16 7:18:13 140488270560384 [ERROR] Can't create IP socket: Address family not supported by protocol
2020-06-16 7:18:13 140488270560384 [ERROR] Aborting

/etc/mysql/my.cnf removing binding solved the problem.
#bind-address = ::ffff:127.0.0.1

What I meant is, plesk installation without any modification, fails if ipv6 is disabled on ubuntu 18.04.

 

[IgorG]

Is this from sql server log? Have you checked sql server log which can be found for your OS according to  Plesk for Linux services logs and configuration files