Debian Codegraph @

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

raw
1 #
2 ## ==== Purpose ====
3 ##
4 ## This test checks if the immediate_commit_timestamp (ICT) and the
5 ## original_commit_timestamp (OCT) are generated and replicated correctly in
6 ## transations originated both inside and outside the group, with the following
7 ## replication topology: server1 -> group -> server4 (server2, server3 and
8 ## server5 are members of the group, with server2 setup as slave of server1).
9 ## server5 will only be added to the group after all transactions have been
10 ## executed to verify that the timestamps were propagated correctly from the
11 ## donor.
12 ## The test also checks if the queueing_transaction and last_queued_transaction
13 ## fields are cleared from the group_replication_recovery channel after the
14 ## member is online.
15 ## The test also check that the last_applied_transaction is in the correct state
16 ## for both channels when a server joins a group.
17 ##
18 ## ==== Implementation ====
19 ##
20 ## Considering the previously mentioned replication chain, we make the following
21 ## assertions:
22 ## 1) original_commit_timestamp is the same across all servers
23 ## 2) On the original server, original_commit_timestamp = immediate_commit_timestamp.
24 ## (unless the transaction was originated inside the group).
25 ## 3) the immediate_commit_timestamp increases as we go down in the topology
26 ## (not applicable between group members).
27 ## This assertions are performed in two examples of DDL statements and three
28 ## different DML statements.
29 ##
30 ## ==== References ====
31 ##
32 ## WL#7319 Infrastructure for GTID based delayed replication and replication lag
33 ## monitoring
34 ## WL#7374 Performance schema tables to monitor replication lags and queue
35
36
37 --source include/big_test.inc
38 --source include/have_group_replication_plugin.inc
39 --let $rpl_skip_group_replication_start= 1
40 --let $rpl_server_count= 5
41 --let $rpl_multi_source= 1
42 --source include/group_replication.inc
43
44 # start first member of the group
45 --let $rpl_connection_name= server2
46 --source include/rpl_connection.inc
47 --source include/start_and_bootstrap_group_replication.inc
48 # this group member is also a slave of server1
49 # (server2 was implicitely set up as slave of server1 in include/group_replication.inc)
50 --source include/start_slave.inc
51
52
53 # start second member of the group
54 --let $rpl_connection_name= server3
55 --source include/rpl_connection.inc
56 --source include/start_group_replication.inc
57
58 --let $rpl_connection_name= server2
59 --source include/rpl_connection.inc
60 --let $group_replication_number_of_members= 2
61 --source include/gr_wait_for_number_of_members.inc
62
63 --let $rpl_connection_name= server3
64 --source include/rpl_connection.inc
65 --let $queueing_trx= query_get_value(SELECT QUEUEING_TRANSACTION FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME = "group_replication_recovery", QUEUEING_TRANSACTION, 1)
66 --let $last_queued_trx= query_get_value(SELECT LAST_QUEUED_TRANSACTION FROM performance_schema.replication_connection_status WHERE CHANNEL_NAME = "group_replication_recovery", LAST_QUEUED_TRANSACTION, 1)
67
68 --let $assert_text= QUEUEING_TRANSACTION was cleared in the group_replication_recovery channel after the member is online
69 --let $assert_cond= "$queueing_trx" = ""
70 --source include/assert.inc
71
72 --let $assert_text= LAST_QUEUED_TRANSACTION was cleared in the group_replication_recovery channel after the member is online
73 --let $assert_cond= "$last_queued_trx" = ""
74 --source include/assert.inc
75
76 # check last_applied_transaction in table performance_schema.replication_applier_status_by_worker
77 --let $last_applied_trx_applier= query_get_value(SELECT LAST_APPLIED_TRANSACTION FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME="group_replication_applier", LAST_APPLIED_TRANSACTION,1)
78 --let $last_applied_trx_recovery= query_get_value(SELECT LAST_APPLIED_TRANSACTION FROM performance_schema.replication_applier_status_by_worker WHERE CHANNEL_NAME="group_replication_recovery", LAST_APPLIED_TRANSACTION,1)
79
80 --let $assert_text= LAST_APPLIED_TRANSACTION is not cleared because channel group_replication_recovery applied view change log events for joining the group
81 --let $assert_cond= "$last_applied_trx_recovery" != ""
82 --source include/assert.inc
83
84 # start server4 as slave of server2
85 --let $rpl_connection_name= server4
86 --source include/rpl_connection.inc
87 --disable_warnings
88 --replace_result $SERVER_MYPORT_2 SERVER_MYPORT_2
89 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_PORT=$SERVER_MYPORT_2, SOURCE_USER='root', SOURCE_AUTO_POSITION=1
90 --enable_warnings
91 --source include/start_slave.inc
92
93 # run transactions on server1
94 --let $rpl_connection_name= server1
95 --source include/rpl_connection.inc
96 --let $server_1_uuid= query_get_value(select @@global.server_uuid, @@global.server_uuid, 1)
97 CREATE DATABASE db1;
98 CREATE TABLE db1.t1(a INT PRIMARY KEY);
99 INSERT INTO db1.t1 VALUES(1);
100 UPDATE db1.t1 SET a= 2;
101 DELETE FROM db1.t1 WHERE a= 1;
102 DROP TABLE db1.t1;
103 DROP DATABASE db1;
104
105 # sync server2 with its master, server1
106 --let $sync_slave_connection= server2
107 --source include/sync_slave_sql_with_master.inc
108
109 # sync group members
110 --let $rpl_connection_name= server2
111 --source include/rpl_connection.inc
112 --let $sync_slave_connection= server3
113 --source include/sync_slave_sql_with_master.inc
114
115 # sync server4 with its master, server2
116 --let $rpl_connection_name= server2
117 --source include/rpl_connection.inc
118 --let $sync_slave_connection= server4
119 --source include/sync_slave_sql_with_master.inc
120
121 # run transactions on server2
122 --let $rpl_connection_name= server2
123 --source include/rpl_connection.inc
124 CREATE DATABASE db1;
125 CREATE TABLE db1.t1(a INT PRIMARY KEY);
126 INSERT INTO db1.t1 VALUES(1);
127 UPDATE db1.t1 SET a= 2;
128 DELETE FROM db1.t1 WHERE a= 1;
129 DROP TABLE db1.t1;
130 DROP DATABASE db1;
131
132 # sync group members
133 --let $rpl_connection_name= server2
134 --source include/rpl_connection.inc
135 --let $sync_slave_connection= server3
136 --source include/sync_slave_sql_with_master.inc
137
138 # sync server4 with its master, server2
139 --let $rpl_connection_name= server2
140 --source include/rpl_connection.inc
141 --let $sync_slave_connection= server4
142 --source include/sync_slave_sql_with_master.inc
143
144 # start third member of the group (which will be synced with the group as it joins)
145 --let $rpl_connection_name= server5
146 --source include/rpl_connection.inc
147 --source include/start_group_replication.inc
148
149 # check if replication timestamps from server1 were propagated correctly
150 --let $i= 1
151 while ($i<8)
152 {
153 --let $gtid= $server_1_uuid:$i
154
155 --let $master= server1
156 --let $slave= server2
157 --let $check_master_OCT= 1
158 --let $check_master_slave_ICT= 1
159 --source extra/rpl_tests/rpl_replication_timestamps.inc
160
161 --let $server_1= server1
162 --let $server_2= server2
163 --let $server_3= server4
164 --source extra/rpl_tests/rpl_timestamps_line_topology.inc
165
166 --let $master= server2
167 --let $slave= server3
168 --let $check_master_OCT= 0
169 --let $check_master_slave_ICT= 0
170 --source extra/rpl_tests/rpl_replication_timestamps.inc
171
172 --let $master= server2
173 --let $slave= server5
174 --source extra/rpl_tests/rpl_replication_timestamps.inc
175
176 --inc $i
177 }
178
179 # check View_change log events
180 --let $i= 1
181 while ($i<3)
182 {
183 --let $gtid= $group_replication_group_name:$i
184
185 --let $master= server2
186 --let $slave= server4
187 --let $check_master_OCT= 0
188 --let $check_master_slave_ICT= 1
189 --source extra/rpl_tests/rpl_replication_timestamps.inc
190
191 --let $rpl_connection_name= server_2
192 --source include/rpl_connection.inc
193 --source include/get_original_commit_timestamp.inc
194 --let $server_OCT= $original_commit_timestamp
195 --source include/get_immediate_commit_timestamp.inc
196 --let $server_ICT= $immediate_commit_timestamp
197
198 --let $assert_text= Assert that the View_change_event ICT is bigger than zero for server_2.
199 --let $assert_cond= $server_ICT > 0
200 --source include/assert.inc
201
202 --let $assert_text= Assert that the View_change_event OCT is bigger than zero for server_2.
203 --let $assert_cond= $server_OCT > 0
204 --source include/assert.inc
205
206 --let $rpl_connection_name= server_3
207 --source include/rpl_connection.inc
208 --source include/get_original_commit_timestamp.inc
209 --let $server_OCT= $original_commit_timestamp
210 --source include/get_immediate_commit_timestamp.inc
211 --let $server_ICT= $immediate_commit_timestamp
212
213 --let $assert_text= Assert that the View_change_event ICT is bigger than zero for server_3.
214 --let $assert_cond= $server_ICT > 0
215 --source include/assert.inc
216
217 --let $assert_text= Assert that the View_change_event OCT is bigger than zero for server_3.
218 --let $assert_cond= $server_OCT > 0
219 --source include/assert.inc
220
221 --let $rpl_connection_name= server_5
222 --source include/rpl_connection.inc
223 --source include/get_original_commit_timestamp.inc
224 --let $server_OCT= $original_commit_timestamp
225 --source include/get_immediate_commit_timestamp.inc
226 --let $server_ICT= $immediate_commit_timestamp
227
228 --let $assert_text= Assert that the View_change_event ICT is bigger than zero for server_3.
229 --let $assert_cond= $server_ICT > 0
230 --source include/assert.inc
231
232 --let $assert_text= Assert that the View_change_event OCT is bigger than zero for server_3.
233 --let $assert_cond= $server_OCT > 0
234 --source include/assert.inc
235
236 --inc $i
237 }
238
239 # check the remaining transactions
240 # (the first two events, both View change log events, have already been checked)
241 --let $i= 3
242 while ($i<9)
243 {
244 --let $gtid= $group_replication_group_name:$i
245
246 --let $master= server2
247 --let $slave= server4
248 --let $check_master_OCT= 0
249 --let $check_master_slave_ICT= 1
250 --source extra/rpl_tests/rpl_replication_timestamps.inc
251
252 --let $master= server2
253 --let $slave= server3
254 --let $check_master_slave_ICT= 0
255 --source extra/rpl_tests/rpl_replication_timestamps.inc
256
257 --let $master= server2
258 --let $slave= server5
259 --source extra/rpl_tests/rpl_replication_timestamps.inc
260
261 --inc $i
262 }
263
264 # cleanup
265 --let $rpl_connection_name= server2
266 --source include/rpl_connection.inc
267 --let $rpl_channel_name= 'channel_1'
268 --source include/stop_slave.inc
269 --source include/rpl_reset_slave.inc
270
271 --let $rpl_connection_name= server4
272 --source include/rpl_connection.inc
273 --let $rpl_channel_name=
274 --source include/stop_slave.inc
275 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION= 0;
276
277 --let $rpl_skip_sync= 1
278 --source include/group_replication_end.inc