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

Created:

2016-11-16 12:39:54 UTC

Modified:

2017-08-16 16:02:23 UTC

1

Was this article helpful?


Have more questions?

Anfrage einreichen

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

Applicable to:

  • Plesk 12.0 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 10.4 for Linux/Unix
  • Plesk 11.0 for Windows
  • Plesk 11.5 for Windows
  • Plesk 10.4 for Windows

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 .

Haben Sie Fragen? Anfrage einreichen
Bitte melden Sie sich an, um einen Kommentar zu hinterlassen.