Debian Codegraph @

mysql-test/suite/group_replication/r/gr_recovery_completion_mode_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 # Create t1 and t2 on both servers
8 # Start group replication on server 1 and insert data on t1
9 #
10 server1
11 SET SESSION sql_log_bin=0;
12 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
13 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
14 SET SESSION sql_log_bin=1;
15 include/start_and_bootstrap_group_replication.inc
16 INSERT INTO t1 VALUES (1);
17 server2
18 SET SESSION sql_log_bin=0;
19 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
20 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
21 call mtr.add_suppression("It is not possible to ensure the execution of group*");
22 call mtr.add_suppression("Unable to ensure the execution of group*");
23 call mtr.add_suppression("Fatal error during the incremental recovery process of Group Replication.*");
24 call mtr.add_suppression("The member is leaving a group without being on one");
25 call mtr.add_suppression("The member is already leaving or joining a group.");
26 call mtr.add_suppression("Error leaving the group");
27 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
28 call mtr.add_suppression("Can't evaluate the group replication applier execution status. Group replication recovery will shutdown to avoid data corruption.");
29 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
30 SET SESSION sql_log_bin=1;
31 #
32 # Change recovery policy on server 2 to wait for transaction execution.
33 #
34 server2
35 SET @configured_rec_policy= @@GLOBAL.group_replication_recovery_complete_at;
36 SET GLOBAL group_replication_recovery_complete_at= "transactions_applied";
37 Warnings:
38 Warning 1681 'group_replication_recovery_complete_at' is deprecated and will be removed in a future release.
39 #
40 # Lock table t1 on server 2
41 # Table t1: Blocks first phase of recovery
42 #
43 server_2 (server2)
44 LOCK TABLE t1 READ;
45 #
46 # Start group replication on server 2 and check it is stuck on recovery
47 #
48 server2
49 include/start_group_replication.inc
50 #
51 # Insert some transaction on server 1 that will be cached on server 2
52 #
53 server1
54 INSERT INTO t2 VALUES (1);
55 #
56 # Wait for the transactions to be cached on server 2
57 #
58 server2
59 #
60 # Fake a stopped applier thread during recovery.
61 #
62 server2
63 SET @@GLOBAL.DEBUG= '+d,group_replication_wait_for_gtid_execution_force_error';
64 #
65 # UnLock table t1: First phase of recovery can carry on.
66 # Member 2 will error out as it can't wait for data execution
67 #
68 server_2 (server2)
69 UNLOCK TABLES;
70 include/gr_wait_for_member_state.inc
71 SET @@GLOBAL.DEBUG= '-d,group_replication_wait_for_gtid_execution_force_error';
72 #
73 # Test cleanup
74 #
75 server1
76 include/rpl_gr_wait_for_number_of_members.inc
77 server2
78 include/stop_group_replication.inc
79 include/start_group_replication.inc
80 DROP TABLE t1;
81 DROP TABLE t2;
82 SET GLOBAL group_replication_recovery_complete_at= @configured_rec_policy;
83 Warnings:
84 Warning 1681 'group_replication_recovery_complete_at' is deprecated and will be removed in a future release.
85 include/group_replication_end.inc