Another reason for Xtrabackup error “log block numbers mismatch”
来源:互联网 发布:制作电子报刊的软件 编辑:程序博客网 时间:2024/05/20 03:48
http://www.chriscalender.com/another-reason-for-xtrabackup-error-log-block-numbers-mismatch/
Another reason for Xtrabackup error “log block numbers mismatch”
I ran into an issue the other day where Xtrabackup was not completing and threw the following error:
xtrabackup: error: log block numbers mismatch:xtrabackup: error: expected log block no. 134860907, but got no. 176803931 from the log file.xtrabackup: Error: xtrabackup_copy_logfile() failed.
When researching this error, I found that this error is generally caused when the following 2 conditions must are met, and this is generally when “xtrabackup cannot catch up with log writing activity on the server, so the log wraps around before xtrabackup can copy records before they are overwritten”:
- The log block numbers must wrap around, which only happens once per 1 GB of log writes.
- The wrap-around point must be between the last checkpoint and the current log tail at the time the backup starts.
Discussed here:
https://bugs.launchpad.net/percona-xtrabackup/+bug/1206309
https://bugs.launchpad.net/percona-xtrabackup/+bug/1050355
When this does occur as a result of the above (and not a bug), then it’s usually an I/O issue, either on the MySQL-side or the disk-side. One you can check with the /dev/null redirect of the actual data (i.e., if it then completes, perhaps you have some IO issue, so investigate that, and/or perform during a period of low-activity).
In this specific case, however, it was a new version of Xtrabackup, low-load, 6G InnoDB log files, …
So what was the problem?
Here the user was trying to use the “xtrabackup” binary to dump a MySQL 5.6 instance. Once switched to “xtrabackup_56” binary, as describedhere, it worked as expected.
Hope this helps.
- Another reason for Xtrabackup error “log block numbers mismatch”
- XtraBackup error:log block numbers mismatch分析处理
- error LNK2038: mismatch detected for '_ITERATOR_DEBUG_LEVEL'
- SVN Error:URL access forbidden for unknown reason
- SVN Error:URL access forbidden for unknown reason
- VS2015 Error LNK2038 mismatch detected for 'RuntimeLibrary'解决
- xtrabackup 恢复出现错误InnoDB: Error: log file ./ib_logfile2 is of different size 0 0 bytes
- libtool version mismatch error
- libtool version mismatch error
- ibtool version mismatch error
- ERROR: module version mismatch
- libtool version mismatch error
- svn: Checksum mismatch for
- svn: Checksum mismatch for
- an error has occurred.See error log for more details
- an error has occurred.See error log for more details
- An error has occurred. See error log for more details.
- An error hasoccurred. See error log for more details.
- SQL Server DBA调优---大数据量查询记录数优化及原理探讨
- android高级控件-Fragment
- 树上的动态规划
- Fragment+viewPager
- js,css加时间戳
- Another reason for Xtrabackup error “log block numbers mismatch”
- linux之nfs的配置和使用
- MonggoDB开关服务的个人小笔记
- 535. Encode and Decode TinyURL
- Qt5 C++源码中使用中文的简单步骤
- Web Service 之 WSDL文件讲解
- 【Linux】shell脚本下的命令代换` `和$() 以及eval
- android应用的签名及混淆
- Oracle Database PSU/CPU