Debian Codegraph @

mysql-test/suite/group_replication/t/gr_recovery_completion_mode.test

raw
1 ################################################################################
2 # This test evaluates both recovery policies on when a member should become
3 # online.
4 #
5 # Test:
6 # 0. The test requires two servers.
7 #
8 # Phase 1: Recovery only waits for the certification of all cached transactions
9 # 1. Create 2 tables (t1,t2) on both servers
10 # 2. Start group replication on server1 with some data inserted on t1
11 # 3. Lock table t1 on server 2 and start group replication
12 # Recovery will get stuck as the member can't execute data on t1
13 # 4. Lock table t2 on server 2 and insert some data on t2 on server 1
14 # Recovery application of cached data is blocked as t2 is locked
15 # 5. Unlock t1 and recovery first phase will unblock.
16 # The member should become online as it does not wait for the application
17 # of cached transactions, only its certification.
18 # 6. Clean up.
19 #
20 # Phase 2: Recovery waits for the execution of all executed transactions
21 # 1. Create 2 tables (t1,t2) on both servers
22 # 2. Start group replication on server1 with some data inserted on t1
23 # 3. Lock table t1 on server 2 and start group replication
24 # Recovery will get stuck as the member can't execute data on t1
25 # 4. Lock table t2 on server 2 and insert some data on t2 on server 1
26 # Recovery application of cached data is blocked as t2 is locked
27 # 5. Unlock t1 and recovery first phase will unblock.
28 # The member should still be on recovery as the server is waiting for the
29 # execution of cached transactions and t2 is locked.
30 # 6. Unlock t2 and the application of cached transactions will unblock.
31 # The member should become online.
32 # 7. Clean up.
33 ################################################################################
34
35 --source include/big_test.inc
36 --let $group_replication_group_name= 08033a70-3560-11e5-a2cb-0800200c9a66
37 --source include/have_group_replication_plugin.inc
38 --let $rpl_skip_group_replication_start= 1
39 --source include/group_replication.inc
40
41 --echo ######################################################################
42 --echo # Phase 1:
43 --echo # Recovery only waits for the certification of all cached transactions
44 --echo ######################################################################
45
46 --echo #
47 --echo # Create t1 and t2 on both servers
48 --echo # Start group replication on server 1 after inserting data on t1
49 --echo #
50
51 --connection server1
52 --echo server1
53
54 SET SESSION sql_log_bin=0;
55 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
56 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
57 SET SESSION sql_log_bin=1;
58
59 --source include/start_and_bootstrap_group_replication.inc
60
61 INSERT INTO t1 VALUES (1);
62
63 --connection server2
64 --echo server2
65
66 SET SESSION sql_log_bin=0;
67 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
68 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
69 SET SESSION sql_log_bin=1;
70
71 --echo #
72 --echo # Lock table t1 and table t2 on server 2
73 --echo # Table t1: Blocks first phase of recovery
74 --echo # Table t2: Blocks second phase of recovery
75 --echo #
76
77 SET @configured_rec_policy= @@GLOBAL.group_replication_recovery_complete_at;
78 SET GLOBAL group_replication_recovery_complete_at= "transactions_certified";
79
80 --connection server_2
81 --echo server_2 (server2)
82 LOCK TABLE t1 READ;
83
84 --connection slave
85 --echo slave (server2)
86 LOCK TABLE t2 READ;
87
88 --echo #
89 --echo # Start group replication on server 2 and check it is stuck on recovery
90 --echo #
91
92 --connection server2
93 --echo server2
94
95 --let $group_replication_start_member_state= RECOVERING
96 --source include/start_group_replication.inc
97
98 --echo #
99 --echo # Insert some transaction on server 1 that will be cached on server 2
100 --echo #
101
102 --connection server1
103 --echo server1
104
105 # Wait for the View Change event to reach the binlog.
106 --eval SELECT WAIT_FOR_EXECUTED_GTID_SET('$group_replication_group_name:3')
107 INSERT INTO t2 VALUES (1);
108
109 --echo #
110 --echo # UnLock table t1: First phase of recovery can carry on.
111 --echo # Member 1 is online as it only waits for certification of cached data
112 --echo #
113
114 --connection server_2
115 --echo server_2 (server2)
116
117 UNLOCK TABLES;
118
119 --connection server2
120 --echo server2
121
122 --let $group_replication_member_state= ONLINE
123 --source include/gr_wait_for_member_state.inc
124
125 --echo #
126 --echo # UnLock table t2: Second phase of recovery can carry on.
127 --echo # The data should be there.
128 --echo #
129
130 --connection slave
131 --echo slave (server2)
132
133 UNLOCK TABLES;
134
135 --let $wait_condition= SELECT COUNT(*)=1 FROM t2;
136 --source include/wait_condition.inc
137
138 --echo #
139 --echo # Phase 1 cleanup
140 --echo # Remove the data from the tables and stop group replication on server 2
141 --echo #
142
143 --connection server1
144 --echo server1
145
146 TRUNCATE TABLE t1;
147 TRUNCATE TABLE t2;
148
149 --source include/rpl_sync.inc
150
151 --connection server2
152 --echo server2
153
154 --source include/stop_group_replication.inc
155
156 --echo ######################################################################
157 --echo # Phase 2:
158 --echo # Recovery waits for the execution of all executed transactions
159 --echo ######################################################################
160
161 --echo #
162 --echo # Start group replication on server 1 after inserting data on t1
163 --echo #
164
165 --connection server1
166 --echo server1
167
168 INSERT INTO t1 VALUES (1);
169
170 --echo #
171 --echo # Change recovery policy on server 2 to wait for transaction execution.
172 --echo #
173
174 --connection server2
175 --echo server2
176
177 SET GLOBAL group_replication_recovery_complete_at= "transactions_applied";
178
179 --echo #
180 --echo # Lock table t1 and table t2 on server 2
181 --echo # Table t1: Blocks first phase of recovery
182 --echo # Table t2: Blocks second phase of recovery
183 --echo #
184
185 --connection server_2
186 --echo server_2 (server2)
187
188 LOCK TABLE t1 READ;
189
190 --connection slave
191 --echo slave (server2)
192
193 LOCK TABLE t2 READ;
194
195 --echo #
196 --echo # Start group replication on server 2 and check it is stuck on recovery
197 --echo #
198
199 --connection server2
200 --echo server2
201
202 --let $group_replication_start_member_state= RECOVERING
203 --source include/start_group_replication.inc
204
205 --echo #
206 --echo # Insert some transaction on server 1 that will be cached on server 2
207 --echo #
208
209 --connection server1
210 --echo server1
211
212 INSERT INTO t2 VALUES (1);
213
214 --echo #
215 --echo # Wait for the transactions to be cached on server 2
216 --echo #
217
218 --connection server2
219 --echo server2
220
221 --let $wait_condition= SELECT COUNT_TRANSACTIONS_IN_QUEUE=2 FROM performance_schema.replication_group_member_stats where member_id in (SELECT @@server_uuid);
222 --source include/wait_condition.inc
223
224 --echo #
225 --echo # UnLock table t1: First phase of recovery can carry on.
226 --echo # Member 2 is still recovering as it can't apply cached data
227 --echo #
228
229 --connection server_2
230 --echo server_2 (server2)
231
232 UNLOCK TABLES;
233
234 --connection server2
235 --echo server2
236
237 --let $server2_uuid= `SELECT @@GLOBAL.SERVER_UUID`
238 --let $member_state= query_get_value(SELECT Member_State from performance_schema.replication_group_members WHERE member_id= '$server2_uuid', Member_State, 1)
239 --let $assert_text= The value of member_state should be recovering
240 --let $assert_cond= "$member_state" = "RECOVERING"
241 --source include/assert.inc
242
243 --echo #
244 --echo # UnLock table t2: Second phase of recovery can carry on.
245 --echo # The data should be there and the member should now be online.
246 --echo #
247
248 --connection slave
249 --echo slave (server2)
250
251 UNLOCK TABLES;
252
253 --let $wait_condition= SELECT COUNT(*)=1 FROM t2;
254 --source include/wait_condition.inc
255
256 --let $group_replication_member_state= ONLINE
257 --source include/gr_wait_for_member_state.inc
258
259 --echo #
260 --echo # Test cleanup
261 --echo #
262
263 --connection server2
264 --echo server2
265
266 DROP TABLE t1;
267 DROP TABLE t2;
268
269 SET GLOBAL group_replication_recovery_complete_at= @configured_rec_policy;
270
271 --source include/group_replication_end.inc