Debian Codegraph @

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

raw
1 ################################################################################
2 # Validate group_replication_consistency= 'AFTER' behaviour against a unreachable
3 # member that does not cause majority loss.
4 #
5 # Test:
6 # 00. The test requires three servers: M1, M2 and M3.
7 # 01. Increase the expel timeout.
8 # 02. Create a table on the group.
9 # 03. Make server 3 block before send its prepare message.
10 # This will allow us to deterministically make it
11 # UNREACHABLE while others are waiting for its acknowledge.
12 # 04. Execute T1 on server1.
13 # 05. Wait until T1 is prepared on server3.
14 # 06. Make server 3 UNREACHABLE.
15 # 07. server 1 and 2 are waiting for the acknowledges, they
16 # will not proceed until server3 acknowledges or leaves
17 # the group.
18 # 08. Make server 3 ONLINE.
19 # 09. Unblock T1 prepare on server3.
20 # 10. T1 is committed on all servers.
21 # 11. Clean up.
22 ################################################################################
23 # Test involves sending SIGSTOP and SIGCONT signals using kill Linux command.
24 --source include/linux.inc
25 --source include/have_debug_sync.inc
26 --source include/big_test.inc
27 --source include/force_restart.inc
28 --source include/have_group_replication_plugin.inc
29 --let $rpl_server_count= 3
30 --source include/group_replication.inc
31
32 --echo
33 --echo ############################################################
34 --echo # 01. Increase the expel timeout.
35 --let $rpl_connection_name= server1
36 --source include/rpl_connection.inc
37 SET GLOBAL group_replication_member_expel_timeout = 300;
38 SELECT @@GLOBAL.group_replication_member_expel_timeout;
39
40 --let $rpl_connection_name= server2
41 --source include/rpl_connection.inc
42 SET GLOBAL group_replication_member_expel_timeout = 300;
43 SELECT @@GLOBAL.group_replication_member_expel_timeout;
44
45 --let $rpl_connection_name= server3
46 --source include/rpl_connection.inc
47 SET GLOBAL group_replication_member_expel_timeout = 300;
48 SELECT @@GLOBAL.group_replication_member_expel_timeout;
49
50 SET SESSION sql_log_bin = 0;
51 CREATE TABLE pid_table(pid_no INT PRIMARY KEY);
52 --let $pid_file=`SELECT @@pid_file`
53 --replace_result $pid_file pid_file
54 --eval LOAD DATA LOCAL INFILE '$pid_file' INTO TABLE pid_table
55 --let $server_pid=`SELECT pid_no FROM pid_table`
56 DROP TABLE pid_table;
57 SET SESSION sql_log_bin = 1;
58
59
60 --echo
61 --echo ############################################################
62 --echo # 02. Create a table on the group.
63 --let $rpl_connection_name= server1
64 --source include/rpl_connection.inc
65 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
66
67 --let $rpl_connection_name= server1
68 --source include/rpl_connection.inc
69 --let $member1_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
70
71 --let $rpl_connection_name= server2
72 --source include/rpl_connection.inc
73 --let $member2_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
74
75 --let $rpl_connection_name= server3
76 --source include/rpl_connection.inc
77 --let $member3_uuid= query_get_value(SELECT @@SERVER_UUID, @@SERVER_UUID, 1)
78
79
80 --echo
81 --echo ############################################################
82 --echo # 03. Make server 3 block before send its prepare message.
83 --echo # This will allow us to deterministically make it
84 --echo # UNREACHABLE while others are waiting for its acknowledge.
85 --let $rpl_connection_name= server3
86 --source include/rpl_connection.inc
87 SET @@GLOBAL.DEBUG= '+d,group_replication_wait_before_message_send_after_applier_prepare';
88
89
90 --echo
91 --echo ############################################################
92 --echo # 04. Execute T1 on server1.
93 --let $rpl_connection_name= server1
94 --source include/rpl_connection.inc
95 --send INSERT INTO t1 VALUES (1)
96
97
98 --echo
99 --echo ############################################################
100 --echo # 05. Wait until T1 is prepared on server3.
101 --let $rpl_connection_name= server3
102 --source include/rpl_connection.inc
103 # Wait for the debug sync to be reached.
104 SET DEBUG_SYNC= "now WAIT_FOR signal.after_before_message_send_after_applier_prepare_waiting";
105
106
107 --echo
108 --echo ############################################################
109 --echo # 06. Make server 3 UNREACHABLE.
110 --let $rpl_connection_name= server_3
111 --source include/rpl_connection.inc
112 # Then we send a SIGSTOP to it. This will stop the server from sending the
113 # keep-alive message and thus it will be viewed as a faulty node by the rest of
114 # the group (and consequently expelled).
115 --exec kill -19 $server_pid
116
117 --let $rpl_connection_name= server_1
118 --source include/rpl_connection.inc
119 --let $group_replication_member_state= UNREACHABLE
120 --let $group_replication_member_id= $member3_uuid
121 --source include/gr_wait_for_member_state.inc
122
123 --let $rpl_connection_name= server2
124 --source include/rpl_connection.inc
125 --let $group_replication_member_state= UNREACHABLE
126 --let $group_replication_member_id= $member3_uuid
127 --source include/gr_wait_for_member_state.inc
128
129
130 --echo
131 --echo ############################################################
132 --echo # 07. server 1 and 2 are waiting for the acknowledges, they
133 --echo # will not proceed until server3 acknowledges or leaves
134 --echo # the group.
135 --let $rpl_connection_name= server_1
136 --source include/rpl_connection.inc
137 --let $wait_condition=SELECT COUNT(*)=1 FROM information_schema.processlist WHERE user='root' AND state='waiting for handler commit' AND info='INSERT INTO t1 VALUES (1)'
138 --source include/wait_condition.inc
139
140 --let $rpl_connection_name= server2
141 --source include/rpl_connection.inc
142 --let $wait_condition=SELECT COUNT(*)=1 FROM performance_schema.threads WHERE processlist_state LIKE '%waiting for handler commit%' AND name LIKE 'thread/sql/replica_%'
143 --source include/wait_condition.inc
144
145
146 --echo
147 --echo ############################################################
148 --echo # 08. Make server 3 ONLINE.
149 # Send SIGCONT to server, so it can continue.
150 --let $rpl_connection_name= server_3
151 --source include/rpl_connection.inc
152 --exec kill -18 $server_pid
153
154 --let $rpl_connection_name= server_1
155 --source include/rpl_connection.inc
156 --let $group_replication_member_state= ONLINE
157 --let $group_replication_member_id= $member3_uuid
158 --source include/gr_wait_for_member_state.inc
159
160 --let $rpl_connection_name= server2
161 --source include/rpl_connection.inc
162 --let $group_replication_member_state= ONLINE
163 --let $group_replication_member_id= $member3_uuid
164 --source include/gr_wait_for_member_state.inc
165
166
167 --echo
168 --echo ############################################################
169 --echo # 09. Unblock T1 prepare on server3.
170 --let $rpl_connection_name= server3
171 --source include/rpl_connection.inc
172 # Signal debug sync to continue.
173 SET DEBUG_SYNC= 'now SIGNAL signal.after_before_message_send_after_applier_prepare_continue';
174 SET @@GLOBAL.DEBUG= '-d,group_replication_wait_before_message_send_after_applier_prepare';
175
176
177 --echo
178 --echo ############################################################
179 --echo # 10. T1 is committed on all servers.
180 --let $rpl_connection_name= server1
181 --source include/rpl_connection.inc
182 --reap
183
184 --let $assert_text= 'There is 1 value in table t1'
185 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE c1=1, count, 1] = 1
186 --source include/assert.inc
187
188 --let $rpl_connection_name= server2
189 --source include/rpl_connection.inc
190 --let $assert_text= 'There is 1 value in table t1'
191 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE c1=1, count, 1] = 1
192 --source include/assert.inc
193
194 --let $rpl_connection_name= server3
195 --source include/rpl_connection.inc
196 --let $assert_text= 'There is 1 value in table t1'
197 --let $assert_cond= [SELECT COUNT(*) AS count FROM t1 WHERE c1=1, count, 1] = 1
198 --source include/assert.inc
199
200 --let $diff_tables=server1:t1, server2:t1, server3:t1
201 --source include/diff_tables.inc
202
203
204 --echo
205 --echo ############################################################
206 --echo # 11. Clean up.
207 --let $rpl_connection_name= server1
208 --source include/rpl_connection.inc
209 DROP TABLE t1;
210
211 --source include/group_replication_end.inc