Debian Codegraph @

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

raw
1 --echo #
2 --echo # Bug#27189701 INNODB: EARLY RELEASE OF GAP LOCKS FOR RC
3 --echo # ISOLATION [XA PREPARE]
4 --echo #
5
6 --source include/have_debug.inc
7 --source include/have_debug_sync.inc
8 --source include/count_sessions.inc
9
10 CREATE TABLE t1 (col1 INT PRIMARY KEY, col2 int);
11
12 --echo Connection: default
13 SET DEBUG='+d,ib_force_release_gap_lock_prepare';
14
15 --echo # 1.Test GAP lock only on supremum record
16 XA START 'lock_trx';
17 SELECT * FROM t1;
18
19 --echo # Update empty table acquire GAP lock on supremum
20 UPDATE t1 SET col2 = 100 where col1 = 10;
21
22 connect (con1,localhost,root);
23 --echo Connection: con1
24 SET DEBUG_SYNC = 'lock_wait_will_wait SIGNAL con1_will_wait';
25 --send INSERT INTO t1 values(10, 100)
26
27 connection default;
28 SET DEBUG_SYNC = 'now WAIT_FOR con1_will_wait';
29 --echo Connection: default
30 XA END 'lock_trx';
31 XA PREPARE 'lock_trx';
32
33 connection con1;
34 --echo Connection: con1
35 --reap
36 INSERT INTO t1 values(20, 200);
37 SELECT * FROM t1 ORDER BY col1;
38
39 connection default;
40 --echo Connection: default
41 XA COMMIT 'lock_trx';
42
43 --echo # 2.Test GAP lock on multiple records
44 XA START 'lock_trx_1';
45
46 --echo # Update table acquire GAP lock on all rows
47 UPDATE t1 SET col2 = col2 + 1;
48
49 connection con1;
50 --echo Connection: con1
51 --send INSERT INTO t1 values(5, 50)
52
53 connection default;
54 --echo Connection: default
55 XA END 'lock_trx_1';
56 XA PREPARE 'lock_trx_1';
57
58 connection con1;
59 --echo Connection: con1
60 --reap
61 INSERT INTO t1 values(15, 150);
62 INSERT INTO t1 values(25, 150);
63
64 SELECT * FROM t1 ORDER BY col1;
65
66 disconnect con1;
67
68 connection default;
69 --echo Connection: default
70 XA COMMIT 'lock_trx_1';
71 SELECT * FROM t1 ORDER BY col1;
72
73 SET DEBUG='-d,ib_force_release_gap_lock_prepare';
74
75 DROP TABLE t1;
76
77 --source include/wait_until_count_sessions.inc