Debian Codegraph @

mysql-test/suite/galera/t/galera_mdl_race.test

raw
1 #
2 # This test tests a potential race condition in MDL locking
3 #
4
5 --source include/galera_cluster.inc
6 --source include/have_debug.inc
7 --source include/have_debug_sync.inc
8
9 --connection node_1
10 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(1)) engine=innodb;
11 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY, f2 CHAR(1)) engine=innodb;
12 INSERT INTO t1 VALUES (1, 'a');
13 INSERT INTO t1 VALUES (2, 'a');
14
15 SET AUTOCOMMIT=ON;
16 START TRANSACTION;
17 UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
18
19 # block access to t2
20 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
21 --connection node_1a
22 SET SESSION wsrep_sync_wait=0;
23 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 't2'
24 --let $wait_condition_on_error_output = SELECT * FROM INFORMATION_SCHEMA.TABLES
25 --source include/wait_condition_with_debug.inc
26 LOCK TABLE t2 WRITE;
27
28 # Block before MDL lock wait
29 --connection node_1
30 SET DEBUG_SYNC= 'wsrep_before_mdl_wait SIGNAL before_mdl_wait WAIT_FOR mdl_wait_continue';
31 --send SELECT * FROM t2;
32
33 --connection node_1a
34 --echo # Wait until select is blocked before MDL lock wait
35 SET DEBUG_SYNC= 'now WAIT_FOR before_mdl_wait';
36
37 # block applier to wait after BF victim is locked
38 --connection node_1a
39 SET @@debug_dbug = "d,sync.wsrep_after_BF_victim_lock";
40
41 # Issue a conflicting update on node #2
42 --connection node_2
43 UPDATE t1 SET f2 = 'c' WHERE f1 = 1;
44
45 --connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1
46 --connection node_1b
47 SET SESSION wsrep_sync_wait=0;
48 --echo # Wait for conflicting update to block
49 --let $wait_condition = SELECT COUNT(*) = 1 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE 'Update_rows_log_event:%';
50 --source include/wait_condition.inc
51
52 # Unblock the SELECT, to enter wsrep_thd_is_BF
53 SET DEBUG_SYNC = "now SIGNAL signal.wsrep_after_BF_victim_lock";
54
55 --connect node_1c, 127.0.0.1, root, , test, $NODE_MYPORT_1
56 --connection node_1c
57 --let $wait_condition = SELECT COUNT(*) = 0 FROM INFORMATION_SCHEMA.PROCESSLIST WHERE STATE LIKE 'Update_rows_log_event:%';
58 --source include/wait_condition.inc
59
60 --connection node_1a
61 # unblock applier to try to BF the SELECT
62 SET DEBUG_SYNC = "now SIGNAL BF_victim_continue";
63
64 # table lock is not needed anymore
65 UNLOCK TABLES;
66
67 # SELECT returns deadlock
68 --connection node_1
69 --error ER_LOCK_DEADLOCK
70 --reap
71
72 --connection node_1
73 SELECT COUNT(*) AS EXPECT_1 FROM t1 WHERE f2 = 'a';
74 SELECT COUNT(*) AS EXPECT_1 FROM t1 WHERE f2 = 'c';
75 SELECT * FROM t1;
76
77 --connection node_2
78 SELECT COUNT(*) AS EXPECT_1 FROM t1 WHERE f2 = 'a';
79 SELECT COUNT(*) AS EXPECT_1 FROM t1 WHERE f2 = 'c';
80 SELECT * FROM t1;
81
82 DROP TABLE t1;
83 DROP TABLE t2;
84
85 --connection node_1a
86 SET DEBUG_SYNC = "RESET";
87 --connection node_1b
88 SET DEBUG_SYNC = "RESET";
89
90 --connection node_1
91 --disconnect node_1a
92 --disconnect node_1b
93 --disconnect node_1c