Debian Codegraph @

mysql-test/suite/rpl_gtid/r/rpl_sync_relay_log_info_myisam.result

raw
1 include/master-slave.inc
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 master]
6 CALL mtr.add_suppression('Duplicate entry');
7 [connection slave]
8 SET @saved_sync_relay_log_info= @@GLOBAL.sync_relay_log_info;
9 Warnings:
10 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
11 #
12 # sync_relay_log_info= 0, non-transactional (MyISAM) storage engine
13 #
14 SET @@GLOBAL.sync_relay_log_info= 0;
15 Warnings:
16 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
17 [connection master]
18 include/sync_slave_sql_with_master.inc
19 include/stop_slave.inc
20 include/gtid_step_reset.inc
21 [connection master]
22 [connection slave]
23 Wait until (MYISAM, sync_rli=0, step=1) SQL thread synced master binlog file
24 Wait until (MYISAM, sync_rli=0, step=1) SQL thread synced master binlog position
25 include/gtid_step_assert.inc [count=0, only_count=0]
26 include/start_slave.inc
27 [connection master]
28 CREATE TABLE t1 (c1 int PRIMARY KEY) ENGINE=MyISAM;
29 include/sync_slave_io_with_master.inc
30 [connection master]
31 [connection slave]
32 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
33 include/assert.inc [(MYISAM, sync_rli=0, step=2) SQL thread did not synced master binlog file]
34 include/assert.inc [(MYISAM, sync_rli=0, step=2) SQL thread did not synced master binlog position]
35 include/gtid_step_assert.inc [count=1, only_count=0]
36 [connection master]
37 INSERT INTO t1 VALUES (1);
38 include/sync_slave_io_with_master.inc
39 [connection master]
40 [connection slave]
41 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
42 include/assert.inc [(MYISAM, sync_rli=0, step=3) SQL thread did not synced master binlog file]
43 include/assert.inc [(MYISAM, sync_rli=0, step=3) SQL thread did not synced master binlog position]
44 include/gtid_step_assert.inc [count=1, only_count=0]
45 [connection master]
46 FLUSH LOCAL BINARY LOGS;
47 include/sync_slave_io_with_master.inc
48 [connection master]
49 [connection slave]
50 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
51 Wait until (MYISAM, sync_rli=0, step=4) SQL thread synced master binlog file
52 Wait until (MYISAM, sync_rli=0, step=4) SQL thread synced master binlog position
53 include/gtid_step_assert.inc [count=0, only_count=0]
54 [connection master]
55 DROP TABLE t1;
56 include/sync_slave_io_with_master.inc
57 [connection master]
58 [connection slave]
59 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
60 include/assert.inc [(MYISAM, sync_rli=0, step=5) SQL thread did not synced master binlog file]
61 include/assert.inc [(MYISAM, sync_rli=0, step=5) SQL thread did not synced master binlog position]
62 include/gtid_step_assert.inc [count=1, only_count=0]
63 include/stop_slave.inc
64 include/start_slave_sql.inc
65 [connection master]
66 [connection slave]
67 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
68 Wait until (MYISAM, sync_rli=0, step=6) SQL thread synced master binlog file
69 Wait until (MYISAM, sync_rli=0, step=6) SQL thread synced master binlog position
70 include/gtid_step_assert.inc [count=0, only_count=0]
71 [connection master]
72 CREATE TABLE t1 (c1 int PRIMARY KEY) ENGINE=MyISAM;
73 [connection slave]
74 include/rpl_receive_event_count.inc [hang after 1 Gtid event]
75 [connection master]
76 [connection slave]
77 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
78 include/assert.inc [(MYISAM, sync_rli=0, step=7) SQL thread did not synced master binlog file]
79 include/assert.inc [(MYISAM, sync_rli=0, step=7) SQL thread did not synced master binlog position]
80 include/gtid_step_assert.inc [count=0, only_count=0]
81 FLUSH LOCAL RELAY LOGS;
82 [connection master]
83 [connection slave]
84 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
85 include/assert.inc [(MYISAM, sync_rli=0, step=8) SQL thread did not synced master binlog file]
86 include/assert.inc [(MYISAM, sync_rli=0, step=8) SQL thread did not synced master binlog position]
87 include/gtid_step_assert.inc [count=0, only_count=0]
88 SET DEBUG_SYNC= 'now SIGNAL continue_after_queue_event';
89 [connection master]
90 include/sync_slave_io_with_master.inc
91 [connection master]
92 [connection slave]
93 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
94 Wait until (MYISAM, sync_rli=0, step=9) SQL thread synced master binlog file
95 Wait until (MYISAM, sync_rli=0, step=9) SQL thread synced master binlog position
96 include/gtid_step_assert.inc [count=1, only_count=0]
97 include/stop_slave.inc
98 include/start_slave_sql.inc
99 [connection master]
100 [connection slave]
101 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
102 Wait until (MYISAM, sync_rli=0, step=10) SQL thread synced master binlog file
103 Wait until (MYISAM, sync_rli=0, step=10) SQL thread synced master binlog position
104 include/gtid_step_assert.inc [count=0, only_count=0]
105 [connection master]
106 INSERT INTO t1 VALUES (2);
107 [connection slave]
108 include/rpl_receive_event_count.inc [hang after 1 Gtid event]
109 [connection master]
110 [connection slave]
111 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
112 include/assert.inc [(MYISAM, sync_rli=0, step=11) SQL thread did not synced master binlog file]
113 include/assert.inc [(MYISAM, sync_rli=0, step=11) SQL thread did not synced master binlog position]
114 include/gtid_step_assert.inc [count=0, only_count=0]
115 FLUSH LOCAL RELAY LOGS;
116 [connection master]
117 [connection slave]
118 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
119 include/assert.inc [(MYISAM, sync_rli=0, step=12) SQL thread did not synced master binlog file]
120 include/assert.inc [(MYISAM, sync_rli=0, step=12) SQL thread did not synced master binlog position]
121 include/gtid_step_assert.inc [count=0, only_count=0]
122 SET DEBUG_SYNC= 'now SIGNAL continue_after_queue_event';
123 [connection master]
124 include/sync_slave_io_with_master.inc
125 [connection master]
126 [connection slave]
127 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
128 Wait until (MYISAM, sync_rli=0, step=13) SQL thread synced master binlog file
129 Wait until (MYISAM, sync_rli=0, step=13) SQL thread synced master binlog position
130 include/gtid_step_assert.inc [count=1, only_count=0]
131 include/stop_slave.inc
132 include/start_slave_sql.inc
133 [connection master]
134 [connection slave]
135 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
136 Wait until (MYISAM, sync_rli=0, step=14) SQL thread synced master binlog file
137 Wait until (MYISAM, sync_rli=0, step=14) SQL thread synced master binlog position
138 include/gtid_step_assert.inc [count=0, only_count=0]
139 [connection master]
140 SET @v=3;
141 INSERT INTO t1 VALUES (@v);
142 [connection slave]
143 include/rpl_receive_event_count.inc [hang after 1 User var event]
144 [connection master]
145 [connection slave]
146 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
147 include/assert.inc [(MYISAM, sync_rli=0, step=15) SQL thread did not synced master binlog file]
148 include/assert.inc [(MYISAM, sync_rli=0, step=15) SQL thread did not synced master binlog position]
149 include/gtid_step_assert.inc [count=0, only_count=0]
150 FLUSH LOCAL RELAY LOGS;
151 [connection master]
152 [connection slave]
153 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
154 include/assert.inc [(MYISAM, sync_rli=0, step=16) SQL thread did not synced master binlog file]
155 include/assert.inc [(MYISAM, sync_rli=0, step=16) SQL thread did not synced master binlog position]
156 include/gtid_step_assert.inc [count=0, only_count=0]
157 SET DEBUG_SYNC= 'now SIGNAL continue_after_queue_event';
158 [connection master]
159 include/sync_slave_io_with_master.inc
160 [connection master]
161 [connection slave]
162 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
163 Wait until (MYISAM, sync_rli=0, step=17) SQL thread synced master binlog file
164 Wait until (MYISAM, sync_rli=0, step=17) SQL thread synced master binlog position
165 include/gtid_step_assert.inc [count=1, only_count=0]
166 [connection master]
167 DROP TABLE t1;
168 include/sync_slave_io_with_master.inc
169 [connection master]
170 [connection slave]
171 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
172 include/assert.inc [(MYISAM, sync_rli=0, step=18) SQL thread did not synced master binlog file]
173 include/assert.inc [(MYISAM, sync_rli=0, step=18) SQL thread did not synced master binlog position]
174 include/gtid_step_assert.inc [count=1, only_count=0]
175 #
176 # sync_relay_log_info= 1, non-transactional (MyISAM) storage engine
177 #
178 SET @@GLOBAL.sync_relay_log_info= 1;
179 Warnings:
180 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
181 [connection master]
182 include/sync_slave_sql_with_master.inc
183 include/stop_slave.inc
184 include/gtid_step_reset.inc
185 [connection master]
186 [connection slave]
187 Wait until (MYISAM, sync_rli=1, step=1) SQL thread synced master binlog file
188 Wait until (MYISAM, sync_rli=1, step=1) SQL thread synced master binlog position
189 include/gtid_step_assert.inc [count=0, only_count=0]
190 include/start_slave.inc
191 [connection master]
192 CREATE TABLE t1 (c1 int PRIMARY KEY) ENGINE=MyISAM;
193 include/sync_slave_io_with_master.inc
194 [connection master]
195 [connection slave]
196 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
197 Wait until (MYISAM, sync_rli=1, step=2) SQL thread synced master binlog file
198 Wait until (MYISAM, sync_rli=1, step=2) SQL thread synced master binlog position
199 include/gtid_step_assert.inc [count=1, only_count=0]
200 [connection master]
201 INSERT INTO t1 VALUES (1);
202 include/sync_slave_io_with_master.inc
203 [connection master]
204 [connection slave]
205 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
206 Wait until (MYISAM, sync_rli=1, step=3) SQL thread synced master binlog file
207 Wait until (MYISAM, sync_rli=1, step=3) SQL thread synced master binlog position
208 include/gtid_step_assert.inc [count=1, only_count=0]
209 [connection master]
210 FLUSH LOCAL BINARY LOGS;
211 include/sync_slave_io_with_master.inc
212 [connection master]
213 [connection slave]
214 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
215 Wait until (MYISAM, sync_rli=1, step=4) SQL thread synced master binlog file
216 Wait until (MYISAM, sync_rli=1, step=4) SQL thread synced master binlog position
217 include/gtid_step_assert.inc [count=0, only_count=0]
218 [connection master]
219 DROP TABLE t1;
220 include/sync_slave_io_with_master.inc
221 [connection master]
222 [connection slave]
223 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
224 Wait until (MYISAM, sync_rli=1, step=5) SQL thread synced master binlog file
225 Wait until (MYISAM, sync_rli=1, step=5) SQL thread synced master binlog position
226 include/gtid_step_assert.inc [count=1, only_count=0]
227 include/stop_slave.inc
228 include/start_slave_sql.inc
229 [connection master]
230 [connection slave]
231 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
232 Wait until (MYISAM, sync_rli=1, step=6) SQL thread synced master binlog file
233 Wait until (MYISAM, sync_rli=1, step=6) SQL thread synced master binlog position
234 include/gtid_step_assert.inc [count=0, only_count=0]
235 [connection master]
236 CREATE TABLE t1 (c1 int PRIMARY KEY) ENGINE=MyISAM;
237 [connection slave]
238 include/rpl_receive_event_count.inc [hang after 1 Gtid event]
239 [connection master]
240 [connection slave]
241 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
242 include/assert.inc [(MYISAM, sync_rli=1, step=7) SQL thread did not synced master binlog file]
243 include/assert.inc [(MYISAM, sync_rli=1, step=7) SQL thread did not synced master binlog position]
244 include/gtid_step_assert.inc [count=0, only_count=0]
245 FLUSH LOCAL RELAY LOGS;
246 [connection master]
247 [connection slave]
248 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
249 include/assert.inc [(MYISAM, sync_rli=1, step=8) SQL thread did not synced master binlog file]
250 include/assert.inc [(MYISAM, sync_rli=1, step=8) SQL thread did not synced master binlog position]
251 include/gtid_step_assert.inc [count=0, only_count=0]
252 SET DEBUG_SYNC= 'now SIGNAL continue_after_queue_event';
253 [connection master]
254 include/sync_slave_io_with_master.inc
255 [connection master]
256 [connection slave]
257 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
258 Wait until (MYISAM, sync_rli=1, step=9) SQL thread synced master binlog file
259 Wait until (MYISAM, sync_rli=1, step=9) SQL thread synced master binlog position
260 include/gtid_step_assert.inc [count=1, only_count=0]
261 include/stop_slave.inc
262 include/start_slave_sql.inc
263 [connection master]
264 [connection slave]
265 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
266 Wait until (MYISAM, sync_rli=1, step=10) SQL thread synced master binlog file
267 Wait until (MYISAM, sync_rli=1, step=10) SQL thread synced master binlog position
268 include/gtid_step_assert.inc [count=0, only_count=0]
269 [connection master]
270 INSERT INTO t1 VALUES (2);
271 [connection slave]
272 include/rpl_receive_event_count.inc [hang after 1 Gtid event]
273 [connection master]
274 [connection slave]
275 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
276 include/assert.inc [(MYISAM, sync_rli=1, step=11) SQL thread did not synced master binlog file]
277 include/assert.inc [(MYISAM, sync_rli=1, step=11) SQL thread did not synced master binlog position]
278 include/gtid_step_assert.inc [count=0, only_count=0]
279 FLUSH LOCAL RELAY LOGS;
280 [connection master]
281 [connection slave]
282 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
283 include/assert.inc [(MYISAM, sync_rli=1, step=12) SQL thread did not synced master binlog file]
284 include/assert.inc [(MYISAM, sync_rli=1, step=12) SQL thread did not synced master binlog position]
285 include/gtid_step_assert.inc [count=0, only_count=0]
286 SET DEBUG_SYNC= 'now SIGNAL continue_after_queue_event';
287 [connection master]
288 include/sync_slave_io_with_master.inc
289 [connection master]
290 [connection slave]
291 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
292 Wait until (MYISAM, sync_rli=1, step=13) SQL thread synced master binlog file
293 Wait until (MYISAM, sync_rli=1, step=13) SQL thread synced master binlog position
294 include/gtid_step_assert.inc [count=1, only_count=0]
295 include/stop_slave.inc
296 include/start_slave_sql.inc
297 [connection master]
298 [connection slave]
299 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
300 Wait until (MYISAM, sync_rli=1, step=14) SQL thread synced master binlog file
301 Wait until (MYISAM, sync_rli=1, step=14) SQL thread synced master binlog position
302 include/gtid_step_assert.inc [count=0, only_count=0]
303 [connection master]
304 SET @v=3;
305 INSERT INTO t1 VALUES (@v);
306 [connection slave]
307 include/rpl_receive_event_count.inc [hang after 1 User var event]
308 [connection master]
309 [connection slave]
310 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
311 include/assert.inc [(MYISAM, sync_rli=1, step=15) SQL thread did not synced master binlog file]
312 include/assert.inc [(MYISAM, sync_rli=1, step=15) SQL thread did not synced master binlog position]
313 include/gtid_step_assert.inc [count=0, only_count=0]
314 FLUSH LOCAL RELAY LOGS;
315 [connection master]
316 [connection slave]
317 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
318 include/assert.inc [(MYISAM, sync_rli=1, step=16) SQL thread did not synced master binlog file]
319 include/assert.inc [(MYISAM, sync_rli=1, step=16) SQL thread did not synced master binlog position]
320 include/gtid_step_assert.inc [count=0, only_count=0]
321 SET DEBUG_SYNC= 'now SIGNAL continue_after_queue_event';
322 [connection master]
323 include/sync_slave_io_with_master.inc
324 [connection master]
325 [connection slave]
326 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
327 Wait until (MYISAM, sync_rli=1, step=17) SQL thread synced master binlog file
328 Wait until (MYISAM, sync_rli=1, step=17) SQL thread synced master binlog position
329 include/gtid_step_assert.inc [count=1, only_count=0]
330 [connection master]
331 DROP TABLE t1;
332 include/sync_slave_io_with_master.inc
333 [connection master]
334 [connection slave]
335 include/wait_for_slave_param.inc [Slave_SQL_Running_State]
336 Wait until (MYISAM, sync_rli=1, step=18) SQL thread synced master binlog file
337 Wait until (MYISAM, sync_rli=1, step=18) SQL thread synced master binlog position
338 include/gtid_step_assert.inc [count=1, only_count=0]
339 [connection slave]
340 SET @@GLOBAL.sync_relay_log_info= @saved_sync_relay_log_info;
341 Warnings:
342 Warning 1287 '@@sync_relay_log_info' is deprecated and will be removed in a future release.
343 include/rpl_end.inc