Debian Codegraph @

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

raw
1 #
2 # When a connection is established with a group, all members on UNREACHABLE
3 # state shall be present on senders list
4 #
5 # Test:
6 # 0. This test requires 4 servers. 3 being on GR and 1 replica
7 # 1. Bootstrap GR on server1. Join server2 and server3
8 # 2. Kill server1.
9 # Server will return without starting Group Replication.
10 # 3. Create and start the managed channel connected to server1.
11 # 4. Validate sender list has three possible connections
12 # 5. Clean Up.
13 #
14
15 --source include/have_group_replication_plugin.inc
16 --let $rpl_skip_group_replication_start= 1
17 --let $rpl_server_count= 4
18 --let $rpl_group_replication_single_primary_mode=1
19 --source include/group_replication.inc
20
21 --echo
22 --echo # 1. Bootstrap GR on server1. Join server2 and server3
23 --echo
24
25 --let $rpl_connection_name= server1
26 --source include/rpl_connection.inc
27 --let $server1_uuid= `SELECT @@server_uuid`
28 SET GLOBAL group_replication_member_expel_timeout = 3600;
29 --source include/start_and_bootstrap_group_replication.inc
30 --let $_tmp_gr_group_name= `SELECT @@GLOBAL.group_replication_group_name`
31
32 --let $rpl_connection_name= server2
33 --source include/rpl_connection.inc
34 --let $server2_uuid= `SELECT @@server_uuid`
35 SET GLOBAL group_replication_member_expel_timeout = 3600;
36 --source include/start_group_replication.inc
37
38 --let $rpl_connection_name= server3
39 --source include/rpl_connection.inc
40 --let $server3_uuid= `SELECT @@server_uuid`
41 SET GLOBAL group_replication_member_expel_timeout = 3600;
42 --source include/start_group_replication.inc
43
44 --echo
45 --echo # 2. Kill server1.
46 --echo # Server will return without starting Group Replication.
47 --echo
48 --let $rpl_connection_name= server1
49 --source include/rpl_connection.inc
50 --source include/kill_and_restart_mysqld.inc
51
52 --let $rpl_server_number= 1
53 --source include/rpl_reconnect.inc
54
55 --let $rpl_connection_name= server2
56 --source include/rpl_connection.inc
57 --let $group_replication_member_state= UNREACHABLE
58 --let $group_replication_member_id= $server1_uuid
59 --source include/gr_wait_for_member_state.inc
60
61 --let $rpl_connection_name= server3
62 --source include/rpl_connection.inc
63 --let $group_replication_member_state= UNREACHABLE
64 --let $group_replication_member_id= $server1_uuid
65 --source include/gr_wait_for_member_state.inc
66
67 --echo
68 --echo # 3. Create and start the managed channel connected to server1.
69 --echo
70 --let $rpl_connection_name= server4
71 --source include/rpl_connection.inc
72
73 --replace_result $SERVER_MYPORT_2 SERVER_MYPORT_2 $_tmp_gr_group_name FAILOVER_GROUP_NAME
74 --eval SELECT asynchronous_connection_failover_add_managed('ch2_4', 'GroupReplication', '$_tmp_gr_group_name', '127.0.0.1', $SERVER_MYPORT_2, '', 60, 80);
75
76 --replace_result $SERVER_MYPORT_2 SERVER_2_PORT
77 --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_2, SOURCE_RETRY_COUNT=1, SOURCE_CONNECT_RETRY=1 FOR CHANNEL 'ch2_4'
78
79 --let $rpl_channel_name='ch2_4'
80 --source include/start_slave.inc
81 --let $rpl_channel_name=
82
83 --let $wait_condition= SELECT COUNT(*)=1 FROM performance_schema.replication_connection_status WHERE channel_name='ch2_4' AND source_uuid='$server2_uuid' AND service_state ='ON';
84 --source include/wait_condition.inc
85
86 --echo
87 --echo # 4. Validate sender list has three possible connections
88 --echo
89
90 --let $wait_condition= SELECT COUNT(*)=3 FROM performance_schema.replication_asynchronous_connection_failover
91 --source include/wait_condition.inc
92
93 --let $assert_text= 'There is a row in performance_schema.replication_asynchronous_connection_failover for server1'
94 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover WHERE port=$SERVER_MYPORT_1, count, 1] = 1
95 --source include/assert.inc
96
97 --echo
98 --echo # 5. Revert group_replication_member_expel_timeout to the
99 --echo # default value on server2 and server3, which will cause
100 --echo # server1 to be expelled.
101 --echo
102 --let $rpl_connection_name= server2
103 --source include/rpl_connection.inc
104 SET GLOBAL group_replication_member_expel_timeout = DEFAULT;
105
106 --let $rpl_connection_name= server3
107 --source include/rpl_connection.inc
108 SET GLOBAL group_replication_member_expel_timeout = DEFAULT;
109
110 --let $wait_condition=SELECT COUNT(*)=2 FROM performance_schema.replication_group_members
111 --source include/wait_condition.inc
112
113 --echo
114 --echo # 6. server1 was removed from performance_schema.replication_asynchronous_connection_failover table.
115 --echo
116 --let $rpl_connection_name= server4
117 --source include/rpl_connection.inc
118 --let $wait_condition= SELECT COUNT(*)=2 FROM performance_schema.replication_asynchronous_connection_failover
119 --source include/wait_condition.inc
120
121 --let $assert_text= 'There is no row in performance_schema.replication_asynchronous_connection_failover for server1'
122 --let $assert_cond= [SELECT COUNT(*) count FROM performance_schema.replication_asynchronous_connection_failover WHERE port=$SERVER_MYPORT_1, count, 1] = 0
123 --source include/assert.inc
124
125 --echo
126 --echo # 7. Clean Up.
127 --echo
128
129 SET SESSION sql_log_bin = 0;
130 call mtr.add_suppression("The source .* for channel 'ch2_4' has joined the group .*, and so added its entry into replication_asynchronous_connection_failover table.");
131 call mtr.add_suppression("The Monitor IO thread detected that the source .* does not belong to the group majority, thence the channel .* will try to connect to another source.");
132 call mtr.add_suppression("The source .* for channel 'ch2_4' has left the group .*, and so removed its entry from replication_asynchronous_connection_failover table.");
133 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.");
134 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.");
135 SET SESSION sql_log_bin = 1;
136
137 --let $rpl_channel_name='ch2_4'
138 --source include/stop_slave.inc
139
140 --let $rpl_reset_slave_all= 1
141 --let $rpl_multi_source= 1
142 --source include/rpl_reset_slave.inc
143 --let $rpl_channel_name=
144 --let $rpl_reset_slave_all=
145 --let $rpl_multi_source=
146
147 --replace_result $group_replication_group_name GROUP_NAME
148 --eval SELECT asynchronous_connection_failover_delete_managed('ch2_4', '$group_replication_group_name')
149
150 --let $rpl_connection_name= server1
151 --source include/rpl_connection.inc
152 SET GLOBAL group_replication_member_expel_timeout = DEFAULT;
153
154 --let $rpl_skip_sync= 1
155 --let $rpl_only_running_threads= 1
156 --source include/group_replication_end.inc