Debian Codegraph @

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

raw
1 #
2 # 1. Create a group with 3 members
3 # Extract each server uuid
4 # Create a table on it.
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 [connection server2]
13 [connection server3]
14 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
15 include/rpl_sync.inc
16 #
17 # 2. Crash server 2 and server 3
18 # Check they are marked as unreachable
19 #
20 [connection server2]
21 [connection server3]
22 [connection server1]
23 include/gr_wait_for_member_state.inc
24 include/gr_wait_for_member_state.inc
25 #
26 # 3. Execute a query that will block
27 #
28 INSERT INTO t1 VALUES (2);
29 #
30 # 4. Stop Group Replication on server 1
31 # The pending query should die
32 #
33 [connection server_1]
34 include/stop_group_replication.inc
35 [connection server1]
36 ERROR HY000: Error on observer while running replication hook 'before_commit'.
37 #
38 # 5. Clean up.
39 #
40 [connection server1]
41 DROP TABLE t1;
42 set session sql_log_bin=0;
43 call mtr.add_suppression("The member lost contact with a majority of the members in the group. Until the network is restored.*");
44 call mtr.add_suppression("Due to a plugin error, some transactions were unable to be certified and will now rollback.");
45 call mtr.add_suppression("Timeout while waiting for the group communication engine to exit!");
46 call mtr.add_suppression("The member has failed to gracefully leave the group.");
47 call mtr.add_suppression("read failed");
48 call mtr.add_suppression("Error while waiting for conflict detection procedure to finish on session .*");
49 call mtr.add_suppression("Run function 'before_commit' in plugin 'group_replication' failed");
50 set session sql_log_bin=1;
51 [connection server_2]
52 include/rpl_reconnect.inc
53 DROP TABLE t1;
54 [connection server_3]
55 include/rpl_reconnect.inc
56 DROP TABLE t1;
57 include/group_replication_end.inc