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

短命女 2022-01-15 02:23 299阅读 0赞

[2019独角兽企业重金招聘Python工程师标准>>> ][2019_Python_] ![hot3.png][]

● 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

[2019_Python_]: https://my.oschina.net/u/2663968/blog/3061697
[hot3.png]: /images/20220114/bda4a744a0ac462ab183ba62fcfa2831.png