Debian Codegraph @

mysql-test/suite/group_replication/r/gr_compatibility_rules_8_0_35_sp.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 ############################################################
8 # 1. Bootstrap the group with a server that is one patch version
9 # higher than the current version (8.0.35 or higher).
10 [connection server1]
11 SET SESSION sql_log_bin= 0;
12 call mtr.add_suppression("Error while executing a group configuration operation: Error processing configuration start message: The appointed primary member has a version that is greater than the one of some of the members in the group.");
13 SET SESSION sql_log_bin= 1;
14 SET @@GLOBAL.DEBUG= '+d,group_replication_compatibility_higher_patch_version';
15 include/start_and_bootstrap_group_replication.inc
16
17 ############################################################
18 # 2. Join a server that is one patch version
19 # higher than the current version (8.0.35 or higher).
20 [connection server2]
21 SET SESSION sql_log_bin= 0;
22 call mtr.add_suppression("The function 'group_replication_set_as_primary' failed. Error processing configuration start message: The appointed primary member has a version that is greater than the one of some of the members in the group.");
23 SET SESSION sql_log_bin= 1;
24 SET @@GLOBAL.DEBUG= '+d,group_replication_compatibility_higher_patch_version';
25 include/start_group_replication.inc
26
27 ############################################################
28 # 3. Join a 8.0.35 to the group.
29 [connection server3]
30 SET SESSION sql_log_bin= 0;
31 call mtr.add_suppression("Error while executing a group configuration operation: Error processing configuration start message: The appointed primary member has a version that is greater than the one of some of the members in the group.");
32 SET SESSION sql_log_bin= 1;
33 SET @@GLOBAL.DEBUG= '+d,group_replication_version_8_0_35';
34 include/start_group_replication.inc
35 SELECT MEMBER_STATE, MEMBER_ROLE, MEMBER_VERSION FROM performance_schema.replication_group_members WHERE MEMBER_ID='SERVER3_UUID';
36 MEMBER_STATE MEMBER_ROLE MEMBER_VERSION
37 ONLINE SECONDARY 8.0.35
38
39 ############################################################
40 # 4. Validate that the group has one primary and two secondaries.
41 [connection server1]
42 include/rpl_gr_wait_for_number_of_members.inc
43 include/gr_assert_primary_member.inc
44 [connection server2]
45 include/gr_assert_secondary_member.inc
46 [connection server3]
47 include/gr_assert_secondary_member.inc
48
49 ############################################################
50 # 5. Try to make server2, a higher version, the primary.
51 # It must fail.
52 [connection server2]
53 SELECT group_replication_set_as_primary("SERVER2_UUID");
54 ERROR HY000: The function 'group_replication_set_as_primary' failed. Error processing configuration start message: The appointed primary member has a version that is greater than the one of some of the members in the group.
55 include/gr_assert_secondary_member.inc
56 [connection server1]
57 include/gr_assert_primary_member.inc
58 [connection server3]
59 include/gr_assert_secondary_member.inc
60
61 ############################################################
62 # 6. After the primary, server1, leaves, server3 is the new
63 # primary.
64 [connection server1]
65 include/stop_group_replication.inc
66 [connection server3]
67 include/rpl_gr_wait_for_number_of_members.inc
68 include/gr_assert_primary_member.inc
69 [connection server2]
70 include/gr_assert_secondary_member.inc
71
72 ############################################################
73 # 7. Clean up.
74 [connection server1]
75 SET @@GLOBAL.DEBUG= '-d,group_replication_compatibility_higher_patch_version';
76 [connection server2]
77 SET @@GLOBAL.DEBUG= '-d,group_replication_compatibility_higher_patch_version';
78 [connection server3]
79 SET @@GLOBAL.DEBUG= '-d,group_replication_version_8_0_35';
80 include/group_replication_end.inc