Debian Codegraph @

mysql-test/suite/group_replication/r/gr_primary_mode_group_operations_12.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 # 1. Use debug point to decrease minor version
8 set session sql_log_bin=0;
9 call mtr.add_suppression("Error while executing a group configuration operation: The group has a member with a version that does not support group coordinated operations.");
10 set session sql_log_bin=1;
11 SET @@GLOBAL.DEBUG= '+d,group_replication_legacy_election_version';
12
13 # 2. Start server and bootstrap group
14 include/start_and_bootstrap_group_replication.inc
15
16 # 3. Join server2 to group
17 [connection server2]
18 set session sql_log_bin=0;
19 call mtr.add_suppression("The function 'group_replication_switch_to_single_primary_mode' failed. The group has a member with a version that does not support group coordinated operations.");
20 call mtr.add_suppression("Member version is read compatible with the group.");
21 set session sql_log_bin=1;
22 include/start_group_replication.inc
23
24 # 4. Executing switch to single primary mode will fail due to the version of
25 # one of the members
26 SELECT group_replication_switch_to_single_primary_mode();
27 ERROR HY000: The function 'group_replication_switch_to_single_primary_mode' failed. The group has a member with a version that does not support group coordinated operations.
28 SELECT group_replication_switch_to_single_primary_mode("MEMBER2_UUID");
29 ERROR HY000: The function 'group_replication_switch_to_single_primary_mode' failed. The group has a member with a version that does not support group coordinated operations.
30
31 # 5. Cleanup
32 [connection server1]
33 include/stop_group_replication.inc
34 SET @@GLOBAL.DEBUG= '-d,group_replication_legacy_election_version';
35 SET @@GLOBAL.DEBUG= '+d,group_replication_compatibility_restore_version';
36 include/start_group_replication.inc
37 SET @@GLOBAL.DEBUG= '-d,group_replication_compatibility_restore_version';
38 include/group_replication_end.inc