Debian Codegraph @

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

raw
1
2 #########################################################################
3 # 0) Setup group of 3 members (M1, M2 and M3).
4 #########################################################################
5
6 include/group_replication.inc [rpl_server_count=3]
7 Warnings:
8 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
9 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.
10 [connection server1]
11 [connection server1]
12 SET SESSION sql_log_bin = 0;
13 CREATE TABLE pid_table(pid_no INT PRIMARY KEY);
14 LOAD DATA LOCAL INFILE 'pid_file' INTO TABLE pid_table;
15 DROP TABLE pid_table;
16 call mtr.add_suppression("Member was expelled from the group due to network failures, changing member status to ERROR.");
17 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
18 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
19 call mtr.add_suppression("The plugin encountered a critical error and will abort: Member was expelled from the group due to network failures.");
20 call mtr.add_suppression("Error, maximum number of retries exceeded when waiting for the internal server session state to be operating");
21 call mtr.add_suppression("Failed to establish an internal server connection to execute plugin operations");
22 call mtr.add_suppression("Unable to confirm whether the server has left the group or not.*");
23 call mtr.add_suppression(".* read failed");
24 call mtr.add_suppression("\\[GCS\\] Unable to resolve peer address.");
25 SET SESSION sql_log_bin = 1;
26
27 #########################################################################
28 # 1) Force expel of member 1.
29 #########################################################################
30
31 [connection server2]
32 include/rpl_gr_wait_for_number_of_members.inc
33 [connection server3]
34 include/rpl_gr_wait_for_number_of_members.inc
35
36 #########################################################################
37 # 1.1) Verify that member 1 went to super_read_only mode.
38 #########################################################################
39
40 [connection server1]
41 include/gr_wait_for_member_state.inc
42 [connection server1]
43 include/assert.inc [super_read_only should be enabled]
44 include/stop_group_replication.inc
45
46 #########################################################################
47 # 2) Set exit state action to ABORT_SERVER on member 1.
48 #########################################################################
49
50 SET @@GLOBAL.group_replication_exit_state_action = ABORT_SERVER;
51 include/start_group_replication.inc
52 include/rpl_gr_wait_for_number_of_members.inc
53
54 #########################################################################
55 # 3) Force expel again of member 1.
56 #########################################################################
57
58 [connection server2]
59 include/rpl_gr_wait_for_number_of_members.inc
60 [connection server3]
61 include/rpl_gr_wait_for_number_of_members.inc
62
63 #########################################################################
64 # 3.1) Wait until server is aborted.
65 #########################################################################
66
67 [connection server1]
68
69 #########################################################################
70 # 4) Relaunch member 1.
71 #########################################################################
72
73 include/rpl_reconnect.inc
74 [connection server1]
75 SET @@global.group_replication_group_seeds="GROUP_SEEDS_SERVER1";
76 SET @@global.group_replication_local_address="LOCAL_ADDRESS_SERVER1";
77 include/start_group_replication.inc
78 include/rpl_gr_wait_for_number_of_members.inc
79
80 #########################################################################
81 # 5) Cleanup.
82 #########################################################################
83
84 include/group_replication_end.inc