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

[Extra]

Server operating system version

Ubuntu 18.04

Plesk version and microupdate number

18.0.41

Hi! Yesterday evening around 7pm I received the following error message from 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	79

My Database: MariaDB 10.6

 

[IgorG]

Please check these KB articles:

Plesk inaccessible: SQLSTATE[HY000] [2002] No such file or directory

Applicable to: Plesk for Linux Symptoms Plesk inaccessible with the following error: PLESK_ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory The following erro...

support.plesk.com

https://support.plesk.com/hc/en-us/articles/360000331033-Errors-during-Plesk-Update-ERROR-Zend-Db-Adapter-Exception-SQLSTATE-HY000-2002-No-such-file-or-directory-

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

 

[Extra]

Please check these KB articles:

Plesk inaccessible: SQLSTATE[HY000] [2002] No such file or directory

Applicable to: Plesk for Linux Symptoms Plesk inaccessible with the following error: PLESK_ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory The following erro...

support.plesk.com

With this resolution I get:

root@hXXXXXX:~# #log_bin = /var/log/mysql/mariadb-bin
root@hXXXXXX::~# #log_bin_index = /var/log/mysql/mariadb-bin.inde
root@hXXXXXX::~# #log_slow_verbosity = query_plan
root@hXXXXXX::~# systemctl restart mysql
Job for mariadb.service failed because the control process exited with error code.
See "systemctl status mariadb.service" and "journalctl -xe" for details.

 

[IgorG]

root@hXXXXXX:~# #log_bin = /var/log/mysql/mariadb-bin
root@hXXXXXX::~# #log_bin_index = /var/log/mysql/mariadb-bin.inde
root@hXXXXXX::~# #log_slow_verbosity = query_plan

Sorry, but you shouldn't run these lines. Please read instruction carefully:

Comment out the following lines in /etc/my.cnf

 

[mow]

Error SQLSTATE[HY000] [2002] No such file or directory means that the socket which plesk needs to connect to the sql server does not exist, usually because the sql server crashed.
To see why it crashed, use the commands suggested by systemctl, systemctl status mariadb.service and journalctl -xe.

Before you make any changes to the mysql or mariadb config files, make a backup of said config file and all of /var/lib/mysql.

 

[Extra]

Hi!

The bind-address was wrong in /etc/my.cnf.
I changed it from bind-address = ::ffff:127.0.0.1 to bind-address = 127.0.0.1

Resolved!

See: https://support.plesk.com/hc/en-us/...-on-TCP-IP-port-Got-error-22-Invalid-argument

 

[tanermetin]

thank you @Extra