Skip to main content

Posts

Showing posts from December, 2020

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

  Symptoms When opening Plesk or exporting/importing a database in Plesk, the operation fails with one of the following error messages: ERROR: Plesk\Exception\Database DB query failed: SQLSTATE[HY000]: General error: 1021  Disk full  (/var/tmp/#sql_3b95_1);  waiting for someone to free some space ..., <...> Server Error 500 Plesk\Exception\Database DB query failed: SQLSTATE[HY000]: General error: 1  Can't create/write to file  '/var/tmp/#sql_9d1_0.MAI' (Errcode: 28), <...> Websites with MySQL databases are not accessible with the following error message in a web-browser: 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.serv