Fedora 27 / 28上start MariaDb / MySQL的问题

Question

我正在尝试在fedora 28上安装mysql/mariadb，但是安装后它还没有启动服务器。

当我输入systemctl start时，mariadb.service收到了以下消息：

mariadb.service的作业失败，因为控制进程存在错误代码。有关详细信息，请参阅"systemctl status mariadb.service“和"journalctl -xe”。

分析日记见以下错误信息：

*2018-09-03  8:01:20 0 [Note] Recovering after a crash using tc.log
set 03 08:01:20 localhost.localdomain 
mysqld[4944]: 2018-09-03  8:01:20 0 [ERROR] Recovery failed! You must enable all engines that were enabled at t>
set 03 08:01:20 localhost.localdomain 
mysqld[4944]: 2018-09-03  8:01:20 0 [ERROR] Crash recovery failed. Either correct the problem (if it's, for exa>
set 03 08:01:20 localhost.localdomain 
mysqld[4944]: 2018-09-03  8:01:20 0 [ERROR] Can't init tc log
set 03 08:01:20 localhost.localdomain 
mysqld[4944]: 2018-09-03  8:01:20 0 [ERROR] Aborting*

有人能用灯来解决这个黑暗的问题吗？

Answer 1

它可能是零字节出现在tc.log上。删除或重新启动进程应该有效。

sudo mv /var/lib/mysql/tc.log /var/lib/mysql/tc.log.bak
systemctl restart mariadb.service

参考文献：

1. https://fransdejonge.com/2018/02/mariadb-fix-cant-init-tc-log-error/
2. https://bbs.archlinux.org/viewtopic.php?id=206379