mysql数据库无故停止

小糊涂仙

大家碰到过没,我以前安装的是phpstudy2018版,没出过问题,最近换为最新版,但mysql运行一段时间后自动停止了,再点击启动又可继续启动,由于系统服务中也没有相关服务,所以不知道怎么处理。

问题比较着急?请联系QQ:760483
  • 尘の风
  • 尘の风    2019-08-01 21:19:261楼

    查下错误日志,看下日志里记录的错误信息,发出来我们参考下

    +添加回复

  • 回复

    错误信息如下,无限重启 2020-10-06T06:15:48.837357Z 0 [ERROR] [FATAL] InnoDB: Table flags are 0 in the data dictionary but the flags in file .\ibdata1 are 0x4800! 2020-10-06 14:15:48 0x49e4 InnoDB: Assertion failure in thread 18916 in file ut0ut.cc line 942 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 06:15:48 UTC - mysqld got exception 0x80000003 ; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. Attempting to collect some information that could help diagnose the problem. As this is a crash and something is definitely wrong, the information collection process might fail.

    thefun · 2020-10-06 14:23:03
    回复