Debian Codegraph @

mysql-test/suite/group_replication/r/gr_consistent_reads_after_member_join2.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 [connection server1]
10 include/start_and_bootstrap_group_replication.inc
11 CREATE TABLE t1 (a INT PRIMARY KEY);
12 INSERT INTO t1 VALUES (1);
13 [connection server2]
14 include/start_group_replication.inc
15
16 ############################################################
17 # 02. Lock table t1 on server2 to block a future update.
18 [connection server2]
19 LOCK TABLE t1 READ;
20
21 ############################################################
22 # 03. Execute transaction T1, the transaction will block since
23 # server2 cannot prepare.
24 [connection server1]
25 INSERT INTO t1 VALUES (2);
26 ############################################################
27 # 04. Execute START GR on M3.
28 # The member will be in RECOVERING until T1 is complete.
29 [connection server3]
30 include/start_group_replication.inc
31
32 ############################################################
33 # 05. On M2: Unlock t1.
34 [connection server2]
35 UNLOCK TABLES;
36
37 ############################################################
38 # 06. server3 will change to ONLINE state.
39 [connection server3]
40 include/gr_wait_for_member_state.inc
41
42 ############################################################
43 # 07. Validate data.
44 [connection server1]
45 include/assert.inc ['There is a 1 value in table t1']
46 include/assert.inc ['There is a 2 value in table t1']
47 include/show_binlog_events.inc
48 Log_name Pos Event_type Server_id End_log_pos Info
49 server-binary-log.000001 # Previous_gtids # #
50 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
51 server-binary-log.000001 # Query # # BEGIN
52 server-binary-log.000001 # Query # # COMMIT
53 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
54 server-binary-log.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY)
55 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
56 server-binary-log.000001 # Query # # BEGIN
57 server-binary-log.000001 # Table_map # # table_id: # (test.t1)
58 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
59 server-binary-log.000001 # Xid # # COMMIT /* XID */
60 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
61 server-binary-log.000001 # Query # # BEGIN
62 server-binary-log.000001 # Query # # COMMIT
63 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
64 server-binary-log.000001 # Query # # BEGIN
65 server-binary-log.000001 # Table_map # # table_id: # (test.t1)
66 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
67 server-binary-log.000001 # Xid # # COMMIT /* XID */
68 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
69 server-binary-log.000001 # Query # # BEGIN
70 server-binary-log.000001 # Query # # COMMIT
71 [connection server2]
72 include/assert.inc ['There is a 1 value in table t1']
73 include/assert.inc ['There is a 2 value in table t1']
74 include/show_binlog_events.inc
75 Log_name Pos Event_type Server_id End_log_pos Info
76 server-binary-log.000001 # Previous_gtids # #
77 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
78 server-binary-log.000001 # Query # # BEGIN
79 server-binary-log.000001 # Query # # COMMIT
80 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
81 server-binary-log.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY)
82 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
83 server-binary-log.000001 # Query # # BEGIN
84 server-binary-log.000001 # Table_map # # table_id: # (test.t1)
85 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
86 server-binary-log.000001 # Xid # # COMMIT /* XID */
87 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
88 server-binary-log.000001 # Query # # BEGIN
89 server-binary-log.000001 # Query # # COMMIT
90 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
91 server-binary-log.000001 # Query # # BEGIN
92 server-binary-log.000001 # Table_map # # table_id: # (test.t1)
93 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
94 server-binary-log.000001 # Xid # # COMMIT /* XID */
95 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
96 server-binary-log.000001 # Query # # BEGIN
97 server-binary-log.000001 # Query # # COMMIT
98 [connection server3]
99 include/assert.inc ['There is a 1 value in table t1']
100 include/assert.inc ['There is a 2 value in table t1']
101 include/show_binlog_events.inc
102 Log_name Pos Event_type Server_id End_log_pos Info
103 server-binary-log.000001 # Previous_gtids # #
104 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
105 server-binary-log.000001 # Query # # BEGIN
106 server-binary-log.000001 # Query # # COMMIT
107 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
108 server-binary-log.000001 # Query # # use `test`; CREATE TABLE t1 (a INT PRIMARY KEY)
109 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
110 server-binary-log.000001 # Query # # BEGIN
111 server-binary-log.000001 # Table_map # # table_id: # (test.t1)
112 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
113 server-binary-log.000001 # Xid # # COMMIT /* XID */
114 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
115 server-binary-log.000001 # Query # # BEGIN
116 server-binary-log.000001 # Query # # COMMIT
117 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
118 server-binary-log.000001 # Query # # BEGIN
119 server-binary-log.000001 # Table_map # # table_id: # (test.t1)
120 server-binary-log.000001 # Write_rows # # table_id: # flags: STMT_END_F
121 server-binary-log.000001 # Xid # # COMMIT /* XID */
122 server-binary-log.000001 # Gtid # # SET @@SESSION.GTID_NEXT= 'Gtid_set'
123 server-binary-log.000001 # Query # # BEGIN
124 server-binary-log.000001 # Query # # COMMIT
125 include/diff_tables.inc [server1:t1, server2:t1, server3:t1]
126
127 ############################################################
128 # 08. Clean up.
129 [connection server1]
130 DROP TABLE t1;
131 include/group_replication_end.inc