Debian Codegraph @

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

raw
1 ###############################################################################
2 # Validate that when a failover is deleted, its status shared with the group is
3 # also deleted.
4 #
5 # Test:
6 # 0. This test requires three servers:
7 # server1, server2: group
8 # server3: single server
9 # 2. Configure and start a failover channel on server1 that
10 # replicates from server3.
11 # 3. Validate server1 and server2 configuration.
12 # 4. Stop and delete channel 'ch1' on server1 and server2.
13 # 5. Validate server1 and server2 configuration.
14 # 6. Add server3 to the group.
15 # 7. Clean up.
16 ###############################################################################
17 --source include/big_test.inc
18 --source include/have_group_replication_plugin.inc
19 --let $rpl_skip_group_replication_start= 1
20 --let $rpl_server_count= 4
21 --source include/group_replication.inc
22
23
24 --echo
25 --echo ############################################################
26 --echo # 1. Deploy a group in single-primary mode on server1 and server2.
27 --let $rpl_connection_name= server1
28 --source include/rpl_connection.inc
29 --source include/start_and_bootstrap_group_replication.inc
30 --source include/gr_assert_primary_member.inc
31
32 --let $rpl_connection_name= server2
33 --source include/rpl_connection.inc
34 --replace_result $SERVER_MYPORT_4 SERVER_4_PORT
35 --eval CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_CONNECTION_AUTO_FAILOVER=0, SOURCE_PORT=$SERVER_MYPORT_4, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1 FOR CHANNEL 'ch1'
36
37 --source include/start_group_replication.inc
38 --source include/gr_assert_secondary_member.inc
39
40
41 --echo
42 --echo ############################################################
43 --echo # 2. Configure and start a failover channel on server1 that
44 --echo # replicates from server4.
45 --let $rpl_connection_name= server4
46 --source include/rpl_connection.inc
47 --let $server4_uuid= `SELECT @@server_uuid`
48
49 --let $rpl_connection_name= server1
50 --source include/rpl_connection.inc
51 --replace_result $SERVER_MYPORT_4 SERVER_4_PORT
52 --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_4, SOURCE_CONNECT_RETRY=1, SOURCE_RETRY_COUNT=1 FOR CHANNEL 'ch1'
53
54 --replace_result $SERVER_MYPORT_4 SERVER_MYPORT_4
55 --eval SELECT asynchronous_connection_failover_add_source('ch1', '127.0.0.1', $SERVER_MYPORT_4, '', 50);
56
57 --let $rpl_channel_name='ch1'
58 --source include/start_slave.inc
59
60
61 --echo
62 --echo ############################################################
63 --echo # 3. Validate server1 and server2 configuration.
64 --let $rpl_connection_name= server1
65 --source include/rpl_connection.inc
66
67 --let $assert_text= 'There is 1 row in performance_schema.replication_asynchronous_connection_failover'
68 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 1
69 --source include/assert.inc
70
71 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 1'
72 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 1
73 --source include/assert.inc
74
75 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1'
76 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
77 --source include/assert.inc
78
79 --let $assert_text= Verify channel ch1 IO_THREAD is ON and connected to server4
80 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_connection_status WHERE channel_name=\'ch1\' AND source_uuid=\'$server4_uuid\', SERVICE_STATE, 1]" = "ON"
81 --source include/assert.inc
82
83 --let $assert_text= Verify channel ch1 SQL_THREAD is ON
84 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_applier_status WHERE channel_name = \'ch1\', SERVICE_STATE, 1]" = "ON"
85 --source include/assert.inc
86
87 --let $assert_text= Verify replica_monitor thread is running
88 --let $assert_cond= "[select count(*) FROM performance_schema.threads where NAME=\"thread/sql/replica_monitor\"]" = 1;
89 --source include/assert.inc
90
91 --let $rpl_connection_name= server2
92 --source include/rpl_connection.inc
93
94 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_asynchronous_connection_failover
95 --source include/wait_condition.inc
96
97 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 1'
98 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 1
99 --source include/assert.inc
100
101 --let $assert_text= 'SOURCE_CONNECTION_AUTO_FAILOVER must be enabled on ch1'
102 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1" AND SOURCE_CONNECTION_AUTO_FAILOVER=1, count, 1] = 1
103 --source include/assert.inc
104
105 --let $assert_text= Verify channel ch1 IO_THREAD is OFF
106 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_connection_status WHERE channel_name=\'ch1\', SERVICE_STATE, 1]" = "OFF"
107 --source include/assert.inc
108
109 --let $assert_text= Verify channel ch1 SQL_THREAD is OFF
110 --let $assert_cond= "[SELECT SERVICE_STATE FROM performance_schema.replication_applier_status WHERE channel_name = \'ch1\', SERVICE_STATE, 1]" = "OFF"
111 --source include/assert.inc
112
113 --let $assert_text= Verify replica_monitor thread is not running
114 --let $assert_cond= "[select count(*) FROM performance_schema.threads where NAME=\"thread/sql/replica_monitor\"]" = 0;
115 --source include/assert.inc
116
117
118 --echo
119 --echo ############################################################
120 --echo # 4. Stop and delete channel 'ch1' on server1 and server2.
121 --let $rpl_connection_name= server2
122 --source include/rpl_connection.inc
123 --let $rpl_channel_name='ch1'
124 --let $rpl_multi_source= 1
125 --let $rpl_reset_slave_all= 1
126 --source include/rpl_reset_slave.inc
127 --let $rpl_channel_name=
128 --let $rpl_multi_source=
129
130 --let $rpl_connection_name= server1
131 --source include/rpl_connection.inc
132 --let $rpl_channel_name='ch1'
133 --source include/stop_slave.inc
134
135 --let $rpl_channel_name='ch1'
136 --let $rpl_multi_source= 1
137 --let $rpl_reset_slave_all= 1
138 --source include/rpl_reset_slave.inc
139 --let $rpl_channel_name=
140 --let $rpl_multi_source=
141
142 --replace_result $SERVER_MYPORT_4 SERVER_MYPORT_4
143 --eval SELECT asynchronous_connection_failover_delete_source('ch1', '127.0.0.1', $SERVER_MYPORT_4, '');
144
145
146 --echo
147 --echo ############################################################
148 --echo # 5. Validate server1 and server2 configuration.
149 --let $rpl_connection_name= server1
150 --source include/rpl_connection.inc
151
152 --let $assert_text= 'There are 0 rows in performance_schema.replication_asynchronous_connection_failover'
153 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 0
154 --source include/assert.inc
155
156 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 2'
157 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 2
158 --source include/assert.inc
159
160 --let $assert_text= 'Verify ch1 was deleted'
161 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1", count, 1] = 0
162 --source include/assert.inc
163
164 --let $assert_text= Verify replica_monitor thread is not running
165 --let $assert_cond= "[select count(*) FROM performance_schema.threads where NAME=\"thread/sql/replica_monitor\"]" = 0;
166 --source include/assert.inc
167
168 --let $rpl_connection_name= server2
169 --source include/rpl_connection.inc
170
171 --let $wait_condition= SELECT COUNT(*)=0 FROM performance_schema.replication_asynchronous_connection_failover
172 --source include/wait_condition.inc
173
174 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 2'
175 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 2
176 --source include/assert.inc
177
178 --let $assert_text= 'Verify ch1 was deleted'
179 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1", count, 1] = 0
180 --source include/assert.inc
181
182 --let $assert_text= Verify replica_monitor thread is not running
183 --let $assert_cond= "[select count(*) FROM performance_schema.threads where NAME=\"thread/sql/replica_monitor\"]" = 0;
184 --source include/assert.inc
185
186
187 --echo
188 --echo ############################################################
189 --echo # 6. Add server3 to the group.
190 --let $rpl_connection_name= server3
191 --source include/rpl_connection.inc
192 --source include/start_group_replication.inc
193 --source include/gr_assert_secondary_member.inc
194
195 --let $assert_text= 'There are 0 rows in performance_schema.replication_asynchronous_connection_failover'
196 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover, count, 1] = 0
197 --source include/assert.inc
198
199 --let $assert_text= 'The version of replication_asynchronous_connection_failover must be 2'
200 --let $assert_cond= [SELECT version FROM performance_schema.replication_group_configuration_version WHERE name=\'replication_asynchronous_connection_failover\', version, 1] = 2
201 --source include/assert.inc
202
203 --let $assert_text= 'Verify ch1 does noet exist'
204 --let $assert_cond= [SELECT COUNT(*) AS count FROM performance_schema.replication_connection_configuration WHERE CHANNEL_NAME="ch1", count, 1] = 0
205 --source include/assert.inc
206
207 --let $assert_text= Verify replica_monitor thread is not running
208 --let $assert_cond= "[select count(*) FROM performance_schema.threads where NAME=\"thread/sql/replica_monitor\"]" = 0;
209 --source include/assert.inc
210
211
212 --echo
213 --echo ############################################################
214 --echo # 7. Clean up.
215 --let $rpl_connection_name= server3
216 --source include/rpl_connection.inc
217 --source include/stop_group_replication.inc
218
219 --let $rpl_connection_name= server2
220 --source include/rpl_connection.inc
221 --source include/stop_group_replication.inc
222
223 --let $rpl_connection_name= server1
224 --source include/rpl_connection.inc
225 --source include/stop_group_replication.inc
226
227 --source include/group_replication_end.inc