Debian Codegraph @

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

raw
1 #
2 # Test case to verify querying performance_schema.replication_group_members
3 # table while member is rejoining does not create issue.
4 #
5 # Test:
6 # 0. This test requires only 1 server M1.
7 # 1. Start group replication on member1.
8 # 2. Add gr_rejoining_offline_member_proc procedure to query
9 # replication_group_members multiple times.
10 # 3. Restart group replication on member1.
11 # 4. Query performance_schema.replication_group_members table
12 # multiple times while member is rejoining to test the failure.
13 # 5. Verify member1 is ONLINE.
14 # 6. Cleanup
15
16
17 --source include/big_test.inc
18 --source include/have_group_replication_plugin.inc
19 --let $rpl_skip_group_replication_start= 1
20 --source include/group_replication.inc
21
22 --echo
23 --echo # 1. Start group replication on member1.
24
25 --source include/start_and_bootstrap_group_replication.inc
26
27 --echo
28 --echo # 2. Add gr_rejoining_offline_member_proc procedure to query
29 --echo # replication_group_members multiple times and stop GR on server1.
30
31 --let $rpl_connection_name= server1
32 --source include/rpl_connection.inc
33
34 delimiter |;
35 CREATE PROCEDURE test.gr_rejoining_offline_member_proc(mx INT)
36 BEGIN
37 SET @x = 0;
38 REPEAT
39 SELECT COUNT(*) FROM performance_schema.replication_group_members;
40 SET @x = @x + 1;
41 UNTIL @x > mx END REPEAT;
42 END |
43 delimiter ;|
44
45 --source include/stop_group_replication.inc
46
47 --echo
48 --echo # 3. Restart group replication on member1.
49
50 SET GLOBAL group_replication_bootstrap_group=1;
51 --send START GROUP_REPLICATION
52
53
54 --echo
55 --echo # 4. Query performance_schema.replication_group_members table
56 --echo # multiple times while member is rejoining to test the failure.
57 --let $rpl_connection_name= server_1
58 --source include/rpl_connection.inc
59
60 --disable_result_log
61 --disable_query_log
62 call gr_rejoining_offline_member_proc(100);
63 --enable_query_log
64 --enable_result_log
65
66
67 --echo
68 --echo # 5. Verify member1 is ONLINE.
69
70 --let $rpl_connection_name= server1
71 --source include/rpl_connection.inc
72 --reap
73
74 --let $group_replication_member_state= ONLINE
75 --source include/gr_wait_for_member_state.inc
76
77 --echo
78 --echo # 6. Cleanup
79
80 DROP PROCEDURE gr_rejoining_offline_member_proc;
81 --source include/group_replication_end.inc