MariaDB [ERROR] Can’t init tc log
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]  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: 2017-12-12 17:23:24 140696659249408 [ERROR] Can't init tc log Dec 12 17:23:24 example.com mysqld: 2017-12-12 17:23:24 140696659249408 [ERROR] Aborting Dec 12 17:23:27 example.com systemd: mariadb.service: main process exited, code=exited, status=1/FAILURE Dec 12 17:23:27 example.com systemd: Failed to start MariaDB database server.
- Corrupted tc.log file.
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 🙂