记录一次数据库无法启动解决方案

最新推荐文章于 2024-05-15 22:52:13 发布

weixin_45250597

最新推荐文章于 2024-05-15 22:52:13 发布

阅读量684

点赞数 1

文章标签：数据库

本文链接：https://blog.csdn.net/weixin_45250597/article/details/126235244

版权

[root@zabbix log]# systemctl status mariadb
● mariadb.service - MariaDB 10.4.25 database server
   Loaded: loaded (/usr/lib/systemd/system/mariadb.service; disabled; vendor preset: disabled)
  Drop-In: /etc/systemd/system/mariadb.service.d
           └─migrated-from-my.cnf-settings.conf
   Active: failed (Result: exit-code) since 一 2022-08-08 20:01:37 CST; 4min 22s ago
     Docs: man:mysqld(8)
           https://mariadb.com/kb/en/library/systemd/
  Process: 2986 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS $_WSREP_NEW_CLUSTER $_WSREP_START_POSITION (code=exited, status=1/FAILURE)
  Process: 2960 ExecStartPre=/bin/sh -c [ ! -e /usr/bin/galera_recovery ] && VAR= ||   VAR=`cd /usr/bin/..; /usr/bin/galera_recovery`; [ $? -eq 0 ]   && systemctl set-environment _WSREP_START_POSITION=$VAR || exit 1 (code=exited, status=0/SUCCESS)
  Process: 2957 ExecStartPre=/bin/sh -c systemctl unset-environment _WSREP_START_POSITION (code=exited, status=0/SUCCESS)
 Main PID: 2986 (code=exited, status=1/FAILURE)
   Status: "MariaDB server is down"

8月 08 20:01:37 zabbix mysqld[2986]: 2022-08-08 20:01:37 0 [Note] InnoDB: Starting shutdown...
8月 08 20:01:37 zabbix mysqld[2986]: 2022-08-08 20:01:37 0 [ERROR] Plugin 'InnoDB' init function re...ror.
8月 08 20:01:37 zabbix mysqld[2986]: 2022-08-08 20:01:37 0 [ERROR] Plugin 'InnoDB' registration as ...led.
8月 08 20:01:37 zabbix mysqld[2986]: 2022-08-08 20:01:37 0 [Note] Plugin 'FEEDBACK' is disabled.
8月 08 20:01:37 zabbix mysqld[2986]: 2022-08-08 20:01:37 0 [ERROR] Unknown/unsupported storage engi...noDB
8月 08 20:01:37 zabbix mysqld[2986]: 2022-08-08 20:01:37 0 [ERROR] Aborting
8月 08 20:01:37 zabbix systemd[1]: mariadb.service: main process exited, code=exited, status=1/FAILURE
8月 08 20:01:37 zabbix systemd[1]: Failed to start MariaDB 10.4.25 database server.
8月 08 20:01:37 zabbix systemd[1]: Unit mariadb.service entered failed state.
8月 08 20:01:37 zabbix systemd[1]: mariadb.service failed.

删除/var/lib/mysql/ib_logfile*和/var/lib/mysql/tc.log,重新启动，数据库正常运行