Debian Codegraph @

mysql-test/suite/group_replication/r/gr_primary_mode_group_operations_37.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 and bootstrap the group
8 include/start_and_bootstrap_group_replication.inc
9
10 # 2. Start server2
11 [connection server2]
12 include/start_group_replication.inc
13
14 # 3. Start server3 and fake a stopped applier
15 [connection server3]
16 set session sql_log_bin=0;
17 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.");
18 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
19 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. The member will now leave the group.");
20 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
21 set session sql_log_bin=1;
22 include/start_group_replication.inc
23 SET @@GLOBAL.DEBUG= '+d,group_replication_wait_for_gtid_execution_force_error';
24
25 # 4. Execute action to switch to multi primary
26 [connection server1]
27 SELECT group_replication_switch_to_multi_primary_mode();
28
29 # 5. Server3 will leave group
30 [connection server2]
31 include/rpl_gr_wait_for_number_of_members.inc
32
33 # 6. Server3 changed to ERROR state
34 [connection server3]
35 include/gr_wait_for_member_state.inc
36 SET @@GLOBAL.DEBUG= '-d,group_replication_wait_for_gtid_execution_force_error';
37
38 # 7. Check that Single primary mode is false on the stuck member and the
39 # update everywhere checks are true
40 include/assert.inc [group_replication_enforce_update_everywhere_checks is ON]
41 include/assert.inc [The single primary mode should be 0 here.]
42
43 # 8. Reap action executed
44 [connection server1]
45 group_replication_switch_to_multi_primary_mode()
46 Mode switched to multi-primary successfully.
47
48 # 9. Cleanup
49 [connection server3]
50 include/stop_group_replication.inc
51 include/gr_wait_for_member_state.inc
52 include/start_group_replication.inc
53 include/group_replication_end.inc