记录一次mysql不能启动的解决方案

2019独角兽企业重金招聘Python工程师标准>>>

● mariadb.service - MariaDB 10.3.14 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; enabled; vendor preset: disabled)
   Active: failed (Result: exit-code) since Wed 2019-05-01 10:43:21 CST; 17s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 961 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 962 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR >
  Process: 970 ExecStart=/usr/bin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
 Main PID: 970 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

5月 01 10:43:19 pengArch mysqld[970]: 2019-05-01 10:43:19 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
5月 01 10:43:19 pengArch mysqld[970]: 2019-05-01 10:43:19 0 [Note] InnoDB: Waiting for purge to start
5月 01 10:43:19 pengArch mysqld[970]: 2019-05-01 10:43:19 0 [Note] InnoDB: 10.3.14 started; log sequence number 3330072; transaction id 1614
5月 01 10:43:19 pengArch mysqld[970]: 2019-05-01 10:43:19 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool
5月 01 10:43:19 pengArch mysqld[970]: 2019-05-01 10:43:19 0 [Note] Recovering after a crash using tc.log
5月 01 10:43:19 pengArch mysqld[970]: 2019-05-01 10:43:19 0 [ERROR] Can't init tc log
5月 01 10:43:19 pengArch mysqld[970]: 2019-05-01 10:43:19 0 [ERROR] Aborting
5月 01 10:43:21 pengArch systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
5月 01 10:43:21 pengArch systemd[1]: mariadb.service: Failed with result 'exit-code'.
5月 01 10:43:21 pengArch systemd[1]: Failed to start MariaDB 10.3.14 database server.

删除/var/lib/mysql/ib_logfile*和/var/lib/mysql/tc.log，重新启动，正常。

转载于:https://my.oschina.net/u/222749/blog/3044667