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

[azizneji]

Server operating system version

plesk

Plesk version and microupdate number

obsidian

when i run
root@plesk:~# journalctl -xe
i get this :
░░
░░ A start job for unit mysql.service has finished with a failure.
░░
░░ The job identifier is 106670 and the job result is failed.
Nov 27 14:59:57 plesk.stecher.tn systemd[1]: Started Plesk Web Socket Service.
░░ Subject: A start job for unit plesk-web-socket.service has finished successfully
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ A start job for unit plesk-web-socket.service has finished successfully.
░░
░░ The job identifier is 106583.
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: [2022-11-27 14:59:57.755] 4920:63837b6db7e97 ERR [panel] DB query failed: SQLSTATE[HY000] [2002] No such fil>
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:103
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: CommonPanel_Application_Abstract::initDbAdapter()
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 2: /opt/psa/admin/plib/Session/Helper.php:176
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: Plesk\Session\Helper::initStorage()
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 3: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:52
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: CommonPanel_Application_Abstract->run()
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 4: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:34
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: CommonPanel_Application_Abstract::init()
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 5: /opt/psa/admin/plib/pm/Bootstrap.php:16
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: pm_Bootstrap::init()
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 6: /opt/psa/admin/plib/sdk.php:11
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: require_once(string '/opt/psa/admin/plib/sdk.php')
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 7: /opt/psa/admin/plib/WebSocket/bin/ws-server.php:3
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] No such file or directory (Mysql.ph>
Nov 27 14:59:57 plesk.stecher.tn systemd[1]: plesk-web-socket.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ An ExecStart= process belonging to unit plesk-web-socket.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Nov 27 14:59:57 plesk.stecher.tn systemd[1]: plesk-web-socket.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ The unit plesk-web-socket.service has entered the 'failed' state with result 'exit-code'.
...skipping...
░░
░░ A start job for unit mysql.service has finished with a failure.
░░
░░ The job identifier is 106670 and the job result is failed.
Nov 27 14:59:57 plesk.stecher.tn systemd[1]: Started Plesk Web Socket Service.
░░ Subject: A start job for unit plesk-web-socket.service has finished successfully
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ A start job for unit plesk-web-socket.service has finished successfully.
░░
░░ The job identifier is 106583.
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: [2022-11-27 14:59:57.755] 4920:63837b6db7e97 ERR [panel] DB query failed: SQLSTATE[HY000] [2002] No such fil>
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 0: /opt/psa/admin/plib/Db/Adapter/Pdo/Mysql.php:79
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: Db_Adapter_Pdo_Mysql->query(string 'SET sql_mode = ''')
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 1: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:103
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: CommonPanel_Application_Abstract::initDbAdapter()
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 2: /opt/psa/admin/plib/Session/Helper.php:176
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: Plesk\Session\Helper::initStorage()
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 3: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:52
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: CommonPanel_Application_Abstract->run()
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 4: /opt/psa/admin/plib/CommonPanel/Application/Abstract.php:34
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: CommonPanel_Application_Abstract::init()
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 5: /opt/psa/admin/plib/pm/Bootstrap.php:16
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: pm_Bootstrap::init()
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 6: /opt/psa/admin/plib/sdk.php:11
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: require_once(string '/opt/psa/admin/plib/sdk.php')
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: 7: /opt/psa/admin/plib/WebSocket/bin/ws-server.php:3
Nov 27 14:59:57 plesk.stecher.tn sw-engine-pleskrun[4920]: ERROR: Plesk\Exception\Database: DB query failed: SQLSTATE[HY000] [2002] No such file or directory (Mysql.ph>
Nov 27 14:59:57 plesk.stecher.tn systemd[1]: plesk-web-socket.service: Main process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ An ExecStart= process belonging to unit plesk-web-socket.service has exited.
░░
░░ The process' exit code is 'exited' and its exit status is 1.
Nov 27 14:59:57 plesk.stecher.tn systemd[1]: plesk-web-socket.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ The unit plesk-web-socket.service has entered the 'failed' state with result 'exit-code'.
Nov 27 14:57:57 plesk.stecher.tn systemd[1]: mysql.service: Failed with result 'exit-code'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ The unit mysql.service has entered the 'failed' state with result 'exit-code'.
Nov 27 14:57:57 plesk.stecher.tn systemd[1]: Failed to start MySQL Community Server.
░░ Subject: A start job for unit mysql.service has failed
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ A start job for unit mysql.service has finished with a failure.
░░
░░ The job identifier is 99514 and the job result is failed.
Nov 27 14:57:57 plesk.stecher.tn systemd[1]: mysql.service: Scheduled restart job, restart counter is at 3.
░░ Subject: Automatic restarting of a unit has been scheduled
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ Automatic restarting of the unit mysql.service has been scheduled, as the result for
░░ the configured Restart= setting for the unit.
Nov 27 14:57:57 plesk.stecher.tn systemd[1]: Stopped MySQL Community Server.
░░ Subject: A stop job for unit mysql.service has finished
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ A stop job for unit mysql.service has finished.
░░
░░ The job identifier is 99601 and the job result is done.
Nov 27 14:57:57 plesk.stecher.tn systemd[1]: Starting MySQL Community Server...
░░ Subject: A start job for unit mysql.service has begun execution
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ A start job for unit mysql.service has begun execution.
░░
░░ The job identifier is 99601.
Nov 27 14:57:57 plesk.stecher.tn mysql-systemd-start[4806]: MySQL has been frozen to prevent damage to your system. Please see /etc/mysql/FROZEN for help.
Nov 27 14:57:57 plesk.stecher.tn systemd[1]: mysql.service: Control process exited, code=exited, status=1/FAILURE
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ An ExecStartPre= process belonging to unit mysql.service has exited.

 

[IgorG]

Issue - Server Error: 500 Plesk\Exception\Database

This is my first post here, so sorry if I get anything wrong. I have an error message, and I am not sure how to fix it. Any suggestions? DB query failed: SQLSTATE[HY000] [2002] No such file or directory Type Plesk\Exception\Database Message DB query failed: SQLSTATE[HY000] [2002] No such...

talk.plesk.com