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

[boosterfan]

Hello guys,

we just did a restart, after that we get error: "DB query failed: SQLSTATE[HY000] [2002] No such file or directory"

We need your help very urgent.

What can we do, we can not restart mariadb? No access to plesk an no access to the websites...

 

[WebHostingAce]

MySQL upgraded recently?

More information required.

Are you using MariaDB or MySQL?

 

[boosterfan]

Hello,

we're using mariadb and didn't make updates that day.

About half an hour later mariadb restartet itself again, do not know why, but now it is working again...

Thanks.

 

[pleskpanel]

What kind of disk space was available at restart?

 

[boosterfan]

It was around 100 gb of free space (ssd).

 

[casperxs]

DB query failed: SQLSTATE[HY000] [2002] No such file or directory , y have the same error , but nothing works for me, my website is working only with the cache, but is a news website ... well you can image the problems.

All this happend after the space on the SSD colapse with a backup, i delete the backup manually and i restart the server, and now is no working the mariadb

HELP PLEASE!!!!

 

[WebHostingAce]

@casperxs

Please post your #journalctl -xe and #systemctl status mysql.service

 

[casperxs]

systemctl status mysql.service

● mariadb.service - MariaDB 10.1.44 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
   Active: failed (Result: exit-code) since Mon 2020-05-11 21:58:40 CDT; 4s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 56615 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=e
xited, status=1/FAILURE)
  Process: 56533 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recove
ry`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCES
S)
  Process: 56527 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/S
UCCESS)
  Process: 56526 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SU
CCESS)
 Main PID: 56615 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"
      CPU: 350ms

May 11 21:58:36 localhost systemd[1]: Starting MariaDB 10.1.44 database server...
May 11 21:58:37 localhost mysqld[56615]: 2020-05-11 21:58:37 140167124168064 [Note] /usr/sbin/mysqld (mysqld 10.1.4
4-MariaDB-0+deb9u1) starting as process 56615 ...
May 11 21:58:40 localhost systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE

May 11 21:58:40 localhost systemd[1]: Failed to start MariaDB 10.1.44 database server.
May 11 21:58:40 localhost systemd[1]: mariadb.service: Unit entered failed state.
May 11 21:58:40 localhost systemd[1]: mariadb.service: Failed with result 'exit-code'.

 

[WebHostingAce]

Please try How to fix InnoDB corruption cases for the MySQL databases on Plesk for Linux?

I. Force InnoDB Recovery

Do it up to step 4. then remove the innodb_force_recovery = 2 and try to restart. If it works, no need to continue the steps.

Are you sure you have enogh disk space? #df -h