Debian Codegraph @

mysql-test/suite/group_replication/r/gr_force_lower_version_member.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 # Setup a member in a way that his version is higher than member 2
8 #
9 server1
10 SET @debug_saved= @@GLOBAL.DEBUG;
11 SET @@GLOBAL.DEBUG= '+d,group_replication_compatibility_higher_major_version';
12 include/start_and_bootstrap_group_replication.inc
13 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
14 INSERT INTO t1 VALUES (1);
15 #
16 # Try to add a new member that has a lower version than member 1
17 #
18 server2
19 SET session sql_log_bin=0;
20 call mtr.add_suppression("Member version is incompatible with the group");
21 SET session sql_log_bin=1;
22 SET GLOBAL group_replication_group_name= "6f6932e0-03d9-11e5-b939-0800200c9a12";
23 START GROUP_REPLICATION;
24 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
25 SET GLOBAL group_replication_allow_local_lower_version_join= NULL;
26 ERROR 42000: Variable 'group_replication_allow_local_lower_version_join' can't be set to the value of 'NULL'
27 SET GLOBAL group_replication_allow_local_lower_version_join= "a";
28 ERROR 42000: Variable 'group_replication_allow_local_lower_version_join' can't be set to the value of 'a'
29 SET GLOBAL group_replication_allow_local_lower_version_join= 1.2;
30 ERROR 42000: Incorrect argument type to variable 'group_replication_allow_local_lower_version_join'
31 SET GLOBAL group_replication_allow_local_lower_version_join= ON;
32 include/start_group_replication.inc
33 INSERT INTO t1 VALUES (2);
34 include/rpl_sync.inc
35 #
36 # Check all is fine
37 #
38 server1
39 include/assert.inc [GTID_EXECUTED must contain all committed GTIDs]
40 include/assert.inc ['There is a value 1 in table t1']
41 include/assert.inc ['There is a value 2 in table t1']
42 server2
43 include/assert.inc [GTID_EXECUTED must contain all committed GTIDs]
44 include/assert.inc ['There is a value 1 in table t1']
45 include/assert.inc ['There is a value 2 in table t1']
46 #
47 # Clean up
48 #
49 DROP TABLE t1;
50 SET @@GLOBAL.DEBUG= @debug_save;
51 include/stop_group_replication.inc
52 include/start_group_replication.inc
53 SET GLOBAL group_replication_allow_local_lower_version_join= OFF;
54 include/group_replication_end.inc