• Hi, Pleskians! We are running a UX testing of our upcoming product intended for server management and monitoring.
    We would like to invite you to have a call with us and have some fun checking our prototype. The agenda is pretty simple - we bring new design and some scenarios that you need to walk through and succeed. We will be watching and taking insights for further development of the design.
    If you would like to participate, please use this link to book a meeting. We will sent the link to the clickable prototype at the meeting.
  • (Plesk for Windows):
    MySQL Connector/ODBC 3.51, 5.1, and 5.3 are no longer shipped with Plesk because they have reached end of life. MariaDB Connector/ODBC 64-bit 3.2.4 is now used instead.
  • The Horde webmail has been deprecated. Its complete removal is scheduled for April 2025. For details and recommended actions, see the Feature and Deprecation Plan.

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