Debian Codegraph @

mysql-test/suite/group_replication/r/gr_primary_mode_group_operations_44_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. Server1 start, bootstrap the group
8 include/start_and_bootstrap_group_replication.inc
9
10 # 2. Start server2 and server3
11 [connection server2]
12 set session sql_log_bin=0;
13 call mtr.add_suppression("There was an issue on the primary election process: Could not wait for the execution of local transactions. The member will now leave the group.");
14 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
15 call mtr.add_suppression("The plugin encountered a critical error and will abort: Fatal error during the primary election process:*");
16 set session sql_log_bin=1;
17 include/start_group_replication.inc
18 [connection server3]
19 include/start_group_replication.inc
20
21 # 3. Fake a stopped applier on server2
22 [connection server2]
23 SET @@GLOBAL.DEBUG= '+d,group_replication_wait_for_gtid_execution_force_error';
24
25 # 4. Set server2 weight higher to be new primary server
26 SET GLOBAL group_replication_member_weight= 90;
27 SET @@GLOBAL.group_replication_exit_state_action = ABORT_SERVER;
28
29 # 5. Stop primary member that will force election from another member
30 [connection server1]
31 include/stop_group_replication.inc
32
33 # 6. Server2 will fail (applier thread stopped) and abort
34 [connection server3]
35 include/rpl_gr_wait_for_number_of_members.inc
36 # 7. Server3 is the new primary
37 include/gr_assert_primary_member.inc
38
39 # 8. Wait for server 2 to disconnect/abort and restart
40 [connection server2]
41 include/rpl_reconnect.inc
42 SET @@GLOBAL.DEBUG= '-d,group_replication_wait_for_gtid_execution_force_error';
43
44 # 9. Cleanup
45 include/group_replication_end.inc