jira mysql 启动 失败_重启机器导致mysql启动失败

一、问题

二、常见解决方案

网上的解决方法大致为 ①空间不足(df -h 查看) ②权限不足(/var/lib文件夹)chown -R mysql:mysql /vdb1/lib/ ③修改my.cnf ,重新配置socket路径 ④使用mysql -h127.0.0.1 -uroot -p连接 ⑤干掉僵尸进程 ps -ef | grep mysql

三、本次解决方案

1、以上方法对于本人当前环境均没有用，使用④方法，报错为

ERROR 2003 (HY000): Can't connect to MySQL server on "host" (111)

2、经大神指导，在mariadb日志(/var/log/mariadb/mariadb.log)中看到 mysqld got signal 6

Version: ‘5.5.64-MariaDB’ socket: ‘/var/lib/mysql/mysql.sock’ port: 3306 MariaDB Server

200617 22:54:24 InnoDB: Assertion failure in thread 140689172858624 in file fut0lst.ic line 83

InnoDB: Failing assertion: addr.page == FIL_NULL || addr.boffset >= FIL_PAGE_DATA

InnoDB: We intentionally generate a memory trap.

InnoDB: Submit a detailed bug report to https://jira.mariadb.org/

InnoDB: If you get repeated assertion failures or crashes, even

Inno