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

[yigitvp]

i got this error while updating the database

I tried many things but could not solve

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

 

[IgorG]

I think this problem is addressed in the following KB - Unable to log in to Plesk: 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Does this solve your issue?

 

[mycontrol]

I think this problem is addressed in the following KB - Unable to log in to Plesk: 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Does this solve your issue?

support KB article does not open
Same problem here

Error:

mariadb.service - MariaDB 10.4.17 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
Active: failed (Result: exit-code) since Wed 2020-12-09 18:31:18 UTC; 2s ago
Docs: man:mysqld(8)
systemd
Process: 29926 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Process: 29846 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 29837 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 29831 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Main PID: 29926 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"

Dec 09 18:31:16 subdomain.example.com systemd[1]: Starting MariaDB 10.4.17 database server...
Dec 09 18:31:16 subdomain.example.com mysqld[29926]: 2020-12-09 18:31:16 0 [Note] /usr/sbin/mysqld (mysqld 10.4.17-MariaDB-1:10.4.17+maria~bionic) starting as process 29926 ...
Dec 09 18:31:18 subdomain.example.com systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Dec 09 18:31:18 subdomain.example.com systemd[1]: mariadb.service: Failed with result 'exit-code'.
Dec 09 18:31:18 subdomain.example.com systemd[1]: Failed to start MariaDB 10.4.17 database server.


Journal:



Journal file /var/log/journal/ec2454742ee74ac4c27c2cdb4a0e3688/user-10003.journal is truncated, ignoring file.
Dec 09 19:27:07 subdomain.example.com sw-engine-pleskrun[19575]: Plesk\Session\Helper::initStorage()
Dec 09 19:27:07 subdomain.example.com sw-engine-pleskrun[19575]: 3: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:52
Dec 09 19:27:07 subdomain.example.com sw-engine-pleskrun[19575]: CommonPanel_Application_Abstract->run()
Dec 09 19:27:07 subdomain.example.com sw-engine-pleskrun[19575]: 4: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:34
Dec 09 19:27:07 subdomain.example.com sw-engine-pleskrun[19575]: CommonPanel_Application_Abstract::init()
Dec 09 19:27:07 subdomain.example.com sw-engine-pleskrun[19575]: 5: /opt/psa/admin/plib/pm/Bootstrap.php:16
Dec 09 19:27:07 subdomain.example.com sw-engine-pleskrun[19575]: pm_Bootstrap::init()
Dec 09 19:27:07 subdomain.example.com sw-engine-pleskrun[19575]: 6: /opt/psa/admin/plib/sdk.php:11
Dec 09 19:27:07 subdomain.example.com sw-engine-pleskrun[19575]: require_once(string '/opt/psa/admin/plib/sdk.php')
Dec 09 19:27:07 subdomain.example.com sw-engine-pleskrun[19575]: 7: /opt/psa/admin/plib/WebSocket/bin/ws-server.php:3
Dec 09 19:27:07 subdomain.example.com sw-engine-pleskrun[19575]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] No such file or directory (Mysql.php:64)
Dec 09 19:27:07 subdomain.example.com systemd[1]: plesk-web-socket.service: Main process exited, code=exited, status=1/FAILURE
Dec 09 19:27:07 subdomain.example.com systemd[1]: plesk-web-socket.service: Failed with result 'exit-code'.
Dec 09 19:27:07 subdomain.example.com grafana-server[1524]: t=2020-12-09T19:27:07+0000 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=3 name="Mail server memory usage" error="tsdb.HandleRequest() error rpc error: code = Unknown desc = invalid statuDec 09 19:27:10 subdomain.example.com CRON[18868]: pam_unix(cron:session): session closed for user nodequery
Dec 09 19:27:10 subdomain.example.com sshd[19619]: Received disconnect from 221.181.185.198 port 37124:11: [preauth]
Dec 09 19:27:10 subdomain.example.com sshd[19619]: Disconnected from authenticating user root 221.181.185.198 port 37124 [preauth]
Dec 09 19:27:12 subdomain.example.com systemd[1]: plesk-web-socket.service: Service hold-off time over, scheduling restart.
Dec 09 19:27:12 subdomain.example.com systemd[1]: plesk-web-socket.service: Scheduled restart job, restart counter is at 591.

 

[oj_]

IgorG , could you kindly reshare the link. It is broken. I'm experiencing a similar issue. Much appreciated.​

 

[IgorG]

https://support.plesk.com/hc/en-us/articles/360019172000-Unable-to-access-Plesk-with-500-error-message-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

https://support.plesk.com/hc/en-us/articles/360001641033-Plesk-UI-is-unresponsive-Zend-Db-Adapter-Exception-SQLSTATE-HY000-2002-No-such-file-or-directory

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-

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