Debian Codegraph @

mysql-test/suite/group_replication/r/gr_multiple_version_members.result

raw
1 include/group_replication.inc [rpl_server_count=4]
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 # Check the version of member 1 is fully visible in the plugin table
8 #
9 include/assert.inc [The plugin major and minor versions are visible in the version column]
10 include/assert.inc [The plugin total version can be seen in the description column]
11 #
12 # Setup a new member with version a higher patch version
13 # Version= Base version + 1 patch version
14 #
15 server1
16 SET @debug_saved_s1= @@GLOBAL.DEBUG;
17 SET @@GLOBAL.DEBUG= '+d,group_replication_compatibility_higher_patch_version';
18 include/start_and_bootstrap_group_replication.inc
19 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
20 INSERT INTO t1 VALUES (1);
21 #
22 # Try to add a new member with a higher minor version
23 # Version = Base version + 1 minor version
24 # The member will join the group
25 #
26 server2
27 SET @debug_saved_s2= @@GLOBAL.DEBUG;
28 SET @@GLOBAL.DEBUG= '+d,group_replication_compatibility_higher_minor_version';
29 SET session sql_log_bin=0;
30 call mtr.add_suppression("Member version is read compatible with the group.");
31 SET session sql_log_bin=1;
32 include/start_group_replication.inc
33 include/assert.inc [On the recovered member, the table should contain 1 elements]
34 #
35 # Try to add a new member with a base version.
36 # Version = Base version
37 # It will fail since group lowest version is (patch + 1)
38 # Try to add server 3 again with higher major version.
39 # Version= Base version + 1 major version
40 # It will succeed and join group in read only mode.
41 #
42 server3
43 SET session sql_log_bin=0;
44 call mtr.add_suppression("Member version is incompatible with the group");
45 call mtr.add_suppression("Member version is read compatible with the group.");
46 SET session sql_log_bin=1;
47 SET GLOBAL group_replication_group_name= "8a1da670-05fa-11e5-b939-0800200c9a66";
48 START GROUP_REPLICATION;
49 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
50 SET @@GLOBAL.DEBUG= '+d,group_replication_compatibility_higher_major_version';
51 include/start_group_replication.inc
52 include/assert.inc [On the recovered member, the table should contain 1 elements]
53 #
54 # Try to add a new member with a major version equal to the base version,
55 # but a higher minor version.
56 # Version = Base version + 1 minor version
57 #
58 server4
59 SET @debug_saved_s4= @@GLOBAL.DEBUG;
60 SET session sql_log_bin=0;
61 call mtr.add_suppression("Member version is read compatible with the group.");
62 SET session sql_log_bin=1;
63 SET @@GLOBAL.DEBUG= '+d,group_replication_compatibility_higher_minor_version';
64 SET GLOBAL group_replication_group_name= "8a1da670-05fa-11e5-b939-0800200c9a66";
65 include/start_group_replication.inc
66 include/assert.inc [On the recovered member, the table should contain 1 elements]
67 #
68 # Stop GR on server 1 and start server 1 with base version.
69 # Version = Base version
70 # It will fail since group lowest version is (minor + 1)
71 #
72 server1
73 DROP TABLE t1;
74 include/rpl_sync.inc
75 include/stop_group_replication.inc
76 SET session sql_log_bin=0;
77 call mtr.add_suppression("Member version is incompatible with the group");
78 SET session sql_log_bin=1;
79 SET @@GLOBAL.DEBUG= @debug_save_s1;
80 SET GLOBAL group_replication_group_name= "8a1da670-05fa-11e5-b939-0800200c9a66";
81 START GROUP_REPLICATION;
82 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
83 #
84 # Clean up
85 #
86 server2
87 SET @@GLOBAL.DEBUG= @debug_save_s2;
88 include/stop_group_replication.inc
89 server3
90 SET @@GLOBAL.DEBUG= @debug_save_s3;
91 include/stop_group_replication.inc
92 server4
93 SET @@GLOBAL.DEBUG= @debug_save_s4;
94 include/stop_group_replication.inc
95 include/group_replication_end.inc