Symptoms

When MySQL/MariaDB fails to start, the following error is logged to the MySQL/MariaDB error log:

 

[Note] Recovering after a crash using tc.log
[ERROR] Can’t init tc log
[ERROR] Aborting

Description

The error typically indicates the transaction coordinator log is empty, which may be caused by the server not having enough disk space available for writes to complete or MySQL shutting down improperly.

 

Workaround

Rename the /var/lib/mysql/tc.log file or remove the /var/lib/mysql/tc.log by running the following command in SSH or WHM >> Terminal as root:

 

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

Once complete, run the following script to start MySQL/MariaDB:

 

/scripts/restartsrv_mysql

source : https://support.cpanel.net/hc/en-us/articles/1500000853661-MySQL-MariaDB-will-not-start-Can-t-init-tc-log

Posted on: November 30, 2024, by : Julian's | 9 views