Debian Codegraph @

mysql-test/suite/group_replication/r/gr_single_primary_majority_loss_2.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 [connection server1]
7 include/start_and_bootstrap_group_replication.inc
8 [connection server2]
9 include/start_group_replication.inc
10 [connection server3]
11 include/start_group_replication.inc
12 # Crash the two servers(1 primary + 1 secondary) out of 3 to cause a majority loss
13 [connection server1]
14 include/gr_wait_primary_member_uuid.inc
15 # Kill the server
16 [connection server3]
17 # Kill and restart
18 [connection server1]
19 # restart
20 include/rpl_reconnect.inc
21 include/rpl_reconnect.inc
22 [connection server1]
23 SET @@global.group_replication_group_seeds="GROUP_SEEDS_SERVER1";
24 SET @@global.group_replication_local_address="LOCAL_ADDRESS_SERVER1";
25 SET @@global.group_replication_group_name="GROUP_REPLICATION_GROUP_NAME";
26 SET @@global.group_replication_enforce_update_everywhere_checks=OFF;
27 SET @@global.group_replication_single_primary_mode=ON;
28 [connection server_3]
29 SET @@global.group_replication_group_seeds="GROUP_SEEDS_SERVER3";
30 SET @@global.group_replication_local_address="LOCAL_ADDRESS_SERVER3";
31 SET @@global.group_replication_group_name="GROUP_REPLICATION_GROUP_NAME";
32 SET @@global.group_replication_enforce_update_everywhere_checks=OFF;
33 SET @@global.group_replication_single_primary_mode=ON;
34 [connection server2]
35 # Wait for the member state for server1 to be unreachable
36 include/gr_wait_for_member_state.inc
37 # Wait for the member state for server3 to be unreachable
38 include/gr_wait_for_member_state.inc
39 # Connect to primary and unblock the group.
40 SET GLOBAL group_replication_force_members= "GROUP_REPLICATION_LOCAL_ADDR";
41 include/gr_wait_primary_member_uuid.inc
42 CREATE TABLE test.t1 ( a int primary key);
43 INSERT INTO test.t1 VALUES (1);
44 [connection server1]
45 include/start_group_replication.inc
46 [connection server3]
47 include/start_group_replication.inc
48 include/gr_wait_primary_member_uuid.inc
49 [connection server2]
50 DROP TABLE test.t1;
51 set session sql_log_bin=0;
52 call mtr.add_suppression("The member lost contact with a majority of the members in the group. Until the network is restored.*");
53 call mtr.add_suppression("The member resumed contact with a majority of the members in the group.*");
54 set session sql_log_bin=1;
55 include/group_replication_end.inc