Debian Codegraph @

mysql-test/suite/group_replication/r/gr_consistent_reads_after_replicate_from_server.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
7 ############################################################
8 # 01. Bootstrap group with M1, add M2.
9 include/start_and_bootstrap_group_replication.inc
10 [connection server2]
11 include/start_group_replication.inc
12
13 ############################################################
14 # 02. Replicate from server3 into server2.
15 [connection server2]
16 CHANGE REPLICATION SOURCE TO SOURCE_HOST='localhost', SOURCE_USER='root', SOURCE_PORT=SERVER_3_PORT for channel 'ch3_2';
17 Warnings:
18 Note 1759 Sending passwords in plain text without SSL/TLS is extremely insecure.
19 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.
20 include/start_slave.inc [FOR CHANNEL 'ch3_2']
21 [connection server3]
22 CREATE TABLE t1 (c1 INT NOT NULL PRIMARY KEY);
23 [connection server1]
24 [connection server2]
25
26 ############################################################
27 # 03. Make server2 block before send its prepare message.
28 [connection server2]
29 SET @@GLOBAL.DEBUG= '+d,group_replication_wait_before_message_send_after_applier_prepare';
30
31 ############################################################
32 # 04. Execute T1 on server1 with
33 # @@SESSION.group_replication_consistency= 'AFTER'
34 [connection server1]
35 SET @@SESSION.group_replication_consistency= 'AFTER';
36 INSERT INTO t1 VALUES (1);
37
38 ############################################################
39 # 05. Wait until T1 is prepared on server2.
40 [connection server2]
41 SET DEBUG_SYNC= "now WAIT_FOR signal.after_before_message_send_after_applier_prepare_waiting";
42
43 ############################################################
44 # 06. Execute T2 on server3, it will wait for T1 on server2.
45 [connection server3]
46 INSERT INTO t1 VALUES (3);
47 [connection server2]
48
49 ############################################################
50 # 07. Make server2 do send its prepare message.
51 [connection server2]
52 SET DEBUG_SYNC= 'now SIGNAL signal.after_before_message_send_after_applier_prepare_continue';
53 SET @@GLOBAL.DEBUG= '-d,group_replication_wait_before_message_send_after_applier_prepare';
54
55 ############################################################
56 # 08. Validate data.
57 include/rpl_sync.inc
58 [connection server1]
59 SET @@SESSION.group_replication_consistency= DEFAULT;
60 include/assert.inc ['There is a 1 value in table t1']
61 [connection server2]
62 include/assert.inc ['There is a 1 value in table t1']
63 [connection server3]
64 include/assert.inc ['There is no 1 value in table t1']
65 include/assert.inc ['There is a 3 value in table t1']
66 include/diff_tables.inc [server1:t1, server2:t1]
67
68 ############################################################
69 # 09. Clean up.
70 [connection server3]
71 DROP TABLE t1;
72 [connection server1]
73 [connection server2]
74 SET DEBUG_SYNC= 'RESET';
75 include/stop_slave.inc [FOR CHANNEL 'ch3_2']
76 RESET SLAVE ALL FOR CHANNEL 'ch3_2';
77 Warnings:
78 Warning 1287 'RESET SLAVE' is deprecated and will be removed in a future release. Please use RESET REPLICA instead
79 include/group_replication_end.inc