Debian Codegraph @

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

raw
1 include/group_replication.inc [rpl_server_count=3]
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 # 0) The test requires three servers.
9 ####
10
11 [connection server1]
12 SET sql_log_bin = 0;
13 call mtr.add_suppression("Member was expelled from the group due to network failures, changing member status to ERROR.");
14 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
15 call mtr.add_suppression("\\[GCS\\] The member has left the group but the new view will not be installed, probably because it has not been delivered yet.");
16 call mtr.add_suppression("\\[GCS\\] read failed");
17 call mtr.add_suppression("Started auto-rejoin procedure attempt*");
18 call mtr.add_suppression("Auto-rejoin procedure attempt*");
19 SET sql_log_bin = 1;
20 include/gr_autorejoin_monitoring.inc
21
22 ####
23 # 1) Provoke a member expel.
24 ####
25
26 SET GLOBAL group_replication_autorejoin_tries = 2016;
27 SET @debug_saved = @@GLOBAL.DEBUG;
28 SET GLOBAL group_replication_local_address = "128.0.0.1:3306";
29 include/gr_expel_member_from_group.inc
30 SET SESSION sql_log_bin = 0;
31 CREATE TABLE pid_table(pid_no INT PRIMARY KEY);
32 LOAD DATA LOCAL INFILE 'pid_file' INTO TABLE pid_table;
33 DROP TABLE pid_table;
34 SET SESSION sql_log_bin = 1;
35
36 ####
37 # 2) Stop the plugin while the auto-rejoin is running on the expelled
38 # member.
39 ####
40
41 include/stop_group_replication.inc
42
43 ####
44 # 3) Verify that the auto-rejoin process should stop immediately.
45 ####
46
47
48 ####
49 # 4) Verify that the expelled member left the group.
50 ####
51
52 [connection server2]
53 include/rpl_gr_wait_for_number_of_members.inc
54 include/assert.inc [Member 1 should not be in the group]
55 [connection server3]
56 include/rpl_gr_wait_for_number_of_members.inc
57 include/assert.inc [Member 1 should not be in the group]
58
59 ####
60 # 5) Set the group_replication_exit_state_action on that member to
61 # ABORT_SERVER and restart the plugin.
62 ####
63
64 [connection server1]
65 SET @saved_exit_state_action = @@GLOBAL.group_replication_exit_state_action;
66 SET @@GLOBAL.group_replication_exit_state_action = ABORT_SERVER;
67 SET GLOBAL group_replication_local_address = "LOCAL_ADDRESS_SERVER";
68 include/start_group_replication.inc
69
70 ####
71 # 6) Expel that member again.
72 ####
73
74 SET GLOBAL group_replication_local_address = "128.0.0.1:3306";
75 SET @@GLOBAL.DEBUG='+d,group_replication_stop_before_rejoin_loop';
76 SET @@GLOBAL.DEBUG='+d,group_replication_long_retry';
77 SET @@GLOBAL.DEBUG='-d,group_replication_stop_before_rejoin';
78 include/gr_expel_member_from_group.inc
79 SET SESSION sql_log_bin = 0;
80 CREATE TABLE pid_table(pid_no INT PRIMARY KEY);
81 LOAD DATA LOCAL INFILE 'pid_file' INTO TABLE pid_table;
82 DROP TABLE pid_table;
83 SET SESSION sql_log_bin = 1;
84
85 ####
86 # 7) Stop the plugin while the auto-rejoin is running on that member.
87 ####
88
89 SET DEBUG_SYNC = "now WAIT_FOR signal.autorejoin_entering_loop";
90 SET DEBUG_SYNC = "now SIGNAL signal.autorejoin_enter_loop";
91 include/stop_group_replication.inc
92
93 ####
94 # 8) Verify that it didn't abort and that it left the group.
95 ####
96
97 include/gr_wait_for_member_state.inc
98 SET GLOBAL group_replication_local_address = "LOCAL_ADDRESS_SERVER";
99 include/start_group_replication.inc
100
101 ####
102 # 9) Cleanup.
103 ####
104
105 SET @@GLOBAL.DEBUG = @debug_saved;
106 SET GLOBAL group_replication_autorejoin_tries = default;
107 SET GLOBAL group_replication_exit_state_action = @saved_exit_state_action;
108 include/gr_end_autorejoin_monitoring.inc
109 include/group_replication_end.inc