| 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; |