InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 640 pages
来源:互联网 发布:云存储的元数据是什么 编辑:程序博客网 时间:2024/05/17 04:36
环境介绍
Centos 6.8数据库:MySQL 5.7.18
异常现象
解决方法
#cd /var/lib/mysql#rm -rf /var/lib/mysql/ib*
主要删除:ibdata1、ib_logfile0、ib_logfile1文件
root cause
之前有安装mysql-server5.1删除文件重构后,异常解决
重启验证
#/etc/init.d/mysqld restart
1 0
- InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 640 pages
- [ERROR] InnoDB: Data file /data/mysql/3310/data/ibdata1 is of a different size 1536 pages
- The innodb_system data file 'ibdata1' must be writable
- Mysql启动中 InnoDB: Error: log file ./ib_logfile0 is of different size 0
- Fixing “InnoDB: Error: log file ./ib_logfile0 is of different size” Error
- InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
- InnoDB: Error: log file /home/mysqldata/ib_logfile0 is of different size
- Mysql启动中 InnoDB: Error: log file ./ib_logfile0 is of different size 0
- InnoDB: Error: log file ./ib_logfile0 is of different size 0 5242880 bytes
- InnoDB: Error: log file ./ib_logfile0 is of different size 50331648 bytes
- xtrabackup 恢复出现错误InnoDB: Error: log file ./ib_logfile2 is of different size 0 0 bytes
- ...find the size of a file?
- mysqld_safe 启动、usr/local/mysql/data/ib_logfile0 is of different size ...的错误
- The database page size of 4096 bytes obtained from ASE is different from the database page size of 2
- How to get the size of a piece of text calculated by different fonts?
- OGG-01705 input trail file './dirdat/fc075295' is greater than the size of the file
- ORA-27046: file size is not a multiple of logical block size
- maximum data file size of Oracle Databa
- Nginx代理功能与负载均衡详解
- Spring第三篇【Core模块之对象依赖】
- JavaScript获取HTML元素
- Python Django进阶教程(三)(模型的高级用法)
- vim保存文件”:wq"与“:x"的区别以及小写":x"与大写“:X”的区别
- InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 640 pages
- android 音视频混合
- Job作业调度(导入文件多条商品,在前台进度条显示)
- Android异步消息处理机制 Looper、Handler、Message
- androidstudio 给代码换皮肤换,怕忘了故记录在此
- L1-017. 到底有多二
- ArcGIS API for Js 之 QueryTask详解
- 1053. Path of Equal Weight (30)
- ScrollView嵌套ViewPager冲突处理