1CALL mtr.add_suppression("Found 1 prepared XA transactions"); 2RESET MASTER; 3CREATE TABLE t1 (a INT) ENGINE=INNODB; 4XA START 'test1'; 5INSERT t1 VALUES (10); 6XA END 'test1'; 7XA PREPARE 'test1'; 8XA RECOVER; 9formatID gtrid_length bqual_length data 101 5 0 test1 11# xtrabackup backup 12XA ROLLBACK 'test1'; 13# xtrabackup prepare and rollback prepared XA 14# shutdown server 15# remove datadir 16# xtrabackup move back 17# restart 18XA RECOVER; 19formatID gtrid_length bqual_length data 20# xtrabackup prepare and DO NOT rollback prepared XA 21# shutdown server 22# remove datadir 23# xtrabackup move back 24# restart 25XA RECOVER; 26formatID gtrid_length bqual_length data 271 5 0 test1 28XA ROLLBACK 'test1'; 29# xtrabackup prepare for export and rollback prepared XA 30# shutdown server 31# remove datadir 32# xtrabackup move back 33# restart 34XA RECOVER; 35formatID gtrid_length bqual_length data 36# xtrabackup prepare for export and DO NOT rollback prepared XA 37# shutdown server 38# remove datadir 39# xtrabackup move back 40# restart 41XA RECOVER; 42formatID gtrid_length bqual_length data 431 5 0 test1 44XA ROLLBACK 'test1'; 45DROP TABLE t1; 46