Debian Codegraph @

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

raw
1 #
2 # Bug#20872655 XA ROLLBACK IS NOT CRASH-SAFE
3 #
4 CREATE TABLE t(a INT PRIMARY KEY, b INT UNIQUE) ENGINE=INNODB;
5 INSERT INTO t SET a=0;
6 connect con1,localhost,root;
7 XA START 'zombie';
8 INSERT INTO t SET a=1;
9 UPDATE t SET b=1 WHERE a=1;
10 SELECT COUNT(*) FROM t;
11 COUNT(*)
12 2
13 XA END 'zombie';
14 XA PREPARE 'zombie';
15 SET DEBUG_SYNC='trx_after_rollback_row SIGNAL s1 WAIT_FOR s2';
16 XA ROLLBACK 'zombie';
17 connection default;
18 SET DEBUG_SYNC='now WAIT_FOR s1';
19 SET GLOBAL innodb_flush_log_at_trx_commit=1;
20 DELETE FROM t LIMIT 1;
21 # restart
22 disconnect con1;
23 XA COMMIT 'zombie';
24 ERROR XAE04: XAER_NOTA: Unknown XID
25 SELECT * FROM t;
26 a b
27 DROP TABLE t;