Symptoms
-
When opening Plesk or exporting/importing a database in Plesk, the operation fails with one of the following error messages:
PLESK_INFO: ERROR: PleskExceptionDatabase
DB query failed: SQLSTATE[HY000]: General error: 1021 Disk full (/var/tmp/#sql_3b95_1); waiting for someone to free some space…, <…>
PLESK_INFO: Server Error
500 PleskExceptionDatabase
DB query failed: SQLSTATE[HY000]: General error: 1 Can’t create/write to file ‘/var/tmp/#sql_9d1_0.MAI’ (Errcode: 28), <…>
PLESK_INFO: Server Error
500
Zend_Db_Adapter_Exception
SQLSTATE[HY000][2002] No such file or directory -
Websites with MySQL databases are not accessible with the following error message in a web-browser:
PLESK_INFO: Error establishing a database connection
-
The MySQL service fails to start with the “No space left on device” error in its status:
# systemctl status mariadb.service
…
systemd[1]: Starting MariaDB database server…
systemd[1]: mariadb.service failed to run ‘start-pre’ task: No space left on device
systemd[1]: Failed to start MariaDB database server.
systemd[1]: mariadb.service failed.or with the following error message in
/var/log/mariadb/mariadb.log
:[ERROR] InnoDB: Could not set the file size of './ibtmp1'. Probably out of disk space
Cause
Seems to be often disk space ends because of Plesk backup taking all the space. If you have access please check whenever space ended during backup process. If yes, bug report is required.
-
The MySQL service cannot create temporary files when there is no free disk space limit has been reached on the root partition (or tmp partition if separated):
# df -h /var/lib/mysql /tmp
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 50G 50G 20K 100% / -
There is enough disk space available but there are not enough inodes available:
# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
tmpfs 483902 1 483901 1% /dev/shm
/dev/sda3 3276800 3276800 0 100% /
Resolution
First, to bring services back it is required to free-up some space:
-
Connect to a Plesk server via <a href="https://support.plesk…