Debian Codegraph @

mysql-test/suite/group_replication/r/gr_primary_mode_group_operations_24.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. Set an debug point on server to block group action after
8 # configuration is accepted
9 SET @@GLOBAL.DEBUG= '+d,group_replication_block_group_action';
10 [connection server2]
11 [connection server3]
12
13 # 2. Execute switch to single primary mode
14 [connection server1]
15 SELECT group_replication_switch_to_single_primary_mode("MEMBER2_UUID");
16
17 # 3. Kill server that is executing action
18 [connection server_1]
19 # Kill and restart:--group-replication-start-on-boot=0 --group-replication-group-name=GROUP_REPLICATION_GROUP_NAME --group_replication_local_address=GROUP_REPLICATION_LOCAL_ADDRESS --group_replication_group_seeds=GROUP_REPLICATION_GROUP_SEEDS --group_replication_single_primary_mode=TRUE --group_replication_enforce_update_everywhere_checks=FALSE
20 [connection server1]
21 ERROR HY000: Lost connection to MySQL server during query
22 [connection server_1]
23 include/rpl_reconnect.inc
24
25 # 4. Confirm other members executed the action
26 [connection server2]
27 include/rpl_gr_wait_for_number_of_members.inc
28 include/gr_assert_primary_member.inc
29 [connection server3]
30 include/gr_assert_secondary_member.inc
31
32 # 5. Clean up
33 [connection server1]
34 include/group_replication_end.inc