Debian Codegraph @

mysql-test/suite/innodb/r/xa_recovery_debug.result

raw
1 #
2 # Bug#20872655 XA ROLLBACK IS NOT CRASH-SAFE
3 #
4 SET GLOBAL xa_detach_on_prepare = OFF;
5 CREATE TABLE t(a INT PRIMARY KEY, b INT UNIQUE) ENGINE=INNODB;
6 XA START 'zombie';
7 insert into t(a) values (0);
8 update t set b=a;
9 SELECT COUNT(*) FROM t;
10 COUNT(*)
11 1
12 XA END 'zombie';
13 XA PREPARE 'zombie';
14 SET DEBUG_SYNC='trx_xa_rollback SIGNAL s1 WAIT_FOR s2';
15 XA ROLLBACK 'zombie';
16 SET DEBUG_SYNC='now WAIT_FOR s1';
17 SET GLOBAL innodb_log_checkpoint_now=ON;
18 # Kill and restart
19 XA COMMIT 'zombie';
20 ERROR XAE04: XAER_NOTA: Unknown XID
21 SELECT COUNT(*) FROM t;
22 COUNT(*)
23 0
24 DROP TABLE t;
25 SET GLOBAL xa_detach_on_prepare = OLD_VALUE_xa_detach_on_prepare;