Debian Codegraph @

mysql-test/suite/galera_3nodes_sr/t/galera_sr_isolate_master.test

raw
1 --source include/galera_cluster.inc
2 --source include/have_innodb.inc
3
4 --disable_ps2_protocol
5 #
6 # Test the effect of gmcast.isolate on master during an SR transaction
7 #
8 --connect node_3, 127.0.0.1, root, , test, $NODE_MYPORT_3
9
10 # Save original auto_increment_offset values.
11 --let $node_1=node_1
12 --let $node_2=node_2
13 --let $node_3=node_3
14 --source ../galera/include/auto_increment_offset_save.inc
15
16 --connection node_1
17 CREATE TABLE t1 (f1 INTEGER) ENGINE=InnoDB;
18
19 SET SESSION wsrep_trx_fragment_size = 1;
20
21 SET AUTOCOMMIT=OFF;
22 START TRANSACTION;
23 INSERT INTO t1 VALUES (1);
24 INSERT INTO t1 VALUES (2);
25 INSERT INTO t1 VALUES (3);
26 INSERT INTO t1 VALUES (4);
27 INSERT INTO t1 VALUES (5);
28
29 SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log;
30
31 --connection node_2
32 --let $wait_condition = SELECT COUNT(*) > 0 FROM mysql.wsrep_streaming_log
33 --source include/wait_condition.inc
34
35 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
36 SELECT COUNT(*) > 0 FROM t1;
37
38 #
39 # Trigger gmcast.isolate=1 .
40 # The transaction is aborted and we expect the SR tables to be cleaned up
41 #
42
43 --connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1
44 --connection node_1a
45 SET GLOBAL wsrep_provider_options='gmcast.isolate=1';
46
47 --connection node_2
48 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
49 --source include/wait_condition.inc
50 --source include/galera_wait_ready.inc
51
52 --connection node_3
53 --let $wait_condition = SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
54 --source include/wait_condition.inc
55 --source include/galera_wait_ready.inc
56
57 #
58 # Expect that the transaction is cleaned up entirely across the cluster and in all mysql.wsrep_streaming_log tables
59 #
60
61 --connection node_2
62 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
63 --let $wait_condition = SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
64 --source include/wait_condition.inc
65 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
66 SELECT COUNT(*) = 0 FROM t1;
67
68 --connection node_3
69 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
70 --let $wait_condition = SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
71 --source include/wait_condition.inc
72 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
73 SELECT COUNT(*) = 0 FROM t1;
74
75 #
76 # Restore cluster
77 #
78
79 --connection node_1a
80 SET GLOBAL wsrep_provider_options='gmcast.isolate=0';
81
82 --connection node_2
83 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
84 --source include/wait_condition.inc
85
86 --connection node_3
87 --let $wait_condition = SELECT VARIABLE_VALUE = 3 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size'
88 --source include/wait_condition.inc
89
90 --connection node_1a
91 --source include/galera_wait_ready.inc
92
93 #
94 # Confirm that the previous transaction is gone on Node #1 as well
95 #
96
97 --connection node_1
98 --error ER_LOCK_DEADLOCK
99 COMMIT;
100
101 SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED;
102 SELECT COUNT(*) = 0 FROM t1;
103
104 --let $wait_condition = SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
105 --source include/wait_condition.inc
106
107 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
108
109 #
110 # Confirm that the transaction can be retried
111 #
112
113 START TRANSACTION;
114 INSERT INTO t1 VALUES (1);
115 INSERT INTO t1 VALUES (2);
116 INSERT INTO t1 VALUES (3);
117 INSERT INTO t1 VALUES (4);
118 INSERT INTO t1 VALUES (5);
119 COMMIT;
120
121 --connection node_2
122 --let $wait_condition = SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
123 --source include/wait_condition.inc
124 SELECT COUNT(*) = 5 FROM t1;
125 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
126
127 --connection node_3
128 --let $wait_condition = SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
129 --source include/wait_condition.inc
130 SELECT COUNT(*) = 5 FROM t1;
131 SELECT COUNT(*) = 0 FROM mysql.wsrep_streaming_log;
132
133 --connection node_1
134 CALL mtr.add_suppression("failed to send SR rollback for");
135 DROP TABLE t1;
136
137 --source ../galera/include/auto_increment_offset_restore.inc
138 --enable_ps2_protocol