Debian Codegraph @

mysql-test/suite/group_replication/r/gr_executed_sets_compatibility.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 SET SESSION sql_log_bin= 0;
8 call mtr.add_suppression(".*This member has more executed transactions *.*");
9 call mtr.add_suppression(".*The member contains transactions not present *.*");
10 SET SESSION sql_log_bin= 1;
11 [connection server2]
12 SET SESSION sql_log_bin= 0;
13 call mtr.add_suppression(".*This member has more executed transactions *.*");
14 call mtr.add_suppression(".*The member contains transactions not present *.*");
15 SET SESSION sql_log_bin= 1;
16 #
17 # Setup the first member
18 #
19 [connection server1]
20 include/start_and_bootstrap_group_replication.inc
21 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
22 INSERT INTO t1 VALUES (1);
23 include/assert.inc [The first member has 3 transaction belonging to the group]
24 #
25 # Test case 1: Try to add a member with local data on it.
26 # The start group replication command shall fail
27 #
28 [connection server2]
29 SET GTID_NEXT= "aaaaaaaa-bbbb-aaaa-bbbb-aaaaaaaaaaaa:1";
30 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
31 SET GTID_NEXT= "AUTOMATIC";
32 include/assert.inc [The member shall contain a local transaction]
33 SET GLOBAL group_replication_group_name= "b2b6cdc0-eb94-11e5-a837-0800200c9a66";
34 START GROUP_REPLICATION;
35 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
36 # Test case 1 cleanup
37 # Remove data on server 2
38 DROP TABLE t2;
39 RESET MASTER;
40 [connection server1]
41 include/rpl_gr_wait_for_number_of_members.inc
42 #
43 # Test case 2: Try to add a member with more group transactions
44 # The start group replication command shall fail
45 #
46 [connection server1]
47 include/stop_group_replication.inc
48 [connection server2]
49 include/start_and_bootstrap_group_replication.inc
50 include/assert.inc [The first member to join has only one transaction]
51 [connection server1]
52 include/assert.inc [The second member to join has 4 transactions]
53 SET GLOBAL group_replication_group_name= "b2b6cdc0-eb94-11e5-a837-0800200c9a66";
54 START GROUP_REPLICATION;
55 ERROR HY000: The server is not configured properly to be an active member of the group. Please see more details on error log.
56 # Test case 2 cleanup
57 # Put server 1 back in the group
58 [connection server2]
59 include/rpl_gr_wait_for_number_of_members.inc
60 include/stop_group_replication.inc
61 RESET MASTER;
62 [connection server1]
63 include/start_and_bootstrap_group_replication.inc
64 [connection server2]
65 include/start_group_replication.inc
66 #
67 # Verify all is fine
68 #
69 [connection server1]
70 INSERT INTO t1 VALUES (2);
71 include/rpl_sync.inc
72 include/assert.inc ['There are two values in table t1']
73 [connection server2]
74 include/assert.inc ['There are two values in table t1']
75 #
76 # Cleaning up
77 #
78 DROP TABLE t1;
79 include/group_replication_end.inc