Debian Codegraph @

mysql-test/suite/group_replication/r/gr_primary_mode_group_operations_43_1.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 # 1. Start the servers, server 2 is configured to abort
8 include/start_and_bootstrap_group_replication.inc
9 [connection server2]
10 set session sql_log_bin=0;
11 call mtr.add_suppression("A configuration change was killed in this member. The member will now leave the group as its configuration may have diverged.");
12 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
13 call mtr.add_suppression("The plugin encountered a critical error and will abort: Fatal error during a Group Replication configuration change. *");
14 call mtr.add_suppression("Error while executing a group configuration operation: This operation ended in error as it was not possible to wait for the execution of the plugin queued transactions");
15 set session sql_log_bin=1;
16 SET @@GLOBAL.group_replication_exit_state_action = ABORT_SERVER;
17 include/start_group_replication.inc
18 [connection server3]
19 include/start_group_replication.inc
20
21 # 2. Fake a stopped applier in server2
22 [connection server2]
23 SET @@GLOBAL.DEBUG= '+d,group_replication_wait_for_gtid_execution_force_error';
24
25 # 3. Change to multi primary mode
26 [connection server1]
27 SELECT group_replication_switch_to_multi_primary_mode();
28 group_replication_switch_to_multi_primary_mode()
29 Mode switched to multi-primary successfully.
30
31 # 4. Server2 shall abort and 'exit' the group
32 [connection server1]
33 include/rpl_gr_wait_for_number_of_members.inc
34
35 # 5. Wait for server 2 to disconnect/abort and restart
36 [connection server2]
37 include/rpl_reconnect.inc
38 SET @@GLOBAL.DEBUG= '-d,group_replication_wait_for_gtid_execution_force_error';
39
40 # 6. Cleanup
41 include/group_replication_end.inc