Plesk and websites are not accessible: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory

Symptoms

• Plesk is not accessible:

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

• Websites show Plesk default page

• The following errors can be found in /var/log/mariadb/mariadb.log file:

  CONFIG_TEXT: [ERROR] mysqld: Table './phpmonitor/monitor_servers' is marked as crashed and should be repaired
  [Warning] Checking table:  './phpmonitor/monitor_servers'
  [ERROR] mysqld: Table './mgs_motog/wp_options' is marked as crashed and should be repaired
  [Warning] Checking table:  './mgs_motog/wp_options'
  [ERROR] mysqld: Table './wordpress_f9/wp_aiowps_events' is marked as crashed and should be repaired
  [Warning] Checking table:  './wordpress_f9/wp_aiowps_events'
  [ERROR] mysqld: Table './wordpress_f9/wp_options' is marked as crashed and should be repaired

Cause

Corrupted MySQL tables in user databases.

Resolution

If MySQL storage engine supports repair operation, repair the MySQL tables using instructions from this article.

As a paid service, Plesk Professional Services might perform this administrative task.