Debian Codegraph @

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

raw
1 #######################################################################################
2 # Desc : In a group, do majority crash which includes primary member.
3 # Test the setup.
4 # WL9426 : MySQL NG: Single Primary Mode in Group Replication
5 # Test :
6 # 0. This test requires 3 servers.
7 # 1. Bootstrap GR on server1 (PRIMARY). Start GR on server2 and server3.
8 # 2. Crash PRIMARY (server1) and one SECONDARY (server3) members. The group
9 # should be blocked due to majority loss.
10 # 3. Unblock the group on server2.
11 # 4. Test that server2 (earlier SECONDARY) is unblocked and promoted as PRIMARY.
12 # 5. Add some data on server2.
13 # 6. Bring back crashed members to the group.
14 # 7. Wait for data to recover in the group.
15 # 8. Clean up.
16 #######################################################################################
17 # This test does crashes servers, thence we skip it on valgrind.
18 --source include/not_valgrind.inc
19 --source include/big_test.inc
20 --source include/force_restart.inc
21 --source include/have_group_replication_plugin.inc
22 --let $rpl_server_count= 3
23 --let $rpl_skip_group_replication_start= 1
24 --let $rpl_group_replication_single_primary_mode=1
25 --source include/group_replication.inc
26
27 # Start group replication on all the servers
28 --let $rpl_connection_name= server1
29 --source include/rpl_connection.inc
30
31 --source include/start_and_bootstrap_group_replication.inc
32 --let $member1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
33 # save this, since it will be used to recover the server later on
34 --let $local_address_server1= `SELECT @@GLOBAL.group_replication_local_address`
35 --let $group_seeds_server1= `SELECT @@GLOBAL.group_replication_group_seeds`
36
37 --let $rpl_connection_name= server2
38 --source include/rpl_connection.inc
39 --source include/start_group_replication.inc
40 --let $member2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
41
42 --let $rpl_connection_name= server3
43 --source include/rpl_connection.inc
44 --source include/start_group_replication.inc
45 --let $member3_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
46 # save this, since it will be used to recover the server later on
47 --let $local_address_server3= `SELECT @@GLOBAL.group_replication_local_address`
48 --let $group_seeds_server3= `SELECT @@GLOBAL.group_replication_group_seeds`
49
50 --echo # Crash the two servers(1 primary + 1 secondary) out of 3 to cause a majority loss
51 --let $rpl_connection_name= server1
52 --source include/rpl_connection.inc
53
54 # Make sure server1 has been given the role of primary
55 --let $server1_uuid= `SELECT @@server_uuid`
56 --let $group_replication_expected_uuid= $server1_uuid
57 --source include/gr_wait_primary_member_uuid.inc
58
59 # We do kill the servers almost simultaneously, only restarting them
60 # after both have crashed.
61
62 --source include/kill_mysqld.inc
63 --let $server1_expect_file_name= $_expect_file_name
64
65 --let $rpl_connection_name= server3
66 --source include/rpl_connection.inc
67 --source include/kill_and_restart_mysqld.inc
68
69
70 # reset the group_replication_id var
71 --let $group_replication_member_id= $member2_uuid
72
73 # Start server 1 now after server 3 was killed.
74 --let $rpl_connection_name= server1
75 --source include/rpl_connection.inc
76 --let $_expect_file_name= $server1_expect_file_name
77 --source include/start_mysqld.inc
78
79 --let $rpl_server_number= 1
80 --source include/rpl_reconnect.inc
81
82 --let $rpl_server_number= 3
83 --source include/rpl_reconnect.inc
84
85 --let $rpl_connection_name= server1
86 --source include/rpl_connection.inc
87 --replace_result $group_seeds_server1 GROUP_SEEDS_SERVER1
88 --eval SET @@global.group_replication_group_seeds="$group_seeds_server1"
89 --replace_result $local_address_server1 LOCAL_ADDRESS_SERVER1
90 --eval SET @@global.group_replication_local_address="$local_address_server1"
91 --replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
92 --eval SET @@global.group_replication_group_name="$group_replication_group_name"
93 --eval SET @@global.group_replication_enforce_update_everywhere_checks=OFF
94 --eval SET @@global.group_replication_single_primary_mode=ON
95
96 --let $rpl_connection_name= server_3
97 --source include/rpl_connection.inc
98 --replace_result $group_seeds_server3 GROUP_SEEDS_SERVER3
99 --eval SET @@global.group_replication_group_seeds="$group_seeds_server3"
100 --replace_result $local_address_server3 LOCAL_ADDRESS_SERVER3
101 --eval SET @@global.group_replication_local_address="$local_address_server3"
102 --replace_result $group_replication_group_name GROUP_REPLICATION_GROUP_NAME
103 --eval SET @@global.group_replication_group_name="$group_replication_group_name"
104 --eval SET @@global.group_replication_enforce_update_everywhere_checks=OFF
105 --eval SET @@global.group_replication_single_primary_mode=ON
106
107 --let $rpl_connection_name= server2
108 --source include/rpl_connection.inc
109
110 # Make sure server 1 and server 3 are in UNREACHABLE state
111 --echo # Wait for the member state for server1 to be unreachable
112 --let $group_replication_member_state= UNREACHABLE
113 --let $group_replication_member_id= $member1_uuid
114 --source include/gr_wait_for_member_state.inc
115
116 --echo # Wait for the member state for server3 to be unreachable
117 --let $group_replication_member_state= UNREACHABLE
118 --let $group_replication_member_id= $member3_uuid
119 --source include/gr_wait_for_member_state.inc
120
121 # Unblock the group which is caused by majority loss using
122 # group_replication_force_members variable
123 --echo # Connect to primary and unblock the group.
124 --let $local_address_server2= `SELECT @@GLOBAL.group_replication_local_address`
125 --replace_result $local_address_server2 GROUP_REPLICATION_LOCAL_ADDR
126 --eval SET GLOBAL group_replication_force_members= "$local_address_server2"
127
128 # Check for the new primary member after the group is unblocked
129 --let $server2_uuid= `SELECT @@server_uuid`
130 --let $group_replication_expected_uuid= $server2_uuid
131 --source include/gr_wait_primary_member_uuid.inc
132
133 --let $wait_condition= SELECT @@GLOBAL.read_only = '0'
134 --source include/wait_condition_or_abort.inc
135
136 CREATE TABLE test.t1 ( a int primary key);
137 INSERT INTO test.t1 VALUES (1);
138
139 # Start group replication again in server 1 and server 3
140 --let $rpl_connection_name= server1
141 --source include/rpl_connection.inc
142 --source include/start_group_replication.inc
143
144 --let $rpl_connection_name= server3
145 --source include/rpl_connection.inc
146 --source include/start_group_replication.inc
147
148 --let $wait_condition=SELECT COUNT(*)=3 FROM performance_schema.replication_group_members where MEMBER_STATE="ONLINE"
149 --source include/wait_condition.inc
150
151 --let $group_replication_expected_uuid= $server2_uuid
152 --source include/gr_wait_primary_member_uuid.inc
153
154 # Connect to primary and cleanup
155 --let $rpl_connection_name= server2
156 --source include/rpl_connection.inc
157 DROP TABLE test.t1;
158
159 set session sql_log_bin=0;
160 call mtr.add_suppression("The member lost contact with a majority of the members in the group. Until the network is restored.*");
161 call mtr.add_suppression("The member resumed contact with a majority of the members in the group.*");
162 set session sql_log_bin=1;
163
164 --source include/group_replication_end.inc
165