Debian Codegraph @

mysql-test/suite/group_replication/r/gr_cross_version_member_join.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 [connection server1]
7 include/start_and_bootstrap_group_replication.inc
8 [connection server2]
9 SET SESSION sql_log_bin=0;
10 call mtr.add_suppression("Member version is incompatible with the group.");
11 call mtr.add_suppression("Member version is read compatible with the group.");
12 SET SESSION sql_log_bin=1;
13 SET @debug_save= @@GLOBAL.DEBUG;
14
15 # 1. Lower version do not join the group.
16
17
18 # 1.1. Make M2 major version lower and make sure START GR fails.
19 SET @@GLOBAL.DEBUG= 'd,group_replication_compatibility_lower_major_version';
20 SET GLOBAL group_replication_group_name= "GROUP_REPLICATION_GROUP_NAME";
21 START GROUP_REPLICATION;
22 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
23 include/assert.inc [Assert M2 is OFFLINE.]
24
25 # 1.2. Make M2 minor version lower and make sure START GR fails.
26 SET @@GLOBAL.DEBUG= 'd,group_replication_compatibility_lower_minor_version';
27 START GROUP_REPLICATION;
28 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
29 include/assert.inc [Assert M2 is OFFLINE.]
30
31 # 1.3. Make M2 patch version lower and make sure START GR succeeds
32 # because both versions are 8.0 and >= 8.0.35.
33 SET @@GLOBAL.DEBUG= 'd,group_replication_compatibility_lower_patch_version';
34 include/start_group_replication.inc
35 include/gr_assert_mpm_consistency.inc
36 include/stop_group_replication.inc
37
38 # 2. Higher version are in read-only mode.
39
40
41 # 2.1. Make M2 major version higher and assert read-only is set.
42 SET @@GLOBAL.DEBUG= 'd,group_replication_compatibility_higher_major_version';
43 include/start_group_replication.inc
44 include/gr_assert_mpm_consistency.inc
45
46 # 2.2. Make M2 minor version higher and assert read-only is set.
47 [connection server2]
48 include/stop_group_replication.inc
49 SET @@GLOBAL.DEBUG= 'd,group_replication_compatibility_higher_minor_version';
50 include/start_group_replication.inc
51 include/gr_assert_mpm_consistency.inc
52
53 # 2.3. Make M2 patch version higher and assert read-only is set.
54 [connection server2]
55 include/stop_group_replication.inc
56 SET @@GLOBAL.DEBUG= 'd,group_replication_compatibility_higher_patch_version';
57 include/start_group_replication.inc
58 include/gr_assert_mpm_consistency.inc
59
60 # 3. Make M2 version same as M1 and confirm both M1 and M2 are online.
61 # Assert read-only is disabled on M2.
62
63 [connection server2]
64 include/stop_group_replication.inc
65 include/gr_assert_mpm_consistency.inc
66 SET @@GLOBAL.DEBUG= @debug_save;
67 include/start_group_replication.inc
68 include/gr_assert_mpm_consistency.inc
69
70 # 4. Cleanup.
71
72 include/group_replication_end.inc