Issue ERROR 2002 (HY000): Can't connect to local server through socket '/run/mysqld/mysqld.sock' (2)

[GabrielleC]

Server operating system version

Ubuntu 24.04.4 LTS x86_64

Plesk version and microupdate number

Plesk Obsidian 18.0.76.2

This afternoon arouind 12:50 the server tried doing an update then this occured

Mar 13 12:49:03 friendly-galois.74-208-111-216.plesk.page systemd[1]: mariadb.service: Main process exited, code=dumped, status=6/ABRT
░░ Subject: Unit process exited
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ An ExecStart= process belonging to unit mariadb.service has exited.
░░
░░ The process' exit code is 'dumped' and its exit status is 6.
Mar 13 12:49:03 friendly-galois.74-208-111-216.plesk.page systemd[1]: mariadb.service: Failed with result 'core-dump'.
░░ Subject: Unit failed
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ The unit mariadb.service has entered the 'failed' state with result 'core-dump'.
Mar 13 12:49:03 friendly-galois.74-208-111-216.plesk.page systemd[1]: Failed to start mariadb.service - MariaDB 10.11.14 database server.
░░ Subject: A start job for unit mariadb.service has failed
░░ Defined-By: systemd
░░ Support: Enterprise open source support | Ubuntu
░░
░░ A start job for unit mariadb.service has finished with a failure.
░░
░░ The job identifier is 193921 and the job result is failed.
Mar 13 12:49:03 friendly-galois.74-208-111-216.plesk.page systemd[1]: Started plesk-web-socket.service - 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 194036.

Mar 13 12:48:10 friendly-galois.74-208-111-216.plesk.page sw-engine-pleskrun[60298]: ERROR: Plesk\Exception\Database: DB query failed: (2002) SQLSTATE[HY000] [2002] No such file or directory (Mysql.php:79)
Mar 13 12:48:10 friendly-galois.74-208-111-216.plesk.page systemd[1]: plesk-web-socket.service: Main process exited, code=exited, status=1/FAILURE
Mar 13 12:48:10 friendly-galois.74-208-111-216.plesk.page systemd[1]: plesk-web-socket.service: Failed with result 'exit-code'.
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: [03/13/26 12:48:11] WARNING Knowledge base integration is not __init__.py:19
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: available: No module named
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: 'chromadb'
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: Traceback (most recent call last):
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: File "/usr/local/psa/admin/plib/modules/mcp/libexec/mcpserver.py", line 480, in <module>
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: asyncio.run(main())
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: File "/opt/plesk/python/3/lib/python3.10/asyncio/runners.py", line 44, in run
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: return loop.run_until_complete(main)
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: File "/opt/plesk/python/3/lib/python3.10/asyncio/base_events.py", line 649, in run_until_complete
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: return future.result()
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: File "/usr/local/psa/admin/plib/modules/mcp/libexec/mcpserver.py", line 353, in main
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: plesk_mcp = await create_mcp_server("Plesk", "/api/v2", "/openapi.json")
Mar 13 12:48:11 friendly-galois.74-208-111-216.plesk.page python3[60189]: File "/usr/local/psa/admin/plib/modules/mcp/libexec/mcpserver.py", line 279, in create_mcp_server

exit status 1
root@friendly-galois:/var/log#

root@friendly-galois:~# plesk repair all
DB query failed: (2002) SQLSTATE[HY000] [2002] No such file or directory

 

[Martin Dias]

check your mysql service it seems down

systemctl status mariadb
tail -n50 /var/log/mysql/error.log