Debian Codegraph @

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

raw
1 CREATE TABLE t1 (a INT PRIMARY KEY) ENGINE=InnoDB;
2 INSERT INTO t1 VALUES (1);
3 connect con1,localhost,root;
4 XA START 'x';
5 UPDATE t1 set a=2;
6 XA END 'x';
7 XA PREPARE 'x';
8 connect con2,localhost,root;
9 CREATE TABLE t2 (a INT PRIMARY KEY) ENGINE=InnoDB;
10 XA START 'y';
11 INSERT INTO t2 VALUES (1);
12 XA END 'y';
13 XA PREPARE 'y';
14 connection default;
15 # restart: --innodb-force-recovery=2
16 disconnect con1;
17 disconnect con2;
18 connect con1,localhost,root;
19 SET STATEMENT innodb_lock_wait_timeout=1 FOR # work around MDEV-38741
20 SELECT * FROM t1 LOCK IN SHARE MODE;
21 connection default;
22 SET innodb_lock_wait_timeout=1;
23 DROP TABLE t2;
24 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
25 disconnect con1;
26 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
27 SELECT * FROM t1;
28 a
29 2
30 XA ROLLBACK 'x';
31 SELECT * FROM t1;
32 a
33 1
34 DROP TABLE t2;
35 ERROR HY000: Lock wait timeout exceeded; try restarting transaction
36 XA ROLLBACK 'y';
37 DROP TABLE t2;
38 CREATE TABLE t3(a INT PRIMARY KEY REFERENCES t1(a)) ENGINE=InnoDB;
39 XA START 'a';
40 INSERT INTO t3 SET a=1;
41 INSERT INTO t3 SET a=42;
42 ERROR 23000: Cannot add or update a child row: a foreign key constraint fails (`test`.`t3`, CONSTRAINT `t3_ibfk_1` FOREIGN KEY (`a`) REFERENCES `t1` (`a`))
43 XA END 'a';
44 XA PREPARE 'a';
45 SET GLOBAL innodb_fast_shutdown=0;
46 # restart
47 XA COMMIT 'a';
48 SELECT * FROM t3;
49 a
50 1
51 DROP TABLE t3,t1;