SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine

Refers to:

  • Plesk
  • MT:0db4e797311b7777d96a1f62e3b964cb
  • MG:4b6a0cdec167dfaa64fc3fbe7dc2061e
  • MT:b5df09e9fde5d92e1782b321c6c51024

Created:

2016-11-16 13:10:46 UTC

Modified:

2017-02-20 18:49:49 UTC

3

Was this article helpful?


Have more questions?

Submit a request

SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine

Symptoms

  1. Attempt to log in to Plesk fails with the following error:

    ERROR: Zend_Db_Statement_Exception
    SQLSTATE[HY000]: General error: 1030 Got error 28 from storage engine
  2. Exporting or backing up database fails with the above error in notification area

  3. Windows. Backup restoration fails with the same error

  4. Linux. Restarting the "sw-cp-server" service fails:

    # /etc/init.d/sw-cp-server restart
    Restarting control panels server... stale pidfile. /etc/sw-cp-server/applications.d/plesk.socket.sh: line 76: cannot create temp file for here-document: No space left on device
    /etc/sw-cp-server/applications.d/plesk.socket.sh: line 83: cannot create temp file for here-document: No space left on device
    /etc/sw-cp-server/applications.d/plesk.socket.sh: line 89: cannot create temp file for here-document: No space left on device
  5. Websites are not accessible:

    Error establishing a database connection

  6. MySQL Server cannot start.

Cause

The server lacks disk space. This prevents MySQL from writing to the disk.

Resolution

To resolve the issue, either increase or clear the space on the partition where the Plesk database, temporary backup and backup directories are located.

On Linux, the right partition can be fetched from the Plesk config file:

# cat /etc/psa/psa.conf|grep MYSQL_VAR_D

# cat /etc/psa/psa.conf|grep DUMP

On Windows, the right partition can be fetched from the registry:

  • Run regedit

  • Go to: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\PLESK\PSA Config\Config

    DUMP_D defines the location of Plesk backups

    MYSQL_VAR_D defines the location of MySQL

Have more questions? Submit a request
Please sign in to leave a comment.