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

[MartinC]

Hi, I need support to resolve this situation, I can't enter Plesk, I get this 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

I wanted to solve it by starting the mariadb service because repair indicates that it is stopped, but it won't let me and in SSH I got this data

systemctl status mariadb.service
Redirecting to /bin/systemctl restart mariadb.service
Job for mariadb.service failed because a fatal signal was delivered to the control process. See "systemctl status mariadb.service" and "journalctl -xe" for details.
loft8339:~# systemctl status mariadb.service
● mariadb.service - MariaDB 10.2.44 database server
Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
Drop-In: /etc/systemd/system/mariadb.service.d
└─migrated-from-my.cnf-settings.conf
/usr/lib/systemd/system/mariadb.service.d
└─respawn.conf
Active: activating (auto-restart) (Result: signal) since Wed 2022-12-07 03:09:55 CST; 4s ago
Docs: man:mysqld(8)
systemd
Process: 43233 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS --basedir=/usr $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=killed, signal=ABRT)
Process: 43149 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= || VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ] && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
Process: 43121 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Main PID: 43233 (code=killed, signal=ABRT)
CGroup: /system.slice/mariadb.service

Dec 07 03:09:55 loft8339.serverprofi24.com systemd[1]: Failed to start MariaD...
Dec 07 03:09:55 loft8339.serverprofi24.com systemd[1]: Unit mariadb.service e...
Dec 07 03:09:55 loft8339.serverprofi24.com systemd[1]: mariadb.service failed.
Hint: Some lines were ellipsized, use -l to show in full.




journalctl -xe
--
-- The start-up result is done.
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: Dr.Web (R) daemon for
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: Dr.Web (R) daemon
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: Copyright (c) Igor Dan
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: Doctor Web, Moscow, Ru
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: Support service: http:
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: To purchase: http://bu
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: Copyright (c) Igo
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: Doctor Web, Mosco
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: Support service:
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: To purchase: http
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: Key file: /opt/drweb/d
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: Key file: /opt/dr
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: A path to a valid lice
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: A path to a valid
Dec 07 03:11:03 loft8339.serverprofi24.com drwebd[45449]: Plesk authorization fa
Dec 07 03:11:03 loft8339.serverprofi24.com drwebd.real[45449]: Plesk authorizati
Dec 07 03:11:03 loft8339.serverprofi24.com drwebd[45449]: Error: Plesk Software
Dec 07 03:11:03 loft8339.serverprofi24.com drwebd.real[45449]: Error: Plesk Soft
Dec 07 03:11:03 loft8339.serverprofi24.com systemd[1]: drwebd.service: main proc
Dec 07 03:11:03 loft8339.serverprofi24.com systemd[1]: Unit drwebd.service enter
Dec 07 03:11:03 loft8339.serverprofi24.com systemd[1]: drwebd.service failed.
lines 1302-1324/1324 (END)
--
-- The start-up result is done.
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: Dr.Web (R) daemon for Linux/Plesk Editi
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: Dr.Web (R) daemon for Linux/Plesk
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: Copyright (c) Igor Daniloff, 1992-2022
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: Doctor Web, Moscow, Russia
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: Support service: http://support.drweb.c
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: To purchase: Dr.Web — innovative anti-virus technologies. Comprehensive protection from Internet threats.
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: Copyright (c) Igor Daniloff, 1992-
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: Doctor Web, Moscow, Russia
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: Support service: http://support.dr
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: To purchase: Dr.Web — innovative anti-virus technologies. Comprehensive protection from Internet threats.
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: Key file: /opt/drweb/drweb32.key - Key
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: Key file: /opt/drweb/drweb32.key -
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd[45449]: A path to a valid license key file was
Dec 07 03:11:02 loft8339.serverprofi24.com drwebd.real[45449]: A path to a valid license key file
Dec 07 03:11:03 loft8339.serverprofi24.com drwebd[45449]: Plesk authorization failed: malformed r
Dec 07 03:11:03 loft8339.serverprofi24.com drwebd.real[45449]: Plesk authorization failed: malfor
Dec 07 03:11:03 loft8339.serverprofi24.com drwebd[45449]: Error: Plesk Software not running.
Dec 07 03:11:03 loft8339.serverprofi24.com drwebd.real[45449]: Error: Plesk Software not running.
Dec 07 03:11:03 loft8339.serverprofi24.com systemd[1]: drwebd.service: main process exited, code=
Dec 07 03:11:03 loft8339.serverprofi24.com systemd[1]: Unit drwebd.service entered failed state.
Dec 07 03:11:03 loft8339.serverprofi24.com systemd[1]: drwebd.service failed.
lines 1302-1324/1324 (END)

I would greatly appreciate any help to resolve this situation.

 

[IgorG]

First of all make sure that you have enough free disk space with the command

# df -h

If free disk space is ok, check other possible reasons for this issue: https://support.plesk.com/hc/en-us/...2002]+No+such+file+or+directory&commit=Search

 

[MartinC]

First of all make sure that you have enough free disk space with the command

# df -h

If free disk space is ok, check other possible reasons for this issue: https://support.plesk.com/hc/en-us/search?utf8=✓&query=QLSTATE[HY000]+[2002]+No+such+file+or+directory&commit=Search

Hi IgorG
loft8339:~# df -h
Filesystem Size Used Avail Use% Mounted on
devtmpfs 7.8G 0 7.8G 0% /dev
tmpfs 7.8G 0 7.8G 0% /dev/shm
tmpfs 7.8G 191M 7.6G 3% /run
tmpfs 7.8G 0 7.8G 0% /sys/fs/cgroup
/dev/md1 1.9T 70G 1.8T 4% /
/dev/md0 495M 114M 356M 25% /boot
tmpfs 1.6G 0 1.6G 0% /run/user/0

And I checked the solutions that are listed in the link that you indicated but none have worked for me. I still have the same problem of not being able to enter plesk

 

[Peter Debik]

Could you please try to get better details from /var/log/messages? Like pulling all lines that are related to mariadb, e.g.
# grep mariadb /var/log/messages
Normally from the entries there it becomes clear what the cause of startup problems of the database server is.