xtrabackup 恢复出现错误InnoDB: Error: log file ./ib_logfile2 is of different size 0 0 bytes
来源:互联网 发布:java浅蓝色代码 编辑:程序博客网 时间:2024/06/05 04:32
161104 10:11:54 InnoDB: Initializing buffer pool, size = 22.0G
161104 10:11:55 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile2 is of different size 0 0 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
161104 10:11:55 [ERROR] Plugin 'InnoDB' init function returned error.
161104 10:11:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
161104 10:11:55 [ERROR] Unknown/unsupported storage engine: InnoDB
161104 10:11:55 [ERROR] Aborting
161104 10:11:55 InnoDB: Completed initialization of buffer pool
InnoDB: Error: log file ./ib_logfile2 is of different size 0 0 bytes
InnoDB: than specified in the .cnf file 0 268435456 bytes!
161104 10:11:55 [ERROR] Plugin 'InnoDB' init function returned error.
161104 10:11:55 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
161104 10:11:55 [ERROR] Unknown/unsupported storage engine: InnoDB
161104 10:11:55 [ERROR] Aborting
161104 10:11:55 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete
解决方式基本方式是不同配置启动导致。在使用xtrabacku 恢复应用日志过程中没有指定使用规范的配置文件。
把ib_logfile文件移动到另外目录备份,重新启动mysql即可
0 0
- xtrabackup 恢复出现错误InnoDB: Error: log file ./ib_logfile2 is of different size 0 0 bytes
- InnoDB: Error: log file .\ib_logfile0 is of different size 0 10485760 bytes
- 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
- Mysql启动中 InnoDB: Error: log file ./ib_logfile0 is of different size 0
- 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 /home/mysqldata/ib_logfile0 is of different size
- [ERROR] InnoDB: Data file /data/mysql/3310/data/ibdata1 is of a different size 1536 pages
- InnoDB: The Auto-extending innodb_system data file './ibdata1' is of a different size 640 pages
- magento -- 出现Fatal error: Allowed memory size of 33554432 bytes exhausted错误的处理
- The database page size of 4096 bytes obtained from ASE is different from the database page size of 2
- Fatal error: Allowed php错误提示memory size of 8388608 bytes exhausted (tried to allocate 58368 bytes) i
- php内存溢出,出现Allowed memory size of 8388608 bytes exhausted错误的解决办法
- mysqld_safe 启动、usr/local/mysql/data/ib_logfile0 is of different size ...的错误
- The count of VLFs for different size of transaction log
- 备忘:编译Apache的configure: error: Size of "void *" is less than size of "long"错误
- Fatal error: Allowed memory size of 8388608 bytes exhausted
- JavaScript进阶学习——事件响应
- Qt使用post上传压缩文件
- Android 自定义键盘中禁用点击预览弹窗
- HttpClient 模拟登陆百度 2015.10.21 JAVA
- 51nod-【1067 Bash游戏 V2】
- xtrabackup 恢复出现错误InnoDB: Error: log file ./ib_logfile2 is of different size 0 0 bytes
- 自定义listView下拉刷新
- recover database 的几种不同方式区别
- Distributed TensorFlow,分布式Tensorflow官方文档
- 时刻检测服务是否正常--心跳检测服务器是否正常的开源项目
- 二分图最大匹配
- eclipse中定义注释模板
- [kuangbin带你飞]专题十六 KMP & 扩展KMP & Manacher K HDU 3336
- 前端跨域整理