Debian Codegraph @

mysql-test/suite/group_replication/r/gr_consistent_statement_hold_show.result

raw
1 include/group_replication.inc
2 Warnings:
3 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
4 Note #### Storing MySQL user name or password information in the connection metadata repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START REPLICA; see the 'START REPLICA Syntax' in the MySQL Manual for more information.
5 [connection server1]
6
7 ############################################################
8 # 1. Bootstrap group on server1.
9 [connection server1]
10 include/start_and_bootstrap_group_replication.inc
11 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
12 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY);
13 USE test;
14 CREATE PROCEDURE procedure1()
15 BEGIN
16 end$$
17 CREATE FUNCTION function1() RETURNS INT RETURN (SELECT COUNT(*) FROM t1);
18 CREATE EVENT event1
19 ON SCHEDULE AT CURRENT_TIMESTAMP + INTERVAL 1 SECOND
20 ON COMPLETION PRESERVE
21 DISABLE
22 DO
23 BEGIN
24 END$$
25 CREATE TRIGGER trigger1 BEFORE INSERT ON t1 FOR EACH ROW
26 BEGIN
27 INSERT INTO t2 VALUES (NEW.c1);
28 END|
29
30 ############################################################
31 # 2. Validate that a given SHOW statement goes through the
32 # `trans_begin` hook on Group Replication on server1.
33
34 # Instrument GR to hold the statement on
35 # `trans_begin` hook on server1.
36 [connection server_1]
37 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
38
39 # Execute the statement on server1.
40 [connection server1]
41 SHOW DATABASES;
42
43 # Validate that the statement went on
44 # `trans_begin` hook on server1.
45 [connection server_1]
46 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
47
48 # Release the statement from
49 # `trans_begin` hook on server1.
50 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
51
52 # Reap the statement on server1.
53 [connection server1]
54
55 # Remove GR instrumentaion to hold the statement on
56 # `trans_begin` hook on server1.
57 [connection server_1]
58 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
59
60 # Instrument GR to hold the statement on
61 # `trans_begin` hook on server1.
62 [connection server_1]
63 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
64
65 # Execute the statement on server1.
66 [connection server1]
67 SHOW TABLES;
68
69 # Validate that the statement went on
70 # `trans_begin` hook on server1.
71 [connection server_1]
72 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
73
74 # Release the statement from
75 # `trans_begin` hook on server1.
76 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
77
78 # Reap the statement on server1.
79 [connection server1]
80
81 # Remove GR instrumentaion to hold the statement on
82 # `trans_begin` hook on server1.
83 [connection server_1]
84 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
85
86 # Instrument GR to hold the statement on
87 # `trans_begin` hook on server1.
88 [connection server_1]
89 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
90
91 # Execute the statement on server1.
92 [connection server1]
93 SHOW INDEX FROM t1;
94
95 # Validate that the statement went on
96 # `trans_begin` hook on server1.
97 [connection server_1]
98 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
99
100 # Release the statement from
101 # `trans_begin` hook on server1.
102 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
103
104 # Reap the statement on server1.
105 [connection server1]
106
107 # Remove GR instrumentaion to hold the statement on
108 # `trans_begin` hook on server1.
109 [connection server_1]
110 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
111
112 # Instrument GR to hold the statement on
113 # `trans_begin` hook on server1.
114 [connection server_1]
115 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
116
117 # Execute the statement on server1.
118 [connection server1]
119 SHOW KEYS FROM t1;
120
121 # Validate that the statement went on
122 # `trans_begin` hook on server1.
123 [connection server_1]
124 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
125
126 # Release the statement from
127 # `trans_begin` hook on server1.
128 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
129
130 # Reap the statement on server1.
131 [connection server1]
132
133 # Remove GR instrumentaion to hold the statement on
134 # `trans_begin` hook on server1.
135 [connection server_1]
136 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
137
138 # Instrument GR to hold the statement on
139 # `trans_begin` hook on server1.
140 [connection server_1]
141 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
142
143 # Execute the statement on server1.
144 [connection server1]
145 SHOW GRANTS FOR CURRENT_USER();
146
147 # Validate that the statement went on
148 # `trans_begin` hook on server1.
149 [connection server_1]
150 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
151
152 # Release the statement from
153 # `trans_begin` hook on server1.
154 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
155
156 # Reap the statement on server1.
157 [connection server1]
158
159 # Remove GR instrumentaion to hold the statement on
160 # `trans_begin` hook on server1.
161 [connection server_1]
162 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
163
164 # Instrument GR to hold the statement on
165 # `trans_begin` hook on server1.
166 [connection server_1]
167 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
168
169 # Execute the statement on server1.
170 [connection server1]
171 SHOW CREATE DATABASE test;
172
173 # Validate that the statement went on
174 # `trans_begin` hook on server1.
175 [connection server_1]
176 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
177
178 # Release the statement from
179 # `trans_begin` hook on server1.
180 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
181
182 # Reap the statement on server1.
183 [connection server1]
184
185 # Remove GR instrumentaion to hold the statement on
186 # `trans_begin` hook on server1.
187 [connection server_1]
188 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
189
190 # Instrument GR to hold the statement on
191 # `trans_begin` hook on server1.
192 [connection server_1]
193 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
194
195 # Execute the statement on server1.
196 [connection server1]
197 SHOW TABLE STATUS FROM test;
198
199 # Validate that the statement went on
200 # `trans_begin` hook on server1.
201 [connection server_1]
202 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
203
204 # Release the statement from
205 # `trans_begin` hook on server1.
206 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
207
208 # Reap the statement on server1.
209 [connection server1]
210
211 # Remove GR instrumentaion to hold the statement on
212 # `trans_begin` hook on server1.
213 [connection server_1]
214 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
215
216 # Instrument GR to hold the statement on
217 # `trans_begin` hook on server1.
218 [connection server_1]
219 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
220
221 # Execute the statement on server1.
222 [connection server1]
223 SHOW TRIGGERS FROM test;
224
225 # Validate that the statement went on
226 # `trans_begin` hook on server1.
227 [connection server_1]
228 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
229
230 # Release the statement from
231 # `trans_begin` hook on server1.
232 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
233
234 # Reap the statement on server1.
235 [connection server1]
236
237 # Remove GR instrumentaion to hold the statement on
238 # `trans_begin` hook on server1.
239 [connection server_1]
240 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
241
242 # Instrument GR to hold the statement on
243 # `trans_begin` hook on server1.
244 [connection server_1]
245 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
246
247 # Execute the statement on server1.
248 [connection server1]
249 SHOW CREATE PROCEDURE test.procedure1;
250
251 # Validate that the statement went on
252 # `trans_begin` hook on server1.
253 [connection server_1]
254 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
255
256 # Release the statement from
257 # `trans_begin` hook on server1.
258 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
259
260 # Reap the statement on server1.
261 [connection server1]
262
263 # Remove GR instrumentaion to hold the statement on
264 # `trans_begin` hook on server1.
265 [connection server_1]
266 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
267
268 # Instrument GR to hold the statement on
269 # `trans_begin` hook on server1.
270 [connection server_1]
271 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
272
273 # Execute the statement on server1.
274 [connection server1]
275 SHOW CREATE FUNCTION test.function1;
276
277 # Validate that the statement went on
278 # `trans_begin` hook on server1.
279 [connection server_1]
280 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
281
282 # Release the statement from
283 # `trans_begin` hook on server1.
284 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
285
286 # Reap the statement on server1.
287 [connection server1]
288
289 # Remove GR instrumentaion to hold the statement on
290 # `trans_begin` hook on server1.
291 [connection server_1]
292 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
293
294 # Instrument GR to hold the statement on
295 # `trans_begin` hook on server1.
296 [connection server_1]
297 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
298
299 # Execute the statement on server1.
300 [connection server1]
301 SHOW PROCEDURE CODE test.procedure1;
302
303 # Validate that the statement went on
304 # `trans_begin` hook on server1.
305 [connection server_1]
306 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
307
308 # Release the statement from
309 # `trans_begin` hook on server1.
310 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
311
312 # Reap the statement on server1.
313 [connection server1]
314
315 # Remove GR instrumentaion to hold the statement on
316 # `trans_begin` hook on server1.
317 [connection server_1]
318 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
319
320 # Instrument GR to hold the statement on
321 # `trans_begin` hook on server1.
322 [connection server_1]
323 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
324
325 # Execute the statement on server1.
326 [connection server1]
327 SHOW FUNCTION CODE test.function1;
328
329 # Validate that the statement went on
330 # `trans_begin` hook on server1.
331 [connection server_1]
332 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
333
334 # Release the statement from
335 # `trans_begin` hook on server1.
336 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
337
338 # Reap the statement on server1.
339 [connection server1]
340
341 # Remove GR instrumentaion to hold the statement on
342 # `trans_begin` hook on server1.
343 [connection server_1]
344 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
345
346 # Instrument GR to hold the statement on
347 # `trans_begin` hook on server1.
348 [connection server_1]
349 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
350
351 # Execute the statement on server1.
352 [connection server1]
353 SHOW CREATE EVENT test.event1;
354
355 # Validate that the statement went on
356 # `trans_begin` hook on server1.
357 [connection server_1]
358 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
359
360 # Release the statement from
361 # `trans_begin` hook on server1.
362 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
363
364 # Reap the statement on server1.
365 [connection server1]
366
367 # Remove GR instrumentaion to hold the statement on
368 # `trans_begin` hook on server1.
369 [connection server_1]
370 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
371
372 # Instrument GR to hold the statement on
373 # `trans_begin` hook on server1.
374 [connection server_1]
375 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
376
377 # Execute the statement on server1.
378 [connection server1]
379 SHOW CREATE TRIGGER test.trigger1;
380
381 # Validate that the statement went on
382 # `trans_begin` hook on server1.
383 [connection server_1]
384 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
385
386 # Release the statement from
387 # `trans_begin` hook on server1.
388 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
389
390 # Reap the statement on server1.
391 [connection server1]
392
393 # Remove GR instrumentaion to hold the statement on
394 # `trans_begin` hook on server1.
395 [connection server_1]
396 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
397
398 # Instrument GR to hold the statement on
399 # `trans_begin` hook on server1.
400 [connection server_1]
401 # Adding debug point 'group_replication_wait_on_observer_trans' to @@GLOBAL.debug
402
403 # Execute the statement on server1.
404 [connection server1]
405 SHOW CREATE USER CURRENT_USER();
406
407 # Validate that the statement went on
408 # `trans_begin` hook on server1.
409 [connection server_1]
410 SET DEBUG_SYNC= "now WAIT_FOR signal.group_replication_wait_on_observer_trans_waiting";
411
412 # Release the statement from
413 # `trans_begin` hook on server1.
414 SET DEBUG_SYNC= 'now SIGNAL signal.group_replication_wait_on_observer_trans_continue';
415
416 # Reap the statement on server1.
417 [connection server1]
418
419 # Remove GR instrumentaion to hold the statement on
420 # `trans_begin` hook on server1.
421 [connection server_1]
422 # Removing debug point 'group_replication_wait_on_observer_trans' from @@GLOBAL.debug
423
424 ############################################################
425 # 3. Clean up.
426 [connection server1]
427 DROP PROCEDURE procedure1;
428 DROP FUNCTION function1;
429 DROP EVENT event1;
430 DROP TRIGGER trigger1;
431 DROP TABLE t2;
432 DROP TABLE t1;
433 include/group_replication_end.inc