Debian Codegraph @

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

raw
1 include/group_replication.inc
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 # 1. Create a table on server 1 and replicate
8 #
9 [connection server1]
10 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
11 include/rpl_sync.inc
12 #
13 # 2. Insert a row on server 2 with log to the binlog disabled
14 #
15 [connection server2]
16 SET SESSION sql_log_bin= 0;
17 INSERT INTO t1 VALUES (1);
18 SET SESSION sql_log_bin= 1;
19 #
20 # 3. Write the same query in server 1
21 # On server 2 the duplicated key will make the applier fail.
22 # Server 2 will leave
23 #
24 [connection server1]
25 INSERT INTO t1 VALUES (1);
26 [connection server2]
27 # Expect ERROR state.
28 include/gr_wait_for_member_state.inc
29 #
30 # 4. Stop server 2 and start it again. One of three things can happen:
31 # A. The applier fails after the join and the member leaves the group
32 # but the START GROUP_REPLICATION command does not fail
33 # B. The applier fails after initialization and sets the state to ERROR,
34 # making the group join fail that makes the START GROUP_REPLICATION
35 # command fail with a generic ER_GROUP_REPLICATION_CONFIGURATION.
36 # C. The applier fails and its initialization processes catches the error.
37 # During the start, it is known that the applier failed so the START
38 # GROUP_REPLICATION fails with: ER_GROUP_REPLICATION_APPLIER_INIT_ERROR
39 #
40 include/stop_group_replication.inc
41 START GROUP_REPLICATION;
42 #
43 # 5. Verify that member is offline after stop
44 #
45 include/stop_group_replication.inc
46 include/gr_wait_for_member_state.inc
47 #
48 # 6. Clean up
49 #
50 SET GLOBAL read_only= 0;
51 DROP TABLE t1;
52 SET SESSION sql_log_bin= 0;
53 call mtr.add_suppression("Unable to initialize the Group Replication applier module.");
54 call mtr.add_suppression("The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group.");
55 call mtr.add_suppression("Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.");
56 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
57 call mtr.add_suppression("Unable to confirm whether the server has left the group or not. Check *.*");
58 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
59 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': Could not execute Write_rows event on table");
60 call mtr.add_suppression("Error writing relay log configuration.");
61 call mtr.add_suppression("There was a previous plugin error while the member joined the group. The member will now exit the group.");
62 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': Worker [0-9] failed executing transaction*");
63 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': ... The replica coordinator and worker threads are stopped,*");
64 call mtr.add_suppression("Can't evaluate the group replication applier execution status. Group replication recovery will shutdown to avoid data corruption.");
65 call mtr.add_suppression("Fatal error during the Recovery process of Group Replication. The server will leave the group.");
66 call mtr.add_suppression("It was not possible to identify the group replication applier thread");
67 call mtr.add_suppression("Error on group communication engine start");
68 call mtr.add_suppression("Error reading relay log event for channel 'group_replication_applier': Error purging processed logs");
69 SET SESSION sql_log_bin= 1;
70 [connection server1]
71 include/stop_group_replication.inc
72 DROP TABLE t1;
73 include/group_replication_end.inc