InnoDB corruption occurs in MariaDB on Plesk server after reboot: Unspecified GSS failure

Dmitry Bystrov

1 year ago

Symptoms

The following errors can be found in /var/log/mariadb/mariadb.log after 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`

MariaDB bug MDEV-18298 or its consequences.

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:

Log in to Plesk server via SSH.
Create Plesk database backup
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.gz

Note: where mysql.daily.dump.0.gz is the most recent daily database dump.
Navigate to the directory /var/lib/psa/dumps/:

# cd /var/lib/psa/dumps/
Restore the psa database 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.shadow mysql -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

Log in to Plesk server via SSH.
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

0 Shares