Debian Codegraph @

mysql-test/suite/rpl/r/rpl_row_show_relaylog_events.result

raw
1 include/master-slave.inc
2 [connection master]
3 connection master;
4 include/rpl_reset.inc
5 connection master;
6 CREATE TABLE t1 (a INT);
7 INSERT INTO t1 VALUES (1);
8 INSERT INTO t1 VALUES (2);
9 INSERT INTO t1 VALUES (3);
10 ******** [master] SHOW BINLOG EVENTS IN <FILE> ********
11 include/show_events.inc
12 Log_name Pos Event_type Server_id End_log_pos Info
13 master-bin.000001 # Gtid # # GTID #-#-#
14 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
15 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
16 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
17 master-bin.000001 # Table_map # # table_id: # (test.t1)
18 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
19 master-bin.000001 # Query # # COMMIT
20 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
21 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
22 master-bin.000001 # Table_map # # table_id: # (test.t1)
23 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
24 master-bin.000001 # Query # # COMMIT
25 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
26 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3)
27 master-bin.000001 # Table_map # # table_id: # (test.t1)
28 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
29 master-bin.000001 # Query # # COMMIT
30 ******** [master] SHOW BINLOG EVENTS IN <FILE> LIMIT 2 ********
31 include/show_events.inc
32 Log_name Pos Event_type Server_id End_log_pos Info
33 master-bin.000001 # Gtid # # GTID #-#-#
34 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
35 ******** [master] SHOW BINLOG EVENTS IN <FILE> LIMIT 2,4 ********
36 include/show_events.inc
37 Log_name Pos Event_type Server_id End_log_pos Info
38 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
39 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
40 master-bin.000001 # Table_map # # table_id: # (test.t1)
41 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
42 ******** [master] SHOW BINLOG EVENTS ********
43 include/show_events.inc
44 Log_name Pos Event_type Server_id End_log_pos Info
45 master-bin.000001 # Gtid # # GTID #-#-#
46 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
47 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
48 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
49 master-bin.000001 # Table_map # # table_id: # (test.t1)
50 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
51 master-bin.000001 # Query # # COMMIT
52 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
53 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
54 master-bin.000001 # Table_map # # table_id: # (test.t1)
55 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
56 master-bin.000001 # Query # # COMMIT
57 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
58 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3)
59 master-bin.000001 # Table_map # # table_id: # (test.t1)
60 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
61 master-bin.000001 # Query # # COMMIT
62 connection slave;
63 ******** [slave] SHOW BINLOG EVENTS IN <FILE> ********
64 include/show_events.inc
65 Log_name Pos Event_type Server_id End_log_pos Info
66 slave-bin.000001 # Gtid # # GTID #-#-#
67 slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
68 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
69 slave-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
70 slave-bin.000001 # Table_map # # table_id: # (test.t1)
71 slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
72 slave-bin.000001 # Query # # COMMIT
73 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
74 slave-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
75 slave-bin.000001 # Table_map # # table_id: # (test.t1)
76 slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
77 slave-bin.000001 # Query # # COMMIT
78 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
79 slave-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3)
80 slave-bin.000001 # Table_map # # table_id: # (test.t1)
81 slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
82 slave-bin.000001 # Query # # COMMIT
83 ******** [slave] SHOW BINLOG EVENTS IN <FILE> LIMIT 2 ********
84 include/show_events.inc
85 Log_name Pos Event_type Server_id End_log_pos Info
86 slave-bin.000001 # Gtid # # GTID #-#-#
87 slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
88 ******** [slave] SHOW BINLOG EVENTS IN <FILE> LIMIT 2,4 ********
89 include/show_events.inc
90 Log_name Pos Event_type Server_id End_log_pos Info
91 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
92 slave-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
93 slave-bin.000001 # Table_map # # table_id: # (test.t1)
94 slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
95 ******** [slave] SHOW BINLOG EVENTS ********
96 include/show_events.inc
97 Log_name Pos Event_type Server_id End_log_pos Info
98 slave-bin.000001 # Gtid # # GTID #-#-#
99 slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
100 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
101 slave-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
102 slave-bin.000001 # Table_map # # table_id: # (test.t1)
103 slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
104 slave-bin.000001 # Query # # COMMIT
105 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
106 slave-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
107 slave-bin.000001 # Table_map # # table_id: # (test.t1)
108 slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
109 slave-bin.000001 # Query # # COMMIT
110 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
111 slave-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3)
112 slave-bin.000001 # Table_map # # table_id: # (test.t1)
113 slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
114 slave-bin.000001 # Query # # COMMIT
115 ******** [slave] SHOW RELAYLOG EVENTS IN <FILE> ********
116 include/show_events.inc
117 Log_name Pos Event_type Server_id End_log_pos Info
118 slave-relay-bin.000002 # Rotate # # master-bin.000001;pos=POS
119 slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
120 slave-relay-bin.000002 # Gtid_list # # []
121 slave-relay-bin.000002 # Binlog_checkpoint # # master-bin.000001
122 slave-relay-bin.000002 # Gtid # # GTID #-#-#
123 slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a INT)
124 slave-relay-bin.000002 # Gtid # # BEGIN GTID #-#-#
125 slave-relay-bin.000002 # Annotate_rows # # INSERT INTO t1 VALUES (1)
126 slave-relay-bin.000002 # Table_map # # table_id: # (test.t1)
127 slave-relay-bin.000002 # Write_rows_v1 # # table_id: # flags: STMT_END_F
128 slave-relay-bin.000002 # Query # # COMMIT
129 slave-relay-bin.000002 # Gtid # # BEGIN GTID #-#-#
130 slave-relay-bin.000002 # Annotate_rows # # INSERT INTO t1 VALUES (2)
131 slave-relay-bin.000002 # Table_map # # table_id: # (test.t1)
132 slave-relay-bin.000002 # Write_rows_v1 # # table_id: # flags: STMT_END_F
133 slave-relay-bin.000002 # Query # # COMMIT
134 slave-relay-bin.000002 # Gtid # # BEGIN GTID #-#-#
135 slave-relay-bin.000002 # Annotate_rows # # INSERT INTO t1 VALUES (3)
136 slave-relay-bin.000002 # Table_map # # table_id: # (test.t1)
137 slave-relay-bin.000002 # Write_rows_v1 # # table_id: # flags: STMT_END_F
138 slave-relay-bin.000002 # Query # # COMMIT
139 ******** [slave] SHOW RELAYLOG EVENTS IN <FILE> LIMIT 2 ********
140 include/show_events.inc
141 Log_name Pos Event_type Server_id End_log_pos Info
142 slave-relay-bin.000002 # Rotate # # master-bin.000001;pos=POS
143 slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
144 ******** [slave] SHOW RELAYLOG EVENTS IN <FILE> LIMIT 2,4 ********
145 include/show_events.inc
146 Log_name Pos Event_type Server_id End_log_pos Info
147 slave-relay-bin.000002 # Gtid_list # # []
148 slave-relay-bin.000002 # Binlog_checkpoint # # master-bin.000001
149 slave-relay-bin.000002 # Gtid # # GTID #-#-#
150 slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a INT)
151 ******** [slave] SHOW RELAYLOG EVENTS ********
152 include/show_events.inc
153 Log_name Pos Event_type Server_id End_log_pos Info
154 slave-relay-bin.000001 # Rotate # # slave-relay-bin.000002;pos=POS
155 FLUSH LOGS;
156 connection master;
157 FLUSH LOGS;
158 DROP TABLE t1;
159 ******** [master] SHOW BINLOG EVENTS IN <FILE> ********
160 include/show_events.inc
161 Log_name Pos Event_type Server_id End_log_pos Info
162 master-bin.000002 # Binlog_checkpoint # # master-bin.000002
163 master-bin.000002 # Gtid # # GTID #-#-#
164 master-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
165 ******** [master] SHOW BINLOG EVENTS IN <FILE> LIMIT 2 ********
166 include/show_events.inc
167 Log_name Pos Event_type Server_id End_log_pos Info
168 master-bin.000002 # Binlog_checkpoint # # master-bin.000002
169 master-bin.000002 # Gtid # # GTID #-#-#
170 ******** [master] SHOW BINLOG EVENTS IN <FILE> LIMIT 2,4 ********
171 include/show_events.inc
172 Log_name Pos Event_type Server_id End_log_pos Info
173 master-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
174 ******** [master] SHOW BINLOG EVENTS ********
175 include/show_events.inc
176 Log_name Pos Event_type Server_id End_log_pos Info
177 master-bin.000001 # Gtid # # GTID #-#-#
178 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
179 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
180 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
181 master-bin.000001 # Table_map # # table_id: # (test.t1)
182 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
183 master-bin.000001 # Query # # COMMIT
184 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
185 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
186 master-bin.000001 # Table_map # # table_id: # (test.t1)
187 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
188 master-bin.000001 # Query # # COMMIT
189 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
190 master-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3)
191 master-bin.000001 # Table_map # # table_id: # (test.t1)
192 master-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
193 master-bin.000001 # Query # # COMMIT
194 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
195 connection slave;
196 ******** [slave] SHOW BINLOG EVENTS IN <FILE> ********
197 include/show_events.inc
198 Log_name Pos Event_type Server_id End_log_pos Info
199 slave-bin.000002 # Binlog_checkpoint # # slave-bin.000002
200 slave-bin.000002 # Gtid # # GTID #-#-#
201 slave-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */
202 ******** [slave] SHOW BINLOG EVENTS IN <FILE> LIMIT 2 ********
203 include/show_events.inc
204 Log_name Pos Event_type Server_id End_log_pos Info
205 slave-bin.000002 # Binlog_checkpoint # # slave-bin.000002
206 slave-bin.000002 # Gtid # # GTID #-#-#
207 ******** [slave] SHOW BINLOG EVENTS IN <FILE> LIMIT 2,4 ********
208 include/show_events.inc
209 Log_name Pos Event_type Server_id End_log_pos Info
210 slave-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */
211 ******** [slave] SHOW BINLOG EVENTS ********
212 include/show_events.inc
213 Log_name Pos Event_type Server_id End_log_pos Info
214 slave-bin.000001 # Gtid # # GTID #-#-#
215 slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
216 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
217 slave-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (1)
218 slave-bin.000001 # Table_map # # table_id: # (test.t1)
219 slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
220 slave-bin.000001 # Query # # COMMIT
221 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
222 slave-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (2)
223 slave-bin.000001 # Table_map # # table_id: # (test.t1)
224 slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
225 slave-bin.000001 # Query # # COMMIT
226 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
227 slave-bin.000001 # Annotate_rows # # INSERT INTO t1 VALUES (3)
228 slave-bin.000001 # Table_map # # table_id: # (test.t1)
229 slave-bin.000001 # Write_rows_v1 # # table_id: # flags: STMT_END_F
230 slave-bin.000001 # Query # # COMMIT
231 slave-bin.000001 # Rotate # # slave-bin.000002;pos=POS
232 ******** [slave] SHOW RELAYLOG EVENTS IN <FILE> ********
233 include/show_events.inc
234 Log_name Pos Event_type Server_id End_log_pos Info
235 slave-relay-bin.000005 # Rotate # # master-bin.000002;pos=POS
236 slave-relay-bin.000005 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
237 slave-relay-bin.000005 # Gtid_list # # [#-#-#]
238 slave-relay-bin.000005 # Binlog_checkpoint # # master-bin.000001
239 slave-relay-bin.000005 # Binlog_checkpoint # # master-bin.000002
240 slave-relay-bin.000005 # Gtid # # GTID #-#-#
241 slave-relay-bin.000005 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
242 ******** [slave] SHOW RELAYLOG EVENTS IN <FILE> LIMIT 2 ********
243 include/show_events.inc
244 Log_name Pos Event_type Server_id End_log_pos Info
245 slave-relay-bin.000005 # Rotate # # master-bin.000002;pos=POS
246 slave-relay-bin.000005 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
247 ******** [slave] SHOW RELAYLOG EVENTS IN <FILE> LIMIT 2,4 ********
248 include/show_events.inc
249 Log_name Pos Event_type Server_id End_log_pos Info
250 slave-relay-bin.000005 # Gtid_list # # [#-#-#]
251 slave-relay-bin.000005 # Binlog_checkpoint # # master-bin.000001
252 slave-relay-bin.000005 # Binlog_checkpoint # # master-bin.000002
253 slave-relay-bin.000005 # Gtid # # GTID #-#-#
254 ******** [slave] SHOW RELAYLOG EVENTS ********
255 include/show_events.inc
256 Log_name Pos Event_type Server_id End_log_pos Info
257 slave-relay-bin.000004 # Rotate # # master-bin.000002;pos=POS
258 slave-relay-bin.000004 # Rotate # # slave-relay-bin.000005;pos=POS
259 include/rpl_end.inc