• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • Support for BIND DNS has been removed from Plesk for Windows due to security and maintenance risks.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS.

Issue MySQL 500 Plesk\Exception\Database

MKWDevelopment

New Pleskian
Server Error

500 Plesk\Exception\Database​

DB query failed: SQLSTATE[HY000] [2002] No such file or directory
TypePlesk\Exception\Database
MessageDB query failed: SQLSTATE[HY000] [2002] No such file or directory
FileMysql.php
Line79

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
 
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
 
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
 
Back
Top