Debian Codegraph @

mysql-test/suite/innodb/t/xa_recovery.test

raw
1
2 CREATE TABLE t1 (a INT) ENGINE=InnoDB;
3 INSERT INTO t1 VALUES (1);
4 connect (con1,localhost,root);
5 XA START 'x'; UPDATE t1 set a=2; XA END 'x'; XA PREPARE 'x';
6 connection default;
7
8 call mtr.add_suppression("Found 1 prepared XA transactions");
9
10 --source include/kill_and_restart_mysqld.inc
11
12 disconnect con1;
13 connect (con1,localhost,root);
14 --send SELECT * FROM t1 LOCK IN SHARE MODE
15
16 connection default;
17 let $wait_condition=
18 select count(*) = 1 from information_schema.processlist
19 where state = 'executing' and
20 info = 'SELECT * FROM t1 LOCK IN SHARE MODE';
21 --source include/wait_condition.inc
22
23 --source include/restart_mysqld.inc
24
25 disconnect con1;
26
27 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
28 SELECT * FROM t1;
29 XA ROLLBACK 'x';
30 SELECT * FROM t1;
31
32 DROP TABLE t1;
33
34 --echo #
35 --echo # Bug #31437127 - ERROR LOG REPORTS INVALID (OLD?) TABLE OR DATABASE NAME:
36 --echo # ERROR] [MY-010520] [Server] Invalid (old?) table or database name 't1#p#p1'
37 --echo #
38
39 call mtr.add_suppression("Found .* prepared XA transactions");
40 CREATE TABLE t1(a INT PRIMARY KEY, b INT) PARTITION BY HASH(a) PARTITIONS 4;
41 connect (con1,localhost,root);
42
43 --connection con1
44 XA BEGIN '123';
45 INSERT INTO t1 VALUES(1,2);
46 XA END '123';
47 XA PREPARE '123';
48
49 --connection default
50 #restart
51 --source include/restart_mysqld.inc
52
53 disconnect con1;
54
55 --connection default
56 XA RECOVER;
57 XA COMMIT '123';
58 DROP TABLE t1;