MariaDB10.3.17 mysql启动报错解决办法 [ERROR] Unknown/unsupported storage engine: InnoDB

我的mariadb版本是10.6.1。mariadb运行了一段事件后服务退出了，手动在windows服务里启动服务发现启动不了，再到windows事件日志中的应用程序日志查看，发现好多mariadb的错误，错误跟下面描述的基本一样，因此按照下面方法删除掉几个日志文件后，再在服务里重启mariadb服务，发现可以启动了。

转自：https://blog.csdn.net/cocos2dGirl/article/details/103163432

 

版本：mariadb.service - MariaDB 10.3.17 database server

启动不成功具体报错：

root@instance-tbbjrcnc:~# service mysql status
● mariadb.service - MariaDB 10.3.17 database server
   Loaded: loaded (/lib/systemd/system/mariadb.service; enabled; vendor preset: enabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since Wed 2019-11-20 14:49:58 CST; 3min 49s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 18795 ExecStartPost=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 18793 ExecStartPost=/etc/mysql/debian-start (code=exited, status=0/SUCCESS)
  Process: 10690 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 10679 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`/usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exi
  Process: 10675 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
  Process: 10673 ExecStartPre=/usr/bin/install -m 755 -o mysql -g root -d /var/run/mysqld (code=exited, status=0/SUCCESS)
 Main PID: 10690 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"
      CPU: 143ms
 
Nov 20 14:49:58 instance-tbbjrcnc mysqld[10690]: 2019-11-20 14:49:58 0 [ERROR] Plugin 'InnoDB' init function returned error.
Nov 20 14:49:58 instance-tbbjrcnc mysqld[10690]: 2019-11-20 14:49:58 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
Nov 20 14:49:58 instance-tbbjrcnc mysqld[10690]: 2019-11-20 14:49:58 0 [Note] Plugin 'FEEDBACK' is disabled.
Nov 20 14:49:58 instance-tbbjrcnc mysqld[10690]: 2019-11-20 14:49:58 0 [ERROR] Could not open mysql.plugin table. Some plugins may be not loaded
Nov 20 14:49:58 instance-tbbjrcnc mysqld[10690]: 2019-11-20 14:49:58 0 [ERROR] Unknown/unsupported storage engine: InnoDB
Nov 20 14:49:58 instance-tbbjrcnc mysqld[10690]: 2019-11-20 14:49:58 0 [ERROR] Aborting
Nov 20 14:49:58 instance-tbbjrcnc systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Nov 20 14:49:58 instance-tbbjrcnc systemd[1]: Failed to start MariaDB 10.3.17 database server.
Nov 20 14:49:58 instance-tbbjrcnc systemd[1]: mariadb.service: Unit entered failed state.
Nov 20 14:49:58 instance-tbbjrcnc systemd[1]: mariadb.service: Failed with result 'exit-code'.
查看报错详命令:  journalctl -xe

报错如下：

Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] /usr/sbin/mysqld (mysqld 10.3.18-MariaDB-0+deb10u1) starting as process 12598 ...
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: Using Linux native AIO
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: Uses event mutexes
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: Number of pools: 1
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: Using SSE2 crc32 instructions
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: Completed initialization of buffer pool
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: Creating shared tablespace for temporary tables
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: Waiting for purge to start
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] InnoDB: 10.3.18 started; log sequence number 1603968; transaction id 9
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] Plugin 'FEEDBACK' is disabled.
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [Note] Recovering after a crash using tc.log
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [ERROR] Bad magic header in tc log
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [ERROR] Crash recovery failed. Either correct the problem (if it's, for example, out of memory error) and restart, or delete tc log and sta
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [ERROR] Can't init tc log
Nov 20 15:00:11 instance-tbbjrcnc mysqld[12598]: 2019-11-20 15:00:11 0 [ERROR] Aborting
Nov 20 15:00:13 instance-tbbjrcnc systemd[1]: mariadb.service: Main process exited, code=exited, status=1/FAILURE
Nov 20 15:00:13 instance-tbbjrcnc systemd[1]: Failed to start MariaDB 10.3.18 database server.
解决方案：

找到tc.log删掉，重启数据库就好了（tc.log和ib_logfile0在同一个文件夹下），我的在/var/lib/mysql目录下

具体操作如下：

root@instance-tbbjrcnc:/# find ./ -name "ib_logfile0"
./var/lib/mysql/ib_logfile0
root@instance-tbbjrcnc:/# cd ./var/lib/mysql/
root@instance-tbbjrcnc:/var/lib/mysql# rm -rf tc.log
root@instance-tbbjrcnc:/var/lib/mysql# service mysql start
重启OK啦！

要是还是重启不了的话，那就把这个目录下的：

rm -rf aria_log*

rm -rf ib_logfile*

rm -rf ibdata1 

这几个文件都删除，就可以启动啦~