首页 > 数据库 >mysql5.7 报错:[ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpo

mysql5.7 报错:[ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpo

时间:2024-05-19 10:30:21浏览次数:23  
标签:02 Note end 05 checkpoint 报错 ERROR InnoDB 19T02

mysql 5.7启动报错:

2024-05-19T02:02:14.453082Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2024-05-19T02:02:14.453139Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2024-05-19T02:02:14.453543Z 0 [Note] D:\...\mysql-5.7.33-winx64\bin\mysqld (mysqld 5.7.33-log) starting as process 5544 ...
2024-05-19T02:02:14.498135Z 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2024-05-19T02:02:14.498510Z 0 [Note] InnoDB: Uses event mutexes
2024-05-19T02:02:14.498725Z 0 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
2024-05-19T02:02:14.499030Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2024-05-19T02:02:14.499501Z 0 [Note] InnoDB: Number of pools: 1
2024-05-19T02:02:14.499804Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2024-05-19T02:02:14.502418Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2024-05-19T02:02:14.507594Z 0 [Note] InnoDB: Completed initialization of buffer pool
2024-05-19T02:02:14.534570Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2024-05-19T02:02:14.537235Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2500634944
2024-05-19T02:02:14.537573Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2500635022
2024-05-19T02:02:14.537901Z 0 [ERROR] InnoDB: Ignoring the redo log due to missing MLOG_CHECKPOINT between the checkpoint 2500634944 and the end 2500635022.
2024-05-19T02:02:14.538335Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2024-05-19T02:02:14.756294Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2024-05-19T02:02:14.756730Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2024-05-19T02:02:14.757020Z 0 [ERROR] Failed to initialize builtin plugins.
2024-05-19T02:02:14.757395Z 0 [ERROR] Aborting

2024-05-19T02:02:14.757585Z 0 [Note] Binlog end
2024-05-19T02:02:14.757837Z 0 [Note] Shutting down plugin 'CSV'
2024-05-19T02:02:14.758262Z 0 [Note] D:\...\mysql-5.7.33-winx64\bin\mysqld: Shutdown complete

解决:

mysql-5.7.33-winx64\Data 下的 ib_logfile0、ib_logfile1 重命名ib_logfile0.bak、ib_logfile1.bak  然后启动就对了

 

网上说原因是:

1、突然断电关机或者不正常关机之后,DataEase 服务中的 MySQL 容器无法启动

 

标签:02,Note,end,05,checkpoint,报错,ERROR,InnoDB,19T02
From: https://www.cnblogs.com/xiaoruilin/p/18200098

相关文章

  • ray tracing in one weekend - 5
    dielectric水、玻璃、钻石等透明材料都是电介质。当光线照射到它们身上时,它会分裂成反射光线和折射(透射)光线。我们将通过在反射和折射之间随机选择来处理这个问题,每次相互作用只产生一个散射射线。折射程度:是根据两个介质折射率的差值决定的。RefractionSnell'sLaw$$\e......
  • from tensorflow.examples.tutorials.mnist import input_data时input_data报错
    参考链接——https://blog.csdn.net/weixin_42390287/article/details/115635732 报错 ——解决方法去https://github.com/tensorflow/tensorflow下载压缩包 解压,找到input_data.py后复制到一个新建的空文件夹里将这个文件夹放到python项目中,代码中对input_......
  • Vue3报错:已声明“upperName”,但从未读取其值。ts-plugin(6133)
    Vue3报错:已声明“upperName”,但从未读取其值。ts-plugin(6133)报错显示:类型“StoreToRefs<Store<"count",{sum:number;name:string;address:string;},{},{increment(value:number):void;}>>”上不存在属性“upperName”。ts-plugin(2339)相关代码:vue文件:con......
  • LeetCode 1353. Maximum Number of Events That Can Be Attended
    原题链接在这里:https://leetcode.com/problems/maximum-number-of-events-that-can-be-attended/description/题目:Youaregivenanarrayof events where events[i]=[startDayi,endDayi].Everyevent i startsat startDayi andendsat endDayi.Youcanattend......
  • restcontroller中使用delete请求发送带参路径报错
    报错内容:Resolved[org.springframework.web.HttpRequestMethodNotSupportedException:Requestmethod'DELETE'notsupported]具体情景:postman中发送的路径: 每次用这个路径发送delete请求都报错,但是用这个路径发送get请求做查询却没问题,真的让我苦恼好久 解决:因为HttpC......
  • 安装vue/cli报错问题解决
    在管理员终端中输入命令:npmi-g@vue/cli错误原因证书已过期,需要安装淘宝镜像npmconfigsetregistryhttps://registry.npmmirror.com使用cnpm安装脚手架报错cnpmi-g@vue/cli 这个错误表明你尝试执行的 cnpm 命令无法加载,因为PowerShell策略不允许执......
  • (报错)ROS2:WARNING:colcon.colcon_core.package_selection:ignoring unknown package
    在使用colcon编译时,如果直接对所有包编译colconbuild则不会有问题,但是针对单独某个包编译colconbuild--packages-select<pkg>则报错WARNING:colcon.colcon_core.package_selection:ignoringunknownpackagegg了一下找到了问题参考:https://unix.stackexchange.co......
  • 将图片上传到七牛云会报错error=incorrect region, please use up-z2.qiniu.com
    报错代码:{ResponseInfo:com.qiniu.http.Response@377fbcac,status:400,reqId:e6sAAAAKAlyhUDwW,xlog:X-Log,xvia:,adress:up.qiniu.com/115.238.101.32:80,duration:0.000000s,error:incorrectregion,pleaseuseup-z2.qiniup.com}{"error":"incorrect......
  • Games101-9 advanced rendering
    PhysicallyBasedRendering:FromTheorytoImplementation(pbr-book.org)advancedlighttransport有/无偏的光线传播方法双向路径追踪这里主要的光照为间接光---不是直接光源---实现比较困难。使用马尔科夫链进行推测。优势:对于光线复杂的情况来水,比较好......
  • ray tracing in one weekend - 1
    thebasic#include<iostream>intmain(){//Imageintimage_width=256;intimage_height=256;//Renderstd::cout<<"P3\n"<<image_width<<''<<image_height<<"\n255......