前往小程序,Get更优阅读体验!
立即前往
首页
学习
活动
专区
工具
TVP
发布
社区首页 >专栏 >【mysql错误】全量+增量数据校验后数据库启动报错

【mysql错误】全量+增量数据校验后数据库启动报错

作者头像
用户5522200
发布2019-06-02 15:08:49
1.5K0
发布2019-06-02 15:08:49
举报
文章被收录于专栏:lindalinda

场景:

全量+增量数据校验后,数据库启动日志报如下错误: (此时MySQL可以启动成功,也存在mysql进程,进入mysql查询数据可查到。重启的时候错误日志中还是会报同样的错误)

代码语言:javascript
复制
170802 21:29:31 mysqld_safe Starting mysqld daemon with databases from /data/mariadb
2017-08-02 21:29:31 139871796967424 [Note] /usr/mariadb/bin/mysqld (mysqld 10.1.24-MariaDB) starting as process 147923 ...
2017-08-02 21:29:31 139871796967424 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2017-08-02 21:29:31 139871796967424 [Note] InnoDB: The InnoDB memory heap is disabled
2017-08-02 21:29:31 139871796967424 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-08-02 21:29:31 139871796967424 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2017-08-02 21:29:31 139871796967424 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-08-02 21:29:31 139871796967424 [Note] InnoDB: Using Linux native AIO
2017-08-02 21:29:31 139871796967424 [Note] InnoDB: Using SSE crc32 instructions
2017-08-02 21:29:31 139871796967424 [Note] InnoDB: Initializing buffer pool, size = 40.0G
2017-08-02 21:29:32 139871796967424 [Note] InnoDB: Completed initialization of buffer pool
2017-08-02 21:29:32 139871796967424 [Note] InnoDB: Highest supported file format is Barracuda.
2017-08-02 21:29:32 139871796967424 [Warning] InnoDB: The log sequence number in the ibdata files is higher than the log sequence number in the ib_logfiles! Are you sure
 you are using the right ib_logfiles to start up the database. Log sequence number in the ib_logfiles is 1086530931761, logsequence numbers stamped to ibdata file header
s are between 1087224890870 and 1087224890870.
2017-08-02 21:29:32 139871796967424 [Note] InnoDB: The log sequence numbers 1087224890870 and 1087224890870 in ibdata files do not match the log sequence number 10865309
31761 in the ib_logfiles!
2017-08-02 21:29:32 139871796967424 [Note] InnoDB: Restoring possible half-written data pages from the doublewrite buffer...
2017-08-02 21:29:32 7f3670c5b800 InnoDB: Error: page 2 log sequence number 1087224745356
InnoDB: is in the future! Current system log sequence number 1086530931761.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2017-08-02 21:29:32 7f3670c5b800 InnoDB: Error: page 4 log sequence number 1087224626082
InnoDB: is in the future! Current system log sequence number 1086530931761.
InnoDB: Your database may be corrupt or you may have copied the InnoDB
InnoDB: tablespace but not the InnoDB log files. See
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: for more information.
2017-08-02 21:29:32 139871796967424 [Note] Server socket created on IP: '0.0.0.0'.
2017-08-02 21:29:32 139871796967424 [Note] /usr/mariadb/bin/mysqld: ready for connections.
Version: '10.1.24-MariaDB'  socket: '/tmp/mysql.sock'  port: 3306  MariaDB Server

原因:

本文参与 腾讯云自媒体分享计划,分享自作者个人站点/博客。
如有侵权请联系 cloudcommunity@tencent.com 删除

本文分享自 作者个人站点/博客 前往查看

如有侵权,请联系 cloudcommunity@tencent.com 删除。

本文参与 腾讯云自媒体分享计划  ,欢迎热爱写作的你一起参与!

评论
登录后参与评论
0 条评论
热度
最新
推荐阅读
目录
  • 场景:
  • 原因:
相关产品与服务
云数据库 SQL Server
腾讯云数据库 SQL Server (TencentDB for SQL Server)是业界最常用的商用数据库之一,对基于 Windows 架构的应用程序具有完美的支持。TencentDB for SQL Server 拥有微软正版授权,可持续为用户提供最新的功能,避免未授权使用软件的风险。具有即开即用、稳定可靠、安全运行、弹性扩缩等特点。
领券
问题归档专栏文章快讯文章归档关键词归档开发者手册归档开发者手册 Section 归档