Debian Codegraph @

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

raw
1 #
2 # Validate that when replica IO thread connects to a source which is part of a
3 # replication group, the replication asynchronous connection failover feature
4 # is enabled on the replica and Managed_type of source is 'GroupReplication',
5 # then group members with status ONLINE AND RECOVERY are added to the list of
6 # sources of the replica and warning ER_RPL_ASYNC_SENDER_ADDED is logged.
7 #
8 # Test:
9 # 0. This test requires 4 servers:
10 # server1: primary
11 # server2: secondary
12 # server3: secondary (blocked in RECOVERY state)
13 # server4: single server replica
14 # 1. Bootstrap GR on server1 and join server2
15 # 2. Get server3 pid to later expel it from the group
16 # 3. Add asynchronous connection failover server between server4 and server1
17 # 4. Create and start new channel ch1_4: server4(slave), server1(master)
18 # 5. Confirm server1 and server2 members of group are added to
19 # performance_schema.replication_asynchronous_connection_failover.
20 # 6. Validate that server1 and server2 entries are logged with
21 # ER_RPL_ASYNC_SENDER_ADDED on error log
22 # 7. Lock server3 on recovery and confirm it was added to
23 # performance_schema.replication_asynchronous_connection_failover.
24 # 8. Validate that server1, server2 and server3 entries are logged with
25 # ER_RPL_ASYNC_SENDER_ADDED on error log
26 # 9. Unlock recovery on server3 and confirm it will continue on
27 # performance_schema.replication_asynchronous_connection_failover.
28 # 10. Change of server status will not cause to be logged any extra
29 # message
30 # 11. Clean Up.
31 #
32
33 --source include/have_group_replication_plugin.inc
34 --let $rpl_skip_group_replication_start= 1
35 --let $rpl_server_count= 4
36 --let $rpl_group_replication_single_primary_mode=1
37 --source include/group_replication.inc
38
39 --echo
40 --echo # 1. Bootstrap GR on server1 and join server2
41 --echo
42
43 --let $rpl_connection_name= server1
44 --source include/rpl_connection.inc
45
46 set session sql_log_bin=0;
47 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY , b INT);
48 set session sql_log_bin=1;
49
50 --source include/start_and_bootstrap_group_replication.inc
51
52 --let $_tmp_gr_group_name= `SELECT @@GLOBAL.group_replication_group_name`
53
54 INSERT INTO test.t1 (b) VALUES (1);
55
56 --let $rpl_connection_name= server2
57 --source include/rpl_connection.inc
58
59 set session sql_log_bin=0;
60 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY , b INT);
61 set session sql_log_bin=1;
62
63 --source include/start_group_replication.inc
64
65 --echo
66 --echo # 2. Get server3 pid to later expel it from the group
67 --echo
68
69 --let $rpl_connection_name= server3
70 --source include/rpl_connection.inc
71
72 set session sql_log_bin=0;
73 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY , b INT);
74 set session sql_log_bin=1;
75
76 --let $member3_uuid = `SELECT @@GLOBAL.server_uuid`
77
78
79 --echo
80 --echo # 3. Add asynchronous connection failover server between server4 and server1
81 --echo
82 --let $rpl_connection_name= server4
83 --source include/rpl_connection.inc
84
85 set session sql_log_bin=0;
86 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY , b INT);
87 set session sql_log_bin=1;
88
89 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1 $_tmp_gr_group_name FAILOVER_GROUP_NAME
90 --eval SELECT asynchronous_connection_failover_add_managed('ch1_4', 'GroupReplication', '$_tmp_gr_group_name', '127.0.0.1', $SERVER_MYPORT_1, '', 80, 60);
91
92 --echo
93 --echo # 4. Create and start new channel ch1_4: server4(slave), server1(master)
94 --echo
95
96 --replace_result $SERVER_MYPORT_1 SERVER_1_PORT
97 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_CONNECTION_AUTO_FAILOVER=1, SOURCE_PORT=$SERVER_MYPORT_1, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=2 FOR CHANNEL 'ch1_4'
98
99 --let $rpl_channel_name='ch1_4'
100 --source include/start_slave.inc
101 --let $rpl_channel_name=
102
103 --echo
104 --echo # 5. Confirm server1 and server2 members of group are added to
105 --echo # performance_schema.replication_asynchronous_connection_failover.
106 --echo
107
108 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.replication_asynchronous_connection_failover;
109 --source include/wait_condition.inc
110
111 --let $assert_text= Verify server1 is on replication_asynchronous_connection_failover
112 --let $assert_cond= "[SELECT count(*) COUNT FROM performance_schema.replication_asynchronous_connection_failover WHERE PORT=$SERVER_MYPORT_1, COUNT, 1]" = "1"
113 --source include/assert.inc
114
115 --let $assert_text= Verify server2 is on replication_asynchronous_connection_failover
116 --let $assert_cond= "[SELECT count(*) COUNT FROM performance_schema.replication_asynchronous_connection_failover WHERE PORT=$SERVER_MYPORT_2, COUNT, 1]" = "1"
117 --source include/assert.inc
118
119 --let $assert_text= Verify server3 is not on replication_asynchronous_connection_failover
120 --let $assert_cond= "[SELECT count(*) COUNT FROM performance_schema.replication_asynchronous_connection_failover WHERE PORT=$SERVER_MYPORT_3, COUNT, 1]" = "0"
121 --source include/assert.inc
122
123
124 --echo
125 --echo # 6. Validate that server1 and server2 entries are logged with
126 --echo # ER_RPL_ASYNC_SENDER_ADDED on error log
127 --echo
128
129 --let $rpl_connection_name= server4
130 --source include/rpl_connection.inc
131
132 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.error_log WHERE error_code='MY-013680' AND data LIKE "%for channel 'ch1_4' has joined the group%"
133 --source include/wait_condition.inc
134
135
136 --echo
137 --echo # 7. Lock server3 on recovery and confirm it was added to
138 --echo # performance_schema.replication_asynchronous_connection_failover.
139 --echo
140
141 --let $rpl_connection_name= server_3
142 --source include/rpl_connection.inc
143
144 LOCK TABLES t1 READ;
145
146 --let $rpl_connection_name= server3
147 --source include/rpl_connection.inc
148
149 --let $group_replication_start_member_state= RECOVERING
150 --source include/start_group_replication.inc
151
152 --let $rpl_connection_name= server4
153 --source include/rpl_connection.inc
154
155 --let $wait_condition= SELECT COUNT(*)=3 FROM performance_schema.replication_asynchronous_connection_failover;
156 --source include/wait_condition.inc
157
158 --let $assert_text= Verify server3 is on replication_asynchronous_connection_failover
159 --let $assert_cond= "[SELECT count(*) COUNT FROM performance_schema.replication_asynchronous_connection_failover WHERE PORT=$SERVER_MYPORT_3, COUNT, 1]" = "1"
160 --source include/assert.inc
161
162
163 --echo
164 --echo # 8. Validate that server1, server2 and server3 entries are logged with
165 --echo # ER_RPL_ASYNC_SENDER_ADDED on error log
166 --echo
167
168 --let $rpl_connection_name= server4
169 --source include/rpl_connection.inc
170
171 --let $wait_condition= SELECT COUNT(*)=3 FROM performance_schema.error_log WHERE error_code='MY-013680' AND data LIKE "%for channel 'ch1_4' has joined the group%"
172 --source include/wait_condition.inc
173
174
175 --echo
176 --echo # 9. Unlock recovery on server3 and confirm it will continue on
177 --echo # performance_schema.replication_asynchronous_connection_failover.
178 --echo
179
180 --let $rpl_connection_name= server_3
181 --source include/rpl_connection.inc
182
183 UNLOCK TABLES;
184
185 --let $rpl_connection_name= server4
186 --source include/rpl_connection.inc
187
188 --let $wait_condition= SELECT COUNT(*)=3 FROM performance_schema.replication_asynchronous_connection_failover;
189 --source include/wait_condition.inc
190
191 --echo
192 --echo # 10. Change of server status will not cause to be logged any extra
193 --echo # message
194 --echo
195
196 --let $wait_condition= SELECT COUNT(*)=3 FROM performance_schema.error_log WHERE error_code='MY-013680' AND data LIKE "%for channel 'ch1_4' has joined the group%"
197 --source include/wait_condition.inc
198
199
200 --echo
201 --echo # 11. Clean Up.
202 --echo
203
204 SET SESSION sql_log_bin = 0;
205 call mtr.add_suppression("The source .* for channel 'ch1_4' has joined the group .*, and so added its entry into replication_asynchronous_connection_failover table.");
206 call mtr.add_suppression("The group .* for the channel .* has been removed, and so removed its entry from replication_asynchronous_connection_failover_managed and all the group members from replication_asynchronous_connection_failover table.");
207 call mtr.add_suppression("The group .* for the channel .* has been added, and so added its entry in replication_asynchronous_connection_failover_managed and source to replication_asynchronous_connection_failover table.");
208 SET SESSION sql_log_bin = 1;
209
210 --let $rpl_channel_name='ch1_4'
211 --source include/stop_slave.inc
212
213 --let $rpl_reset_slave_all= 1
214 --let $rpl_multi_source= 1
215 --source include/rpl_reset_slave.inc
216 --let $rpl_channel_name=
217 --let $rpl_reset_slave_all=
218 --let $rpl_multi_source=
219
220 --replace_result $group_replication_group_name GROUP_NAME
221 --eval SELECT asynchronous_connection_failover_delete_managed('ch1_4', '$group_replication_group_name')
222
223 DROP TABLE t1;
224
225 --let $rpl_connection_name= server1
226 --source include/rpl_connection.inc
227
228 DROP TABLE t1;
229
230 --let $rpl_skip_sync= 1
231 --let $rpl_only_running_threads= 1
232 --source include/group_replication_end.inc