xb_incremental.sh checksum mismatch errors with open transactions across backups
Bug #1119451 reported by
Laurynas Biveinis
This bug affects 1 person
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona XtraBackup moved to https://jira.percona.com/projects/PXB |
Invalid
|
Undecided
|
Unassigned |
Bug Description
Discovered while working on bug 1119186.
The current xb_incremental.sh is:
1. CREATE TABLE test;
2. load test;
3. perform a full backup;
4. CREATE TABLE t2;
5. load t2 and add to test;
6. save test and t2 checksums;
7. perform an incremental backup;
7. prepare and restore back;
8. compare checksums.
If this is augmented by a new long transaction that
a. starts after step 2;
b. inserts a row anywhere between steps 2 and 6;
c. commits before step 6,
then the test fails with a checksum mismatch for table test.
This also happens if XA transactions are used.
To post a comment you must log in.
A patched testcase to show the bug (needs common.inc changes to be uploaded too)