Issue MySQL 500 Plesk\Exception\Database

[MKWDevelopment]

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

if I try and run
# plesk repair db -y
DB query failed: SQLSTATE[HY000] [2002] No such file or directory

exit status 1

journalctl -xe shows

Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: [2021-12-27 23:21:10.053] 14369:61cabae60cb37 ERR [panel] DB query failed: SQLSTATE[HY000] [2002] No such file or directory:
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: 0: /usr/local/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: 1: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:103
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: CommonPanel_Application_Abstract::initDbAdapter()
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: 2: /usr/local/psa/admin/plib/Session/Helper.php:176
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: Plesk\Session\Helper::initStorage()
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: 3: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:52
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: CommonPanel_Application_Abstract->run()
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: 4: /usr/local/psa/admin/plib/CommonPanel/Application/Abstract.php:34
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: CommonPanel_Application_Abstract::init()
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: 5: /usr/local/psa/admin/plib/pm/Bootstrap.php:16
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: pm_Bootstrap::init()
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: 6: /usr/local/psa/admin/plib/sdk.php:11
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: require_once(string '/usr/local/psa/admin/plib/sdk.php')
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: 7: /usr/local/psa/admin/plib/WebSocket/bin/ws-server.php:3
Dec 27 23:21:10 hostname sw-engine-pleskrun[14369]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] No such file or directory (Mysql.php:79)
Dec 27 23:21:10 hostname systemd[1]: plesk-web-socket.service: main process exited, code=exited, status=1/FAILURE
Dec 27 23:21:10 hostname systemd[1]: Unit plesk-web-socket.service entered failed state.
Dec 27 23:21:10 hostname systemd[1]: plesk-web-socket.service failed.
Dec 27 23:21:12 hostname grafana-server[2850]: t=2021-12-27T23:21:12-0800 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=5 name="Plesk memory usage" error="request
Dec 27 23:21:12 hostname grafana-server[2850]: t=2021-12-27T23:21:12-0800 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=9 name="Real memory usage" error="request
Dec 27 23:21:12 hostname grafana-server[2850]: t=2021-12-27T23:21:12-0800 lvl=eror msg="Alert Rule Result Error" logger=alerting.evalContext ruleId=8 name="Partition \"/boot\" utilization" e

Centos 7
MariaDB 10.5.13

 

[IgorG]

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

A lot of possible reasons. Try to find and fix yours:

https://support.plesk.com/hc/en-us/search?utf8=✓&query=DB+query+failed%3A+SQLSTATE%5BHY000%5D+%5B2002%5D+No+such+file+or+directory&commit=Search

 

[MKWDevelopment]

Hello,

i tried about 3 to 4 pages worth and nothing has worked at all and I can't even make a support ticket as I need the key and I can't even get the key at all

 

[IgorG]

How to get support directly from Plesk?

Question How to get support directly from Plesk? Answer Lease-type Plesk licenses purchased directly from Plesk running on supported Plesk version include full free support. Perpetual-type license...

support.plesk.com

 

[tanermetin]

Any update on this?