MariaDB [ERROR] Can’t init tc log

Issues :-

When performed an upgrade, rebooted and MySQL isn’t starting.  The key error seems to be “[ERROR] Can’t init tc log”

• Plesk is inaccessible with the following error:

ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory 
Additionally, an exception has occurred while trying to report this error: Zend_Exception 
No entry is registered for key & #039 ;translate& #039 ; (Abstract.php:144)

• mariadb service is not starting:

# 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]

• journalctl -xe shows the following:

Dec 12 17:23:24 example.com mysqld[7512]: 2017-12-12 17:23:24 140696659249408 [ERROR] Can't init tc log 
Dec 12 17:23:24 example.com mysqld[7512]: 2017-12-12 17:23:24 140696659249408 [ERROR] Aborting 
Dec 12 17:23:27 example.com systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE 
Dec 12 17:23:27 example.com systemd[1]: Failed to start MariaDB database server.

Cause :- 

• Corrupted tc.log file.

Resolution :-  

Just to go ahead and move the tc.log file under the  /var/lib/mysql to another path For eg. /root

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

Then start mariadb service

service mariadb start

This will resolve the issue 🙂