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

Created:

2016-11-16 13:10:46 UTC

Modified:

2017-04-24 13:03:22 UTC

12

Was this article helpful?


Have more questions?

Submit a request

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

Applicable to:

  • Plesk

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 or inodes. 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. Also, make sure that you have enough inodes:

# df -i
Filesystem Inodes IUsed IFree IUse% Mounted on
/dev/ploop16659p1 9977856 618396 9359460 7% /
none 1048576 64 1048512 1% /dev
none 1048576 1 1048575 1% /sys/fs/cgroup
none 1048576 131 1048445 1% /run
none 1048576 85 1048491 1% /run/lock
none 1048576 1 1048575 1% /run/shm
none 1048576 1 1048575 1% /run/user

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.