Debian Codegraph @

mysql-test/suite/galera/r/galera_mdl_race.result

raw
1 connection node_2;
2 connection node_1;
3 connection node_1;
4 CREATE TABLE t1 (f1 INTEGER PRIMARY KEY, f2 CHAR(1)) engine=innodb;
5 CREATE TABLE t2 (f1 INTEGER PRIMARY KEY, f2 CHAR(1)) engine=innodb;
6 INSERT INTO t1 VALUES (1, 'a');
7 INSERT INTO t1 VALUES (2, 'a');
8 SET AUTOCOMMIT=ON;
9 START TRANSACTION;
10 UPDATE t1 SET f2 = 'b' WHERE f1 = 1;
11 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
12 connection node_1a;
13 SET SESSION wsrep_sync_wait=0;
14 LOCK TABLE t2 WRITE;
15 connection node_1;
16 SET DEBUG_SYNC= 'wsrep_before_mdl_wait SIGNAL before_mdl_wait WAIT_FOR mdl_wait_continue';
17 SELECT * FROM t2;;
18 connection node_1a;
19 # Wait until select is blocked before MDL lock wait
20 SET DEBUG_SYNC= 'now WAIT_FOR before_mdl_wait';
21 connection node_1a;
22 SET @@debug_dbug = "d,sync.wsrep_after_BF_victim_lock";
23 connection node_2;
24 UPDATE t1 SET f2 = 'c' WHERE f1 = 1;
25 connect node_1b, 127.0.0.1, root, , test, $NODE_MYPORT_1;
26 connection node_1b;
27 SET SESSION wsrep_sync_wait=0;
28 # Wait for conflicting update to block
29 SET DEBUG_SYNC = "now SIGNAL signal.wsrep_after_BF_victim_lock";
30 connect node_1c, 127.0.0.1, root, , test, $NODE_MYPORT_1;
31 connection node_1c;
32 connection node_1a;
33 SET DEBUG_SYNC = "now SIGNAL BF_victim_continue";
34 UNLOCK TABLES;
35 connection node_1;
36 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
37 connection node_1;
38 SELECT COUNT(*) AS EXPECT_1 FROM t1 WHERE f2 = 'a';
39 EXPECT_1
40 1
41 SELECT COUNT(*) AS EXPECT_1 FROM t1 WHERE f2 = 'c';
42 EXPECT_1
43 1
44 SELECT * FROM t1;
45 f1 f2
46 1 c
47 2 a
48 connection node_2;
49 SELECT COUNT(*) AS EXPECT_1 FROM t1 WHERE f2 = 'a';
50 EXPECT_1
51 1
52 SELECT COUNT(*) AS EXPECT_1 FROM t1 WHERE f2 = 'c';
53 EXPECT_1
54 1
55 SELECT * FROM t1;
56 f1 f2
57 1 c
58 2 a
59 DROP TABLE t1;
60 DROP TABLE t2;
61 connection node_1a;
62 SET DEBUG_SYNC = "RESET";
63 connection node_1b;
64 SET DEBUG_SYNC = "RESET";
65 connection node_1;
66 disconnect node_1a;
67 disconnect node_1b;
68 disconnect node_1c;