Debian Codegraph @

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

raw
1 CREATE TABLE t0 (id INT PRIMARY KEY) ENGINE=InnoDB;
2 CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
3 CREATE TABLE t2 (id INT PRIMARY KEY) ENGINE=InnoDB;
4 CREATE TABLE t3 (id INT PRIMARY KEY) ENGINE=InnoDB;
5 CREATE TABLE t4 (id INT PRIMARY KEY) ENGINE=InnoDB;
6 CREATE TABLE t5 (id INT PRIMARY KEY) ENGINE=InnoDB;
7 INSERT INTO t0 (id) VALUES (1);
8 SET TRANSACTION ISOLATION LEVEL READ COMMITTED;
9 XA START 'x';
10 INSERT INTO t1 (id) VALUES (1);;
11 INSERT INTO t2 (id) VALUES (1);;
12 INSERT INTO t3 (id) VALUES (1);;
13 INSERT INTO t4 (id) VALUES (1);;
14 INSERT INTO t5 (id) VALUES (1);;
15 SELECT * FROM t0 WHERE id=1 FOR UPDATE;
16 id
17 1
18 XA END 'x';
19 SET DEBUG_SYNC='lock_trx_release_read_locks_in_x_mode_will_release
20 SIGNAL c0_releases_in_xmode';
21 SET DEBUG_SYNC='try_relatch_trx_and_shard_and_do_noted_expected_version
22 SIGNAL c0_noted_expected_version
23 WAIT_FOR c0_can_go
24 EXECUTE 5';
25 XA PREPARE 'x';
26 BEGIN;
27 SET DEBUG_SYNC = 'now WAIT_FOR c0_noted_expected_version';
28 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL c0_can_go';
29 SELECT * FROM t1 FOR SHARE;
30 BEGIN;
31 SET DEBUG_SYNC = 'now WAIT_FOR c0_noted_expected_version';
32 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL c0_can_go';
33 SELECT * FROM t2 FOR SHARE;
34 BEGIN;
35 SET DEBUG_SYNC = 'now WAIT_FOR c0_noted_expected_version';
36 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL c0_can_go';
37 SELECT * FROM t3 FOR SHARE;
38 BEGIN;
39 SET DEBUG_SYNC = 'now WAIT_FOR c0_noted_expected_version';
40 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL c0_can_go';
41 SELECT * FROM t4 FOR SHARE;
42 BEGIN;
43 SET DEBUG_SYNC = 'now WAIT_FOR c0_noted_expected_version';
44 SET DEBUG_SYNC='lock_wait_will_wait SIGNAL c0_can_go';
45 SELECT * FROM t5 FOR SHARE;
46 SET DEBUG_SYNC='now WAIT_FOR c0_releases_in_xmode';
47 XA COMMIT 'x';
48 id
49 1
50 COMMIT;
51 id
52 1
53 COMMIT;
54 id
55 1
56 COMMIT;
57 id
58 1
59 COMMIT;
60 id
61 1
62 COMMIT;
63 DROP TABLE t0;
64 DROP TABLE t1;
65 DROP TABLE t2;
66 DROP TABLE t3;
67 DROP TABLE t4;
68 DROP TABLE t5;