How to fix InnoDB corruption cases for the MySQL/MariaDB databases on Plesk for Linux?

Symptoms

• The following error is shown in Plesk:

  ERROR: PleskMainDBException
  MySQL query failed: Incorrect information in file: './psa/misc.frm'

  ---

  ERROR: PleskDBException: Unable to connect to database: mysql_connect(): No such file or directory /var/run/mysqld/mysqld.sock (Error code: 2002). Please check that database server is started and accessible. (Abstract.php:69)

  ---

  ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory

  ---

  ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] Connection refused:
  0: /usr/local/psa/admin/externals/Zend/Db/Adapter/Pdo/Abstract.php:144

• Domain overview page on Domains > example.com is not accessible:

  500 Server Error
  Type SB_Facade_Exception_Generic
  Message
  File generic.php
  Line 33

• Opening WP Toolkit results in the following error:

  Server Error 500 Zend_Db_Adapter_Exception
  Type Zend_Db_Adapter_Exception
  Message SQLSTATE[HY000] [2002]
  No such file or directory
  File Abstract.php Line 144

• Plesk upgrade fails with the following error:

  DATABASE ERROR!!!
  Database psa database found, but version undefined

• A table cannot be properly queried with the SELECT statement:

  select * from db_example.misc;
  ERROR 1033 (HY000): Incorrect information in file: './db_example/misc.frm'

Cause

InnoDB corruption.

Most InnoDB corruptions are hardware-related. Corrupted page writes can be caused by power failures or bad memory. The issue also can be caused by using network-attached storage (NAS) and allocating InnoDB databases on it.