MySQL xtrabackup备份失败记录

来源:转载


收到报警,某个端口备份失败,查看备份日志如下,显示有DDL操作导致的备份中断,查看当时的二进制日志,当时执行了一条添加字段的sql语句。目前只能重新执行备份,并修改备份时间,避免再发生类似情况。

MySQL:5.7.11

xtrabackup:2.4.5

查找到官方修复bug的情况:

Running DDL statements onPercona Server5.7 during the backup process could in some cases lead to failure while preparing the backup. Bug fixed#1555626.

MySQL5.7 can sometimes skip redo logging when creating an index. If suchALTERTABLEis being issued during the backup, the backup would be inconsistent.xtrabackupwill now abort with error message if suchALTERTABLEhas been done during the backup. Bug fixed#1582345.

所以说这种情况是正常的,应尽量避免在备份时执行这些sql

备份日志:

InnoDB:Lastflushedlsn:340748764928load_indexlsn340748904772
#一个DDL操作已经执行(未记录redo日志)。影响到的行可能未落地,PXB不能确保备份的一致性,请重试
[FATAL]InnoDB:Anoptimized(withoutredologging)DDLoperationhasbeenperformed.Allmodifiedpagesmaynothavebeenflushedtothediskyet.
PXBwillnotbeabletakeaconsistentbackup.Retrythebackupoperation
#断言失败
2017-06-0108:43:190x7f396ee27700InnoDB:Assertionfailureinthread139884650198784infileut0ut.ccline916
#故意生成一个内存陷阱,使备份中断
InnoDB:Weintentionallygenerateamemorytrap.
InnoDB:Submitadetailedbugreporttohttp://bugs.mysql.com.
InnoDB:Ifyougetrepeatedassertionfailuresorcrashes,even
InnoDB:immediatelyafterthemysqldstartup,theremaybe
InnoDB:corruptionintheInnoDBtablespace.Pleasereferto
InnoDB:http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
InnoDB:aboutforcingrecovery.
00:43:19UTC-xtrabackupgotsignal6;
Thiscouldbebecauseyouhitabugordataiscorrupted.
Thiserrorcanalsobecausedbymalfunctioninghardware.
Attemptingtocollectsomeinformationthatcouldhelpdiagnosetheproblem.
Asthisisacrashandsomethingisdefinitelywrong,theinformation
collectionprocessmightfail.
Threadpointer:0x0
Attemptingbacktrace.Youcanusethefollowinginformationtofindout
wheremysqlddied.Ifyouseenomessagesafterthis,somethingwent
terriblywrong...
stack_bottom=0thread_stack0x10000
/usr/local/xtrabackup/bin/innobackupex(my_print_stacktrace+0x35)[0xd55c45]
/usr/local/xtrabackup/bin/innobackupex(handle_fatal_signal+0x273)[0xb0d5a3]
/lib64/libpthread.so.0[0x36ac20f710]
/lib64/libc.so.6(gsignal+0x35)[0x36abe32625]
/lib64/libc.so.6(abort+0x175)[0x36abe33e05]
/usr/local/xtrabackup/bin/innobackupex[0x7bfbe5]
/usr/local/xtrabackup/bin/innobackupex(_ZN2ib5fatalD1Ev+0xb3)[0x837743]
/usr/local/xtrabackup/bin/innobackupex[0x8af4a1]
/usr/local/xtrabackup/bin/innobackupex(_Z19recv_parse_log_recsm7store_tb+0x4df)[0x8b20ef]
/usr/local/xtrabackup/bin/innobackupex[0x763b60]
/usr/local/xtrabackup/bin/innobackupex[0x764176]
/usr/local/xtrabackup/bin/innobackupex[0x764523]
/lib64/libpthread.so.0[0x36ac2079d1]
/lib64/libc.so.6(clone+0x6d)[0x36abee88fd]
Pleasereportabugathttps://bugs.launchpad.net/percona-xtrabackup

分享给朋友:
您可能感兴趣的文章:
随机阅读: