Debian Codegraph @

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

raw
1 include/only_with_option.inc [GLOBAL.replica_parallel_workers > 1]
2 include/group_replication.inc [rpl_server_count=4]
3 Warnings:
4 Note #### Sending passwords in plain text without SSL/TLS is extremely insecure.
5 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.
6 [connection server1]
7 # Bootstrap group with server1 as primary and server2, server3 as secondaries.
8 [connection server1]
9 include/start_and_bootstrap_group_replication.inc
10 # Create inbound channel from server4 to server1
11 CHANGE REPLICATION SOURCE TO SOURCE_HOST='127.0.0.1', SOURCE_USER='root', SOURCE_AUTO_POSITION=1, SOURCE_PORT=SERVER_4_PORT FOR CHANNEL 'ch1';
12 Warnings:
13 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
14 Note 1760 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.
15 include/start_slave.inc [FOR CHANNEL 'ch1']
16 # Create tables
17 [connection server4]
18 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
19 CREATE TABLE t2 (c1 INT NOT NULL PRIMARY KEY);
20 include/sync_slave_sql_with_master.inc
21 # Make server2 join the group
22 [connection server2]
23 include/start_group_replication.inc
24 # Take a lock on the primary so that T1 will be blocked
25 [connection server_1_1]
26 LOCK TABLES t1 WRITE;
27 # Commit transaction T1 on table t1, then transaction T2 on t2.
28 [connection server4]
29 INSERT INTO t1 VALUES (1);
30 INSERT INTO t2 VALUES (2);
31 # Wait until T2 is waiting for T1 to commit.
32 [connection server1]
33 include/save_error_log_position.inc
34 # Join server3 to the group
35 [connection server3]
36 include/start_group_replication.inc
37 # Wait for T2 to commit on server1
38 [connection server1]
39 include/assert_error_log.inc [server: 1, pattern: The transaction '[a-z0-9\-]*:[0-9]*' will commit out of order with respect to its source to follow the group global order]
40 # Verify that t1 is still not committed
41 include/assert.inc [There should be one missing GTID]
42 [connection server_1_1]
43 include/assert.inc [t1 should still be empty]
44 # Check that new transactions block as needed, *not* violating replica-preserve-commit-order
45 [connection server_4]
46 INSERT INTO t2 VALUES (3);
47 [connection server_1]
48 include/assert.inc [t2 should still have only one element]
49 # Unblock T1 and T3 and let them finish
50 [connection server_1_1]
51 UNLOCK TABLES;
52 include/rpl_sync.inc
53 # Clean up
54 [connection server4]
55 DROP TABLE t1;
56 DROP TABLE t2;
57 include/sync_slave_sql_with_master.inc
58 [connection server1]
59 include/stop_slave.inc [FOR CHANNEL 'ch1']
60 RESET REPLICA ALL FOR CHANNEL 'ch1';
61 include/rpl_sync.inc
62 [connection server3]
63 include/stop_group_replication.inc
64 [connection server2]
65 include/stop_group_replication.inc
66 [connection server1]
67 include/stop_group_replication.inc
68 include/group_replication_end.inc