Resolved 500 Plesk\Exception\Database

[StefanoSudati]

Hi All
Big problem

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	64

SSH

# plesk db

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
exit status 1

# service mariadb status -l

● mariadb.service - MariaDB 10.3.27 database server
Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
Active: deactivating (final-sigterm) (Result: exit-code)
Docs: man:mysqld(8)
systemd
Process: 3522 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
Process: 3523 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
Process: 3525 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, s
Process: 3587 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
Main PID: 3587 (code=exited, status=1/FAILURE)
Status: "MariaDB server is down"
Tasks: 3 (limit: 1144)
Memory: 76.0M
CGroup: /system.slice/mariadb.service
└─777 /usr/sbin/mysqld

Jan 15 13:21:38 cloud.xxx.com systemd[1]: Starting MariaDB 10.3.27 database server...
Jan 15 13:21:38 cloud.xxx.com systemd[1]: mariadb.service: Found left-over process 777 (mysqld) in control group while starting unit. Ignoring.
Jan 15 13:21:38 cloud.xxx.com systemd[1]: This usually indicates unclean termination of a previous run, or service implementation deficiencies.
Jan 15 13:21:38 cloud.xxx.com mysqld[3587]: 2021-01-15 13:21:38 0 [Note] /usr/sbin/mysqld (mysqld 10.3.27-MariaDB-0+deb10u1) starting as process 3587 ...
Jan 15 13:21:38 cloud.xxx.com mysqld[3587]: 2021-01-15 13:21:38 0 [Warning] Could not increase number of max_open_files to more than 16384 (request: 32183)
Jan 15 13:22:15 cloud.xxx.com systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Jan 15 13:37:15 cloud.xxx.com systemd[1]: mariadb.service: State 'stop-sigterm' timed out. Skipping SIGKILL.


What can i do?

 

[StefanoSudati]

SOLVEDDDDD!!!!

MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\Exception\Database

Applicable to: Plesk for Linux Symptoms When opening Plesk or exporting/importing a database in Plesk, the operation fails with one of the following error messages: PLESK_INFO: ERROR: Plesk\Ex...

support.plesk.com

Thank you!

 

[fotis]

I am sorry to bother u but I have a problem with plesk and I cannot have access to server. I would appreciate your help if u can help me.
The problem discribed here :
MySQL fails to start when a Plesk server lacks disk space: SQLSTATE[HY000] No space left on device 500 Plesk\Exception\Database
But I dont know what to do to fix it.

 

[weltonw]

You're out of disk space. expand your drive, or delete some files.