Debian Codegraph @

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

raw
1 ################################################################################
2 # Validate that BEFORE, AFTER and BEFORE_AND_AFTER values can only be used on
3 # group_replication_consistency on ONLINE members.
4 #
5 # Test:
6 # 00. The test requires two servers: M1 and M2.
7 # 01. Create two tables on each server before start the group.
8 # 02. Lock table t1 on server2 to block a future update.
9 # 03. Bootstrap group on server1.
10 # 04. Execute transactions T1 on server1.
11 # T1 will block server2 on RECOVERING state.
12 # 05. Start group on server2, it will be on RECOVERING state.
13 # 06. Unlock table t1 on server2.
14 # Member will move to ONLINE state.
15 # 07. Execute transactions T2 on server1.
16 # T2 will make server2 move to ERROR state due to
17 # duplicate key.
18 # 08. Stop group on server2.
19 # Member will move to OFFLINE state.
20 # 09. Clean up.
21 ################################################################################
22 --source include/have_group_replication_plugin.inc
23 --let $rpl_skip_group_replication_start= 1
24 --source include/group_replication.inc
25
26 --echo
27 --echo ############################################################
28 --echo # 01. Create two tables on each server before start the group.
29 --let $rpl_connection_name= server1
30 --source include/rpl_connection.inc
31 SET SESSION sql_log_bin = 0;
32 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
33 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY);
34 SET SESSION sql_log_bin = 1;
35
36 --let $rpl_connection_name= server2
37 --source include/rpl_connection.inc
38 SET SESSION sql_log_bin = 0;
39 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
40 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY);
41 INSERT INTO t2 VALUES (1);
42
43 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': Could not execute Write_rows event on table");
44 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': Worker [0-9] failed executing transaction*");
45 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped,*");
46 call mtr.add_suppression("The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group.");
47 call mtr.add_suppression("Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.");
48 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
49 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
50 SET SESSION sql_log_bin = 1;
51
52
53 --echo
54 --echo ############################################################
55 --echo # 02. Lock table t1 on server2 to block a future update.
56 --let $rpl_connection_name= server_2
57 --source include/rpl_connection.inc
58 LOCK table t1 READ;
59
60
61 --echo
62 --echo ############################################################
63 --echo # 03. Bootstrap group on server1.
64 --let $rpl_connection_name= server1
65 --source include/rpl_connection.inc
66 --source include/start_and_bootstrap_group_replication.inc
67
68
69 --echo
70 --echo ############################################################
71 --echo # 04. Execute transactions T1 on server1.
72 --echo # T1 will block server2 on RECOVERING state.
73 --let $rpl_connection_name= server1
74 --source include/rpl_connection.inc
75 # T1
76 INSERT INTO t1 VALUES (1);
77
78
79 --echo
80 --echo ############################################################
81 --echo # 05. Start group on server2, it will be on RECOVERING state.
82 --let $rpl_connection_name= server2
83 --source include/rpl_connection.inc
84 --let $group_replication_start_member_state= RECOVERING
85 --source include/start_group_replication.inc
86
87 SET @@SESSION.group_replication_consistency= 'BEFORE';
88 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
89 SELECT COUNT(*) AS count FROM t1;
90
91 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
92 BEGIN;
93 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
94 SELECT COUNT(*) AS count FROM t1;
95 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
96 COMMIT;
97
98 SET @@SESSION.group_replication_consistency= 'AFTER';
99 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
100 SELECT COUNT(*) AS count FROM t1;
101
102 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
103 BEGIN;
104 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
105 SELECT COUNT(*) AS count FROM t1;
106 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
107 COMMIT;
108
109 SET @@SESSION.group_replication_consistency= 'BEFORE_AND_AFTER';
110 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
111 SELECT COUNT(*) AS count FROM t1;
112
113 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
114 BEGIN;
115 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
116 SELECT COUNT(*) AS count FROM t1;
117 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
118 COMMIT;
119
120
121 --echo
122 --echo ############################################################
123 --echo # 06. Unlock table t1 on server2.
124 --echo # Member will move to ONLINE state.
125 --let $rpl_connection_name= server_2
126 --source include/rpl_connection.inc
127 UNLOCK TABLES;
128
129 --let $rpl_connection_name= server2
130 --source include/rpl_connection.inc
131 --let $group_replication_member_state= ONLINE
132 --source include/gr_wait_for_member_state.inc
133
134 SET @@SESSION.group_replication_consistency= 'BEFORE';
135 SELECT COUNT(*) AS count FROM t1;
136
137 BEGIN;
138 SELECT COUNT(*) AS count FROM t1;
139 COMMIT;
140
141 SET @@SESSION.group_replication_consistency= 'AFTER';
142 SELECT COUNT(*) AS count FROM t1;
143
144 BEGIN;
145 SELECT COUNT(*) AS count FROM t1;
146 COMMIT;
147
148 SET @@SESSION.group_replication_consistency= 'BEFORE_AND_AFTER';
149 SELECT COUNT(*) AS count FROM t1;
150
151 BEGIN;
152 SELECT COUNT(*) AS count FROM t1;
153 COMMIT;
154
155
156 --echo
157 --echo ############################################################
158 --echo # 07. Execute transactions T2 on server1.
159 --echo # T2 will make server2 move to ERROR state due to
160 --echo # duplicate key.
161 --let $rpl_connection_name= server1
162 --source include/rpl_connection.inc
163 # T2
164 INSERT INTO t2 VALUES (1);
165
166 --let $rpl_connection_name= server2
167 --source include/rpl_connection.inc
168 --let $group_replication_member_state= ERROR
169 --source include/gr_wait_for_member_state.inc
170
171 SET @@SESSION.group_replication_consistency= 'BEFORE';
172 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
173 SELECT COUNT(*) AS count FROM t1;
174
175 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
176 BEGIN;
177 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
178 SELECT COUNT(*) AS count FROM t1;
179 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
180 COMMIT;
181
182 SET @@SESSION.group_replication_consistency= 'AFTER';
183 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
184 SELECT COUNT(*) AS count FROM t1;
185
186 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
187 BEGIN;
188 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
189 SELECT COUNT(*) AS count FROM t1;
190 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
191 COMMIT;
192
193 SET @@SESSION.group_replication_consistency= 'BEFORE_AND_AFTER';
194 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
195 SELECT COUNT(*) AS count FROM t1;
196
197 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
198 BEGIN;
199 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
200 SELECT COUNT(*) AS count FROM t1;
201 --error ER_GRP_TRX_CONSISTENCY_NOT_ALLOWED
202 COMMIT;
203
204
205 --echo
206 --echo ############################################################
207 --echo # 08. Stop group on server2.
208 --echo # Member will move to OFFLINE state.
209 --source include/stop_group_replication.inc
210 --let $group_replication_member_state= OFFLINE
211 --source include/gr_wait_for_member_state.inc
212
213 SET @@SESSION.group_replication_consistency= 'BEFORE';
214 SELECT COUNT(*) AS count FROM t1;
215
216 BEGIN;
217 SELECT COUNT(*) AS count FROM t1;
218 COMMIT;
219
220 SET @@SESSION.group_replication_consistency= 'AFTER';
221 SELECT COUNT(*) AS count FROM t1;
222
223 BEGIN;
224 SELECT COUNT(*) AS count FROM t1;
225 COMMIT;
226
227 SET @@SESSION.group_replication_consistency= 'BEFORE_AND_AFTER';
228 SELECT COUNT(*) AS count FROM t1;
229
230 BEGIN;
231 SELECT COUNT(*) AS count FROM t1;
232 COMMIT;
233
234 SET @@SESSION.group_replication_consistency= DEFAULT;
235
236
237 --echo
238 --echo ############################################################
239 --echo # 09. Clean up.
240 --let $rpl_connection_name= server1
241 --source include/rpl_connection.inc
242 DROP TABLE t1;
243 DROP TABLE t2;
244
245 --let $rpl_connection_name= server2
246 --source include/rpl_connection.inc
247 DROP TABLE t1;
248 DROP TABLE t2;
249
250 --source include/group_replication_end.inc