MySQL xtrabackup备份失败记录
InnoDB: Last flushed lsn: 340748764928 load_index lsn 340748904772# 一个DDL操作已经执行（未记录redo日志）。影响到的行可能未落地，PXB不能确保备份的一致性，请重试
InnoDB: An optimized(without redo logging) DDLoperation has been performed. All modified pages may not have been flushed to the disk yet.
PXB will not be able take a consistent backup. Retry the backup operation
# 断言失败
2017-06-01 08:43:19 0x7f396ee27700InnoDB: Assertion failure in thread 139884650198784 in file ut0ut.cc line 916
# 故意生成一个内存陷阱，使备份中断
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
00:43:19 UTC - xtrabackup got signal 6 ;
This could be because you hit a bug or data is corrupted.
This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0 thread_stack 0x10000
/usr/local/xtrabackup/bin/innobackupex(my_print_stacktrace+0x35)
/usr/local/xtrabackup/bin/innobackupex(handle_fatal_signal+0x273)
/lib64/libpthread.so.0
/lib64/libc.so.6(gsignal+0x35)
/lib64/libc.so.6(abort+0x175)
/usr/local/xtrabackup/bin/innobackupex
/usr/local/xtrabackup/bin/innobackupex(_ZN2ib5fatalD1Ev+0xb3)
/usr/local/xtrabackup/bin/innobackupex
/usr/local/xtrabackup/bin/innobackupex(_Z19recv_parse_log_recsm7store_tb+0x4df)
/usr/local/xtrabackup/bin/innobackupex
/usr/local/xtrabackup/bin/innobackupex
/usr/local/xtrabackup/bin/innobackupex
/lib64/libpthread.so.0
/lib64/libc.so.6(clone+0x6d)
Please report a bug at https://bugs.launchpad.net/percona-xtrabackup
页:
[1]