Plesk for Linux interface is inaccessible: Can’t init tc log

Symptoms

• On a Plesk for Linux server, the Plesk interface is inaccessible or Plesk Installer fails to start:

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

• MariaDB/MySQL fails to start:

  # service mariadb start
  Starting mariadb (via systemctl): Job for mariadb.service failed because the control process exited with error code. See "systemctl status mariadb.service" and "journalctl -xe" for details.
  [FAILED]

• Cannot access MySQL server via command line:

  # mysql
  Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2 "No such file or directory").

• The following error is found in the output of the command journalctl -xe or in the MariaDB/MySQL log file:

  [ERROR] Can't init tc log

Cause

Corrupted log file tc.log in the MariaDB/MySQL data directory.

Resolution

Note: This article is intended for use by server administrators. In case there is no administrative access to the Plesk interface or administrative SSH access to the server, please contact the server administrator or server provider.

1. Connect to the server using SSH.

2. Move the file tc.log:

   # mv /var/lib/mysql/tc.log /root/

3. Start MariaDB/MySQL service:

   # service mariadb start

   OR

   # service mysql start