Debian Codegraph @

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

raw
1 #
2 # The IO thread MUST not connect to RECOVERING group member because recovery
3 # can take time and that would unnecessary delay receiver in getting binary
4 # logs.
5 #
6 # Test:
7 #
8 # 0. The test requires 3 servers:
9 # server1: primary
10 # server2: secondary
11 # server3: single server replica
12 # 1. Bootstrap group with server1
13 # 2. Lock server2 on recovery and join it to the group
14 # 3. Establish managed connection between server3 and server1.
15 # Secondaries priority is higher than primary
16 # 4. Create and start new channel ch1_3: server1(source),
17 # server3(replica)
18 # 5. Confirm server1 and server2 members of group are added to
19 # performance_schema.replication_asynchronous_connection_failover.
20 # 6. Wait 30 seconds and validate that replica is still connected
21 # to server1.
22 # 7. After UNLOCK tables it shall reconnect to server2
23 # 8. Cleanup
24 #
25
26 --source include/have_group_replication_plugin.inc
27 --let $rpl_skip_group_replication_start= 1
28 --let $rpl_server_count= 3
29 --let $rpl_group_replication_single_primary_mode=1
30 --source include/group_replication.inc
31
32 --echo
33 --echo # 1. Bootstrap group with server1
34 --echo
35
36 --let $rpl_connection_name= server1
37 --source include/rpl_connection.inc
38
39 set session sql_log_bin=0;
40 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY , b INT);
41 set session sql_log_bin=1;
42
43 --source include/start_and_bootstrap_group_replication.inc
44
45 INSERT INTO test.t1 (b) VALUES (1);
46
47 --let $member1_uuid = `SELECT @@GLOBAL.server_uuid`
48 --let $_tmp_gr_group_name= `SELECT @@GLOBAL.group_replication_group_name`
49
50 --echo
51 --echo # 2. Lock server2 on recovery and join it to the group
52 --echo
53
54 --let $rpl_connection_name= server2
55 --source include/rpl_connection.inc
56
57 set session sql_log_bin=0;
58 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY , b INT);
59 set session sql_log_bin=1;
60
61 --let $rpl_connection_name= server_2
62 --source include/rpl_connection.inc
63
64 LOCK TABLES t1 READ;
65
66 --let $rpl_connection_name= server2
67 --source include/rpl_connection.inc
68
69 --let $member2_uuid = `SELECT @@GLOBAL.server_uuid`
70
71 --let $group_replication_start_member_state= RECOVERING
72 --source include/start_group_replication.inc
73
74 --echo
75 --echo # 3. Establish managed connection between server3 and server1.
76 --echo # Secondaries priority is higher than primary
77 --echo
78
79 --let $rpl_connection_name= server3
80 --source include/rpl_connection.inc
81
82 set session sql_log_bin=0;
83 CREATE TABLE t1 (a INT NOT NULL AUTO_INCREMENT PRIMARY KEY , b INT);
84 set session sql_log_bin=1;
85
86 --replace_result $SERVER_MYPORT_1 SERVER_MYPORT_1 $_tmp_gr_group_name FAILOVER_GROUP_NAME
87 --eval SELECT asynchronous_connection_failover_add_managed('ch1_3', 'GroupReplication', '$_tmp_gr_group_name', '127.0.0.1', $SERVER_MYPORT_1, '', 60, 80);
88
89 --echo
90 --echo # 4. Create and start new channel ch1_3: server1(source),
91 --echo # server3(replica)
92 --echo
93
94 --replace_result $SERVER_MYPORT_1 SERVER_1_PORT
95 --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_3'
96
97 --let $rpl_channel_name='ch1_3'
98 --source include/start_slave.inc
99 --let $rpl_channel_name=
100
101 --echo
102 --echo # 5. Confirm server1 and server2 members of group are added to
103 --echo # performance_schema.replication_asynchronous_connection_failover.
104 --echo
105
106 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.replication_asynchronous_connection_failover;
107 --source include/wait_condition.inc
108
109
110 --echo
111 --echo # 6. Wait 30 seconds and validate that replica is still connected
112 --echo # to server1.
113 --echo
114
115 --sleep 30
116 --let $assert_text= Verify server1 is on replication_asynchronous_connection_failover
117 --let $assert_cond= [SELECT count(*) COUNT FROM performance_schema.replication_connection_status WHERE channel_name = "ch1_3" AND source_uuid = "$member1_uuid", COUNT, 1] = "1"
118 --source include/assert.inc
119
120
121 --echo
122 --echo # 7. After UNLOCK tables it shall reconnect to server2
123 --echo
124
125 --let $rpl_connection_name= server_2
126 --source include/rpl_connection.inc
127
128 UNLOCK TABLES;
129
130 --let $group_replication_member_state= ONLINE
131 --source include/gr_wait_for_member_state.inc
132
133 --let $rpl_connection_name= server3
134 --source include/rpl_connection.inc
135
136 --let $wait_condition= SELECT COUNT(*)=1 COUNT FROM performance_schema.replication_connection_status WHERE channel_name = "ch1_3" AND source_uuid = "$member2_uuid"
137 --source include/wait_condition.inc
138
139 --echo
140 --echo # 8. Cleanup
141 --echo
142
143 SET SESSION sql_log_bin = 0;
144 call mtr.add_suppression("The source .* for channel 'ch1_3' has joined the group .*, and so added its entry into replication_asynchronous_connection_failover table.");
145 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.");
146 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.");
147 SET SESSION sql_log_bin = 1;
148
149
150 --let $rpl_channel_name='ch1_3'
151 --source include/stop_slave.inc
152
153 --let $rpl_reset_slave_all= 1
154 --let $rpl_multi_source= 1
155 --source include/rpl_reset_slave.inc
156 --let $rpl_channel_name=
157 --let $rpl_reset_slave_all=
158 --let $rpl_multi_source=
159
160 --replace_result $group_replication_group_name GROUP_NAME
161 --eval SELECT asynchronous_connection_failover_delete_managed('ch1_3', '$group_replication_group_name')
162
163 CHANGE REPLICATION SOURCE TO SOURCE_AUTO_POSITION=0 FOR CHANNEL 'ch1_3';
164
165 DROP TABLE t1;
166
167 --let $rpl_connection_name= server1
168 --source include/rpl_connection.inc
169
170 DROP TABLE t1;
171
172 --let $rpl_skip_sync= 1
173 --let $rpl_only_running_threads= 1
174 --source include/group_replication_end.inc