Debian Codegraph @

mysql-test/suite/group_replication/r/gr_suspect_member_resumes_after_crash.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 # 1. Set group_replication_member_expel_timeout to
9 # 3600 seconds.
10 [connection server1]
11 SET GLOBAL group_replication_member_expel_timeout = 3600;
12 set session sql_log_bin=0;
13 call mtr.add_suppression("Old incarnation found while trying to add node*.*");
14 set session sql_log_bin=1;
15 [connection server2]
16 SET GLOBAL group_replication_member_expel_timeout = 3600;
17 [connection server3]
18 SET GLOBAL group_replication_member_expel_timeout = 3600;
19 set session sql_log_bin=0;
20 call mtr.add_suppression("read failed");
21 call mtr.add_suppression("The member was unable to join the group. Local port: *.*");
22 call mtr.add_suppression("Timeout on wait for view after joining group");
23 call mtr.add_suppression("Error connecting to all peers. Member join failed. Local port: *.*");
24 call mtr.add_suppression("Unable to start MySQL Network Provider*.*");
25 call mtr.add_suppression("Timeout while waiting for the group communication engine to be ready*.*");
26 call mtr.add_suppression("The group communication engine is not ready for the member to join*.*");
27 set session sql_log_bin=1;
28
29 ############################################################
30 # 2. Create a table and insert some data. Check that
31 # it is replicated to all servers.
32 [connection server1]
33 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
34 INSERT INTO t1 VALUES (1);
35 include/rpl_sync.inc
36
37 ############################################################
38 # 3. Crash server 3 and it will restart.
39 [connection server3]
40 # Kill and restart:--group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_group_name=GROUP_REPLICATION_GROUP_NAME
41 #
42 # Restarting server 3
43 include/rpl_reconnect.inc
44
45 ############################################################
46 # 4. Check that all members are still in the group on
47 # servers 1 and 2, which should both be ONLINE.
48 # Server 3 should still be in the group but UNREACHABLE.
49 [connection server1]
50 [connection server2]
51
52 ############################################################
53 # 5. Insert data into table t1 on server 2 and check that
54 # it is replicated to server 1.
55 INSERT INTO t1 VALUES (2);
56 [connection server1]
57
58 ############################################################
59 # 6. Restart GR on server 3 and it should fail since its
60 # suspicion still hasn't timed out on other members.
61 [connection server3]
62 SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
63 SET GLOBAL group_replication_group_seeds= "SERVER1_LOCAL_ADDRESS";
64 START GROUP_REPLICATION;
65 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
66
67 ############################################################
68 # 7. Wait until server 3 is expelled from the group.
69 [connection server1]
70 SET GLOBAL group_replication_member_expel_timeout = DEFAULT;
71 [connection server2]
72 SET GLOBAL group_replication_member_expel_timeout = DEFAULT;
73 [connection server1]
74 [connection server2]
75
76 ############################################################
77 # 8. Server 3 was expelled! Start GR on server 3.
78 [connection server3]
79 include/start_group_replication.inc
80 SET GLOBAL group_replication_member_expel_timeout = DEFAULT;
81 [connection server1]
82 [connection server2]
83 [connection server3]
84
85 ############################################################
86 # 9. Check that server 3 retrieves the data inserted while
87 # it was suspended. Then, use it to insert new data into
88 # table t1 which should be replicated to servers 1 and 2.
89 [connection server3]
90 INSERT INTO t1 VALUES (3);
91 include/rpl_sync.inc
92 include/diff_tables.inc [server1:t1, server2:t1, server3:t1]
93
94 ############################################################
95 # 10. Clean up.
96 DROP TABLE t1;
97 include/group_replication_end.inc