Plesk is not available: Got error -1 from storage engine

Refers to:

  • Plesk 10.4 for Windows
  • Plesk 10.4 for Linux
  • Plesk 11.0 for Windows
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux
  • Plesk 9.x and below for Linux
  • MT:0db4e797311b7777d96a1f62e3b964cb
  • MG:4b6a0cdec167dfaa64fc3fbe7dc2061e
  • MT:35f406588bee8149d1cfb67d5af98f52
  • MG:a4a269d964ef8ed01cbfcd40717fa06c

Created:

2016-11-16 12:39:54 UTC

Modified:

2017-02-13 06:12:03 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk is not available: Got error -1 from storage engine

Symptoms

Plesk for Windows

A blank page is shown on the Plesk login page. The following message occurs in the log file:

%plesk_dir%\\admin\\logs\\php_error.log
--->8---
PHP Fatal error: Call to a member function getContext() on a non-object in C:\\Program Files (x86)\\Parallels\\Plesk\\admin\\plib\\Navigation.php on line 59
---8<---

Check the Plesk database for broken tables with a command like the one below, where "PASSWORD" is the Plesk admin password:

%plesk_dir%\\MySQL\\bin>mysqlcheck -uadmin  -p<PASSWORD> -P8306 psa
ERROR 1030 (HY000): Got error 1 from storage engine

Plesk for Linux

https://123.123.123.123:8443/
--->8---
ERROR: Zend_Db_Statement_Exception
SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine
---8<---

Also, the password of the admin user cannot be retrieved:

~# /usr/local/psa/bin/admin --show-password
SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine
~#

Cause

The MySQL database of Plesk is broken.

Resolution

Find a valid dump of the Plesk database and restore it:

Plesk for Windows

%plesk_dir%\\MySQL\\bin>mysql.exe -uadmin -P8306 -p<PASSWORD> psa < /PATH/TO/VALID/PSA.dump.sql

Plesk for Linux

~# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa < /PATH/TO/VALID/PSA.dump.sql

Daily database dumps location can be found:

Linux:

# grep dump /etc/psa/psa.conf
DUMP_D /var/lib/psa/dumps

Windows:

By default, daily database dumps are located in

%plesk_dir%"\\Mysql\\Backup

If the steps above did not help, refer to the KB article How to fix InnoDB corruption cases for the MySQL database .

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