Debian Codegraph @

mysql-test/suite/rpl/r/rpl_stm_mix_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 # Query # # use `test`; INSERT INTO t1 VALUES (1)
17 master-bin.000001 # Query # # COMMIT
18 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
19 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
20 master-bin.000001 # Query # # COMMIT
21 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
22 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
23 master-bin.000001 # Query # # COMMIT
24 ******** [master] SHOW BINLOG EVENTS IN <FILE> LIMIT 2 ********
25 include/show_events.inc
26 Log_name Pos Event_type Server_id End_log_pos Info
27 master-bin.000001 # Gtid # # GTID #-#-#
28 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
29 ******** [master] SHOW BINLOG EVENTS IN <FILE> LIMIT 2,4 ********
30 include/show_events.inc
31 Log_name Pos Event_type Server_id End_log_pos Info
32 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
33 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
34 master-bin.000001 # Query # # COMMIT
35 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
36 ******** [master] SHOW BINLOG EVENTS ********
37 include/show_events.inc
38 Log_name Pos Event_type Server_id End_log_pos Info
39 master-bin.000001 # Gtid # # GTID #-#-#
40 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
41 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
42 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
43 master-bin.000001 # Query # # COMMIT
44 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
45 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
46 master-bin.000001 # Query # # COMMIT
47 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
48 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
49 master-bin.000001 # Query # # COMMIT
50 connection slave;
51 ******** [slave] SHOW BINLOG EVENTS IN <FILE> ********
52 include/show_events.inc
53 Log_name Pos Event_type Server_id End_log_pos Info
54 slave-bin.000001 # Gtid # # GTID #-#-#
55 slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
56 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
57 slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
58 slave-bin.000001 # Query # # COMMIT
59 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
60 slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
61 slave-bin.000001 # Query # # COMMIT
62 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
63 slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
64 slave-bin.000001 # Query # # COMMIT
65 ******** [slave] SHOW BINLOG EVENTS IN <FILE> LIMIT 2 ********
66 include/show_events.inc
67 Log_name Pos Event_type Server_id End_log_pos Info
68 slave-bin.000001 # Gtid # # GTID #-#-#
69 slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
70 ******** [slave] SHOW BINLOG EVENTS IN <FILE> LIMIT 2,4 ********
71 include/show_events.inc
72 Log_name Pos Event_type Server_id End_log_pos Info
73 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
74 slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
75 slave-bin.000001 # Query # # COMMIT
76 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
77 ******** [slave] SHOW BINLOG EVENTS ********
78 include/show_events.inc
79 Log_name Pos Event_type Server_id End_log_pos Info
80 slave-bin.000001 # Gtid # # GTID #-#-#
81 slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
82 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
83 slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
84 slave-bin.000001 # Query # # COMMIT
85 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
86 slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
87 slave-bin.000001 # Query # # COMMIT
88 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
89 slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
90 slave-bin.000001 # Query # # COMMIT
91 ******** [slave] SHOW RELAYLOG EVENTS IN <FILE> ********
92 include/show_events.inc
93 Log_name Pos Event_type Server_id End_log_pos Info
94 slave-relay-bin.000002 # Rotate # # master-bin.000001;pos=POS
95 slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
96 slave-relay-bin.000002 # Gtid_list # # []
97 slave-relay-bin.000002 # Binlog_checkpoint # # master-bin.000001
98 slave-relay-bin.000002 # Gtid # # GTID #-#-#
99 slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a INT)
100 slave-relay-bin.000002 # Gtid # # BEGIN GTID #-#-#
101 slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (1)
102 slave-relay-bin.000002 # Query # # COMMIT
103 slave-relay-bin.000002 # Gtid # # BEGIN GTID #-#-#
104 slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (2)
105 slave-relay-bin.000002 # Query # # COMMIT
106 slave-relay-bin.000002 # Gtid # # BEGIN GTID #-#-#
107 slave-relay-bin.000002 # Query # # use `test`; INSERT INTO t1 VALUES (3)
108 slave-relay-bin.000002 # Query # # COMMIT
109 ******** [slave] SHOW RELAYLOG EVENTS IN <FILE> LIMIT 2 ********
110 include/show_events.inc
111 Log_name Pos Event_type Server_id End_log_pos Info
112 slave-relay-bin.000002 # Rotate # # master-bin.000001;pos=POS
113 slave-relay-bin.000002 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
114 ******** [slave] SHOW RELAYLOG EVENTS IN <FILE> LIMIT 2,4 ********
115 include/show_events.inc
116 Log_name Pos Event_type Server_id End_log_pos Info
117 slave-relay-bin.000002 # Gtid_list # # []
118 slave-relay-bin.000002 # Binlog_checkpoint # # master-bin.000001
119 slave-relay-bin.000002 # Gtid # # GTID #-#-#
120 slave-relay-bin.000002 # Query # # use `test`; CREATE TABLE t1 (a INT)
121 ******** [slave] SHOW RELAYLOG EVENTS ********
122 include/show_events.inc
123 Log_name Pos Event_type Server_id End_log_pos Info
124 slave-relay-bin.000001 # Rotate # # slave-relay-bin.000002;pos=POS
125 FLUSH LOGS;
126 connection master;
127 FLUSH LOGS;
128 DROP TABLE t1;
129 ******** [master] SHOW BINLOG EVENTS IN <FILE> ********
130 include/show_events.inc
131 Log_name Pos Event_type Server_id End_log_pos Info
132 master-bin.000002 # Binlog_checkpoint # # master-bin.000002
133 master-bin.000002 # Gtid # # GTID #-#-#
134 master-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
135 ******** [master] SHOW BINLOG EVENTS IN <FILE> LIMIT 2 ********
136 include/show_events.inc
137 Log_name Pos Event_type Server_id End_log_pos Info
138 master-bin.000002 # Binlog_checkpoint # # master-bin.000002
139 master-bin.000002 # Gtid # # GTID #-#-#
140 ******** [master] SHOW BINLOG EVENTS IN <FILE> LIMIT 2,4 ********
141 include/show_events.inc
142 Log_name Pos Event_type Server_id End_log_pos Info
143 master-bin.000002 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
144 ******** [master] SHOW BINLOG EVENTS ********
145 include/show_events.inc
146 Log_name Pos Event_type Server_id End_log_pos Info
147 master-bin.000001 # Gtid # # GTID #-#-#
148 master-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
149 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
150 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
151 master-bin.000001 # Query # # COMMIT
152 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
153 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
154 master-bin.000001 # Query # # COMMIT
155 master-bin.000001 # Gtid # # BEGIN GTID #-#-#
156 master-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
157 master-bin.000001 # Query # # COMMIT
158 master-bin.000001 # Rotate # # master-bin.000002;pos=POS
159 connection slave;
160 ******** [slave] SHOW BINLOG EVENTS IN <FILE> ********
161 include/show_events.inc
162 Log_name Pos Event_type Server_id End_log_pos Info
163 slave-bin.000002 # Binlog_checkpoint # # slave-bin.000002
164 slave-bin.000002 # Gtid # # GTID #-#-#
165 slave-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */
166 ******** [slave] SHOW BINLOG EVENTS IN <FILE> LIMIT 2 ********
167 include/show_events.inc
168 Log_name Pos Event_type Server_id End_log_pos Info
169 slave-bin.000002 # Binlog_checkpoint # # slave-bin.000002
170 slave-bin.000002 # Gtid # # GTID #-#-#
171 ******** [slave] SHOW BINLOG EVENTS IN <FILE> LIMIT 2,4 ********
172 include/show_events.inc
173 Log_name Pos Event_type Server_id End_log_pos Info
174 slave-bin.000002 # Query # # use `test`; DROP TABLE IF EXISTS `t1` /* generated by server */
175 ******** [slave] SHOW BINLOG EVENTS ********
176 include/show_events.inc
177 Log_name Pos Event_type Server_id End_log_pos Info
178 slave-bin.000001 # Gtid # # GTID #-#-#
179 slave-bin.000001 # Query # # use `test`; CREATE TABLE t1 (a INT)
180 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
181 slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (1)
182 slave-bin.000001 # Query # # COMMIT
183 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
184 slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (2)
185 slave-bin.000001 # Query # # COMMIT
186 slave-bin.000001 # Gtid # # BEGIN GTID #-#-#
187 slave-bin.000001 # Query # # use `test`; INSERT INTO t1 VALUES (3)
188 slave-bin.000001 # Query # # COMMIT
189 slave-bin.000001 # Rotate # # slave-bin.000002;pos=POS
190 ******** [slave] SHOW RELAYLOG EVENTS IN <FILE> ********
191 include/show_events.inc
192 Log_name Pos Event_type Server_id End_log_pos Info
193 slave-relay-bin.000005 # Rotate # # master-bin.000002;pos=POS
194 slave-relay-bin.000005 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
195 slave-relay-bin.000005 # Gtid_list # # [#-#-#]
196 slave-relay-bin.000005 # Binlog_checkpoint # # master-bin.000001
197 slave-relay-bin.000005 # Binlog_checkpoint # # master-bin.000002
198 slave-relay-bin.000005 # Gtid # # GTID #-#-#
199 slave-relay-bin.000005 # Query # # use `test`; DROP TABLE `t1` /* generated by server */
200 ******** [slave] SHOW RELAYLOG EVENTS IN <FILE> LIMIT 2 ********
201 include/show_events.inc
202 Log_name Pos Event_type Server_id End_log_pos Info
203 slave-relay-bin.000005 # Rotate # # master-bin.000002;pos=POS
204 slave-relay-bin.000005 # Format_desc # # SERVER_VERSION, BINLOG_VERSION
205 ******** [slave] SHOW RELAYLOG EVENTS IN <FILE> LIMIT 2,4 ********
206 include/show_events.inc
207 Log_name Pos Event_type Server_id End_log_pos Info
208 slave-relay-bin.000005 # Gtid_list # # [#-#-#]
209 slave-relay-bin.000005 # Binlog_checkpoint # # master-bin.000001
210 slave-relay-bin.000005 # Binlog_checkpoint # # master-bin.000002
211 slave-relay-bin.000005 # Gtid # # GTID #-#-#
212 ******** [slave] SHOW RELAYLOG EVENTS ********
213 include/show_events.inc
214 Log_name Pos Event_type Server_id End_log_pos Info
215 slave-relay-bin.000004 # Rotate # # master-bin.000002;pos=POS
216 slave-relay-bin.000004 # Rotate # # slave-relay-bin.000005;pos=POS
217 include/rpl_end.inc