Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/r/galera_sr_isolate_master.result

raw
1 connection node_2;
2 connection node_1;
3 connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3;
4 connection node_1;
5 connection node_2;
6 connection node_3;
7 connection node_1;
8 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
9 SET SESSION wsrep_trx_fragment_size = 1;
10 SET AUTOCOMMIT=OFF;
11 START TRANSACTION;
12 INSERT INTO t1 VALUES (1);
13 INSERT INTO t1 VALUES (2);
14 INSERT INTO t1 VALUES (3);
15 INSERT INTO t1 VALUES (4);
16 INSERT INTO t1 VALUES (5);
17 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
18 COUNT(*) > 0
19 1
20 connection node_2;
21 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
22 SELECT COUNT(*) > 0 FROM t1;
23 COUNT(*) > 0
24 1
25 connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
26 connection node_1a;
27 SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
28 connection node_2;
29 connection node_3;
30 connection node_2;
31 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
32 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
33 COUNT(*) = 0
34 1
35 SELECT COUNT(*) = 0 FROM t1;
36 COUNT(*) = 0
37 1
38 connection node_3;
39 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
40 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
41 COUNT(*) = 0
42 1
43 SELECT COUNT(*) = 0 FROM t1;
44 COUNT(*) = 0
45 1
46 connection node_1a;
47 SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
48 connection node_2;
49 connection node_3;
50 connection node_1a;
51 connection node_1;
52 COMMIT;
53 ERROR 40001: Deadlock found when trying to get lock; try restarting transaction
54 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
55 SELECT COUNT(*) = 0 FROM t1;
56 COUNT(*) = 0
57 1
58 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
59 COUNT(*) = 0
60 1
61 START TRANSACTION;
62 INSERT INTO t1 VALUES (1);
63 INSERT INTO t1 VALUES (2);
64 INSERT INTO t1 VALUES (3);
65 INSERT INTO t1 VALUES (4);
66 INSERT INTO t1 VALUES (5);
67 COMMIT;
68 connection node_2;
69 SELECT COUNT(*) = 5 FROM t1;
70 COUNT(*) = 5
71 1
72 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
73 COUNT(*) = 0
74 1
75 connection node_3;
76 SELECT COUNT(*) = 5 FROM t1;
77 COUNT(*) = 5
78 1
79 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
80 COUNT(*) = 0
81 1
82 connection node_1;
83 CALL mtr.add_suppression("failed to send SR rollback for");
84 DROP TABLE t1;