ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 1030 Got error -1 from storage e

[Tessel]

Hello,

After some troubles and using: innodb_force_recovery = 6
All sites are running but only Plesk gives me an error:
ERROR: Zend_Db_Statement_Exception: SQLSTATE[HY000]: General error: 1030 Got error -1 from storage engine (Pdo.php:234)
Looking thrue the knowlagebase is gives me no direct solution.

Any idea that is wrong here?

Kind regards,
Nico

 

[IgorG]

Looks like the MySQL database of Plesk is broken. You can check errors in mysql log file. Only restoring database from dump can help:

https://kb.odin.com/en/116591
https://kb.odin.com/en/120684

 

[MMagnani]

Hello!

Exactly the same issue here, but when I run correction from https://kb.plesk.com/en/116591 (which possibly does not apply to my Plesk 12.5.30 in Debian 7)

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

where "/PATH/TO/VALID/PSA.dump.sql" is "/var/lib/psa/dumps/mysql.daily.dump.0"
returns

ERROR 2013 (HY000) at line 30: Lost connection to MySQL server during query

and then mysql service stops. It can only be restarted if "innodb_force_recovery = 6" in my.cnf

Any suggestions?