Symptoms
-
The following errors can be found in
/var/log/mariadb/mariadb.logafter the server reboot:[Warning] mysqld: GSSAPI plugin : default principal 'mariadb/plesk.example.com@' not found in keytab
[ERROR] mysqld: Server GSSAPI error (major 851968, minor 2529639093) : gss_acquire_cred failed -Unspecified GSS failure. Minor code may provide more information. Keytab FILE:/etc/krb5.keytab is nonexistent or empty.
[ERROR] Plugin 'gssapi' init function returned error. -
Unable to view database tables content via phpMyAdmin:
table does not exist in engine
-
Unable to generate Plesk login link:
DB query failed: SQLSTATE[42S02]: Base table or view not found: 1932 Table 'psa.sessions' doesn't exist in engine, query was: DESCRIBE `sessions`
Cause
MariaDB bug MDEV-18298 or its consequences.
Resolution
Check if the InnoDB engine has already been corrupted using the symptoms from the article How to fix InnoDB corruption cases for the MySQL/MariaDB databases on Plesk for Linux? and apply one of the following solutions:
If InnoDB is corrupted
-
Log in to Plesk server via SSH.
-
List all available Plesk daily database dumps sorted by the date:
# ls -lt /var/lib/psa/dumps/mysql.daily.*
-rw------- 1 root root 236253 Feb 3 01:51 mysql.daily.dump.0.gz
-rw------- 1 root root 229653 Feb 2 01:48 mysql.daily.dump.1.gz
-rw------- 1 root root 222485 Feb 1 01:56 mysql.daily.dump.2.gzNote: where
mysql.daily.dump.0.gzis the most recent daily database dump. -
Navigate to the directory
/var/lib/psa/dumps/:# cd /var/lib/psa/dumps/
-
Restore the
psadatabase from the most recent daily dump:# zcat mysql.daily.dump.0.gz | sed -n '/-- Current Database:
psa/,/-- Current Database:*/p' | MYSQL_PWD=cat /etc/psa/.psa.shadowmysql -uadmin -
Disable GSSAPI plugin by commenting it out in
/etc/my.cnf.d/auth_gssapi.cnf. Use any comfortable text editor, e.g. Vi:#plugin-load-add=auth_gssapi.so
-
Restart MariaDB:
# service mariadb restart
with