Debian Codegraph @

mysql-test/suite/group_replication/r/gr_received_sets_compatibility_member_rejected.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 [connection server2]
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 call mtr.add_suppression("Replica SQL for channel 'group_replication_applier': Relay log read failure: Could not parse relay log event entry.*");
11 call mtr.add_suppression("The applier thread execution was aborted. Unable to process more transactions, this member will now leave the group.");
12 call mtr.add_suppression("Fatal error during execution on the Applier process of Group Replication. The server will now leave the group.");
13 call mtr.add_suppression("The server was automatically set into read only mode after an error was detected.");
14 call mtr.add_suppression("Skipping leave operation: concurrent attempt to leave the group is on-going.");
15 SET SESSION sql_log_bin= 1;
16 #
17 # Create a table for testing on server 1
18 #
19 [connection server1]
20 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY) ENGINE=InnoDB;
21 include/rpl_sync.inc
22 [connection server2]
23 include/assert.inc [Server 2 has 4 transaction belonging to the group]
24 [connection server3]
25 include/assert.inc [Server 3 has 4 transaction belonging to the group]
26 #
27 # Step 1: Block the applier on server 2.
28 #
29 [connection server2]
30 SET @@GLOBAL.DEBUG='+d,block_applier_updates';
31 #
32 # Step 2: Insert some transaction and remove server 3
33 #
34 [connection server1]
35 INSERT INTO t1 VALUES (1);
36 INSERT INTO t1 VALUES (2);
37 include/sync_slave_sql_with_master.inc
38 include/assert.inc [Server 3 has 6 transaction belonging to the group]
39 include/stop_group_replication.inc
40 #
41 # Step 3: Insert more transactions. Assert that server 2 applied none
42 #
43 [connection server1]
44 INSERT INTO t1 VALUES (3);
45 INSERT INTO t1 VALUES (4);
46 [connection server2]
47 #
48 # Step 4: Stop group replication on server 1 and server 2
49 #
50 [connection server2]
51 SET DEBUG_SYNC = "now WAIT_FOR applier_read_blocked";
52 SET @@GLOBAL.DEBUG='-d,block_applier_updates';
53 SET @@GLOBAL.DEBUG='+d,force_sql_thread_error';
54 SET DEBUG_SYNC = "now SIGNAL resume_applier_read";
55 include/gr_wait_for_member_state.inc
56 SET @@GLOBAL.DEBUG='-d,force_sql_thread_error';
57 SET DEBUG_SYNC= 'RESET';
58 include/stop_group_replication.inc
59 [connection server1]
60 include/stop_group_replication.inc
61 #
62 # Step 5: Boot the group again with server 3
63 #
64 [connection server3]
65 include/start_and_bootstrap_group_replication.inc
66 #
67 # Step 6: Try to join server 2 that was less executed GTIDs
68 # The start should fail as server 2 has more transactions in total
69 #
70 [connection server2]
71 include/assert.inc [Server 2 has 4 transaction belonging to the group]
72 [connection server3]
73 include/assert.inc [Server 3 has 7 transaction belonging to the group]
74 [connection server_2]
75 LOCK TABLE t1 READ;
76 [connection server2]
77 SET GLOBAL group_replication_group_name= "ba8c9f00-ec68-11e5-a837-0800200c9a66";
78 START GROUP_REPLICATION;
79 [connection server_2]
80 UNLOCK TABLES;
81 [connection server2]
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 [connection server3]
84 include/rpl_gr_wait_for_number_of_members.inc
85 #
86 # Step 7: Clean up
87 #
88 [connection server3]
89 include/stop_group_replication.inc
90 [connection server1]
91 include/start_and_bootstrap_group_replication.inc
92 [connection server2]
93 include/start_group_replication.inc
94 [connection server3]
95 include/start_group_replication.inc
96 DROP TABLE t1;
97 include/group_replication_end.inc