Issue Cant login after VPS crash - SQLSTATE[HY000]: General error: 1030

[Steve Pheriche]

Hi, Our VPS fell victim to a bunch of RAID arrays dying. The supplier restored from disaster backups and I've got most things (such as mail, serving http / ssh / ftp, etc.) working via CLI.

But Plesk login is not functioning.

$ df -h /var/tmp reports seems ok
Filesystem Size Used Avail Use% Mounted on
/dev/vda3 147G 77G 63G 55% /


But on attempting login I see this. Any ideas?

 

[IgorG]

Make sure that mysql service is up and running. Try to start it and check mysql log for error messages.

 

[Steve Pheriche]

MySQL is up and running and serving sites.

the SQL log shows an very large number of entries like this

180131 1:52:37 InnoDB: Error: page 15181 log sequence number 5212736526
InnoDB: is in the future! Current system log sequence number 5212619092.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: MySQL :: MySQL 5.5 Reference Manual :: 14.23.2 Forcing InnoDB Recovery
InnoDB: for more information.

I can see that in my.cnf innodb_force_recovery = 5
which is too harsh, and so I'll attempt that =1 (SRV_FORCE_IGNORE_CORRUPT)

Hopefully SQL actually starts again after attempting that. I think it's in a sickly state.