xtrabackup Assertion failure with Apply log process
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Fix Released
|
Medium
|
Sergei Glushchenko | ||
2.1 |
Triaged
|
Medium
|
Sergei Glushchenko | ||
2.2 |
Fix Released
|
Medium
|
Sergei Glushchenko | ||
2.3 |
Fix Released
|
Medium
|
Sergei Glushchenko |
Bug Description
While applying the log we are facing an assertion failure issue with xtrabackup version 2.1.9 so we decided to upgrade the tool to version 2.2.3. But still we are hitting the same error.
The issue is not occurring on every try, last time we found the issue when we initiated an incremental backup proceeding to a full backup. We have completed the full backup successfully but the incremental ended with the same error. Log details are given below.
Version :
[05:54:02 xxx@xxxx:~]# xtrabackup -v
xtrabackup version 2.2.3 based on MySQL server 5.6.17 Linux (x86_64) (revision id: )
[xxxx@xxxxxx~]$ innobackupex --version
InnoDB Backup Utility v1.5.1-xtrabackup; Copyright 2003, 2009 Innobase Oy
mysql version: 5.6.17-66.0-log
Log:
InnoDB: Progress in percent: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99
InnoDB: Apply batch completed
InnoDB: In a MySQL replication slave the last master binlog file
InnoDB: position 0 329970412, file name data3-bin.001806
InnoDB: Last MySQL binlog file position 0 883545871, file name data1-bin.002972
InnoDB: 128 rollback segment(s) are active.
InnoDB: Waiting for purge to start
InnoDB: 5.6.17 started; log sequence number 13967966489023
[notice (again)]
If you use binary log and don't use any hack of group commit,
the binary log position seems to be:
InnoDB: Last MySQL binlog file position 0 883545871, file name data1-bin.002972
xtrabackup: starting shutdown with innodb_
InnoDB: FTS optimize thread exiting.
InnoDB: Starting shutdown...
2014-09-12 05:13:40 4a7ee940 InnoDB: Assertion failure in thread 1249831232 in file buf0flu.cc line 2503
InnoDB: Failing assertion: UT_LIST_
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://
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://
InnoDB: about forcing recovery.
innobackupex: Error:
innobackupex: ibbackup failed at /usr/bin/
Changed in percona-xtrabackup: | |
status: | Incomplete → New |
Changed in percona-xtrabackup: | |
status: | Incomplete → New |
I tried it with full + incremental scheme but was not able to reproduce it. Can you please show exact commands you used.