• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

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

M

MartinC

New Pleskian
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 said:
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
Click to expand...
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
 
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.
 
You must log in or register to reply here.

Similar threads

S
Resolved Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
10
Views
358
Shasam
S
E
Resolved DB query failed: SQLSTATE[HY000] [2002] No such file or directory mariadb cant start
Replies
1
Views
621
emreboy
E
B
  • Locked
Issue Server Error 500 Plesk\Exception\Database
Replies
1
Views
780
Peter Debik
P
F
Question Mariadb down after update Plesk /var 100% full
Replies
8
Views
318
flieg4bei
F
S
Resolved Server Error500 Plesk\Exception\DatabaseDB query failed: SQLSTATE[HY000] [2002] No such file or directory
Replies
3
Views
2K
signguy007
S
Back
Top