Debian Codegraph @

mysql-test/suite/rpl/r/rpl_atomic_ddl.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 [connection slave]
7 call mtr.add_suppression("Operation CREATE USER failed");
8 call mtr.add_suppression("Operation RENAME USER failed");
9 call mtr.add_suppression("The replica coordinator and worker threads are stopped");
10 call mtr.add_suppression("Replica worker thread has failed to apply an event");
11 call mtr.add_suppression("Error writing relay log configuration");
12 call mtr.add_suppression("Error 'Unknown error' on query");
13 [connection master]
14 CREATE DATABASE master_db;
15 USE master_db;
16 CREATE TABLE IF NOT EXISTS t_checks (id INT AUTO_INCREMENT NOT NULL PRIMARY KEY, ddl_query TEXT, pre_binlog_check TEXT, post_binlog_check TEXT);;
17 USE test;
18 CREATE TABLE t_1 (a int);
19 include/sync_slave_sql_with_master.inc
20 include/stop_slave_sql.inc
21 [connection master]
22 include/gtid_step_reset.inc
23 FLUSH LOGS;
24 CREATE USER user1 IDENTIFIED WITH 'mysql_native_password';
25 include/gtid_step_assert.inc [count=1, only_count=0]
26 include/gtid_step_reset.inc
27 FLUSH LOGS;
28 GRANT SELECT ON *.* TO user1;
29 include/gtid_step_assert.inc [count=1, only_count=0]
30 include/gtid_step_reset.inc
31 FLUSH LOGS;
32 REVOKE SELECT ON *.* FROM user1;
33 include/gtid_step_assert.inc [count=1, only_count=0]
34 include/gtid_step_reset.inc
35 FLUSH LOGS;
36 ALTER USER user1 IDENTIFIED BY '123456';
37 include/gtid_step_assert.inc [count=1, only_count=0]
38 include/gtid_step_reset.inc
39 FLUSH LOGS;
40 SET PASSWORD FOR user1='abcdef';
41 include/gtid_step_assert.inc [count=1, only_count=0]
42 include/gtid_step_reset.inc
43 FLUSH LOGS;
44 RENAME USER user1 TO user2;
45 include/gtid_step_assert.inc [count=1, only_count=0]
46 include/gtid_step_reset.inc
47 FLUSH LOGS;
48 CREATE ROLE roleA,roleB;
49 include/gtid_step_assert.inc [count=1, only_count=0]
50 include/gtid_step_reset.inc
51 FLUSH LOGS;
52 GRANT roleA TO roleB;
53 include/gtid_step_assert.inc [count=1, only_count=0]
54 include/gtid_step_reset.inc
55 FLUSH LOGS;
56 REVOKE roleA FROM roleB;
57 include/gtid_step_assert.inc [count=1, only_count=0]
58 include/gtid_step_reset.inc
59 FLUSH LOGS;
60 GRANT roleA TO user2;
61 include/gtid_step_assert.inc [count=1, only_count=0]
62 include/gtid_step_reset.inc
63 FLUSH LOGS;
64 ALTER USER user2 DEFAULT ROLE roleA;;
65 include/gtid_step_assert.inc [count=1, only_count=0]
66 include/gtid_step_reset.inc
67 FLUSH LOGS;
68 DROP ROLE roleA,roleB;
69 include/gtid_step_assert.inc [count=1, only_count=0]
70 include/gtid_step_reset.inc
71 FLUSH LOGS;
72 DROP USER user2;
73 include/gtid_step_assert.inc [count=1, only_count=0]
74 PREPARE stmt FROM 'CREATE USER user3';
75 DEALLOCATE PREPARE stmt;
76 PREPARE stmt FROM 'DROP USER user3';
77 DEALLOCATE PREPARE stmt;
78 include/gtid_step_reset.inc
79 FLUSH LOGS;
80 CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1;
81 include/gtid_step_assert.inc [count=1, only_count=0]
82 include/gtid_step_reset.inc
83 FLUSH LOGS;
84 DROP TRIGGER tr_0;
85 include/gtid_step_assert.inc [count=1, only_count=0]
86 include/gtid_step_reset.inc
87 FLUSH LOGS;
88 CREATE FUNCTION f_0() RETURNS INT RETURN 5;;
89 include/gtid_step_assert.inc [count=1, only_count=0]
90 include/gtid_step_reset.inc
91 FLUSH LOGS;
92 ALTER FUNCTION f_0 COMMENT 'comment';
93 include/gtid_step_assert.inc [count=1, only_count=0]
94 include/gtid_step_reset.inc
95 FLUSH LOGS;
96 DROP FUNCTION f_0;
97 include/gtid_step_assert.inc [count=1, only_count=0]
98 include/gtid_step_reset.inc
99 FLUSH LOGS;
100 CREATE PROCEDURE p_0() BEGIN END;
101 include/gtid_step_assert.inc [count=1, only_count=0]
102 include/gtid_step_reset.inc
103 FLUSH LOGS;
104 ALTER PROCEDURE p_0 COMMENT 'comment';
105 include/gtid_step_assert.inc [count=1, only_count=0]
106 include/gtid_step_reset.inc
107 FLUSH LOGS;
108 DROP PROCEDURE p_0;
109 include/gtid_step_assert.inc [count=1, only_count=0]
110 include/gtid_step_reset.inc
111 FLUSH LOGS;
112 CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2;
113 include/gtid_step_assert.inc [count=1, only_count=0]
114 include/gtid_step_reset.inc
115 FLUSH LOGS;
116 ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;;
117 include/gtid_step_assert.inc [count=1, only_count=0]
118 include/gtid_step_reset.inc
119 FLUSH LOGS;
120 DROP EVENT e_0;
121 include/gtid_step_assert.inc [count=1, only_count=0]
122 include/gtid_step_reset.inc
123 FLUSH LOGS;
124 CREATE VIEW v_0 AS SELECT * FROM t_1;
125 include/gtid_step_assert.inc [count=1, only_count=0]
126 include/gtid_step_reset.inc
127 FLUSH LOGS;
128 ALTER VIEW v_0 AS SELECT * FROM t_1;
129 include/gtid_step_assert.inc [count=1, only_count=0]
130 include/gtid_step_reset.inc
131 FLUSH LOGS;
132 DROP VIEW v_0;
133 include/gtid_step_assert.inc [count=1, only_count=0]
134 include/gtid_step_reset.inc
135 FLUSH LOGS;
136 CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB';
137 include/gtid_step_assert.inc [count=1, only_count=0]
138 include/gtid_step_reset.inc
139 FLUSH LOGS;
140 DROP FUNCTION metaphon;;
141 include/gtid_step_assert.inc [count=1, only_count=0]
142 include/gtid_step_reset.inc
143 FLUSH LOGS;
144 CREATE TABLE test.t1(a int);
145 include/gtid_step_assert.inc [count=1, only_count=0]
146 include/gtid_step_reset.inc
147 FLUSH LOGS;
148 ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);;
149 include/gtid_step_assert.inc [count=1, only_count=0]
150 include/gtid_step_reset.inc
151 FLUSH LOGS;
152 ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);;
153 include/gtid_step_assert.inc [count=1, only_count=0]
154 include/gtid_step_reset.inc
155 FLUSH LOGS;
156 ALTER TABLE test.t1 RENAME TO test.t2;
157 include/gtid_step_assert.inc [count=1, only_count=0]
158 include/gtid_step_reset.inc
159 FLUSH LOGS;
160 ALTER TABLE test.t2 DROP COLUMN a;;
161 include/gtid_step_assert.inc [count=1, only_count=0]
162 include/gtid_step_reset.inc
163 FLUSH LOGS;
164 TRUNCATE TABLE test.t2;
165 include/gtid_step_assert.inc [count=1, only_count=0]
166 include/gtid_step_reset.inc
167 FLUSH LOGS;
168 ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);;
169 Warnings:
170 Warning 124 InnoDB rebuilding table to add column FTS_DOC_ID
171 include/gtid_step_assert.inc [count=1, only_count=0]
172 include/gtid_step_reset.inc
173 FLUSH LOGS;
174 ALTER TABLE test.t2 DROP index full_t2_idx;;
175 include/gtid_step_assert.inc [count=1, only_count=0]
176 include/gtid_step_reset.inc
177 FLUSH LOGS;
178 DROP TABLE test.t2;
179 include/gtid_step_assert.inc [count=1, only_count=0]
180 include/gtid_step_reset.inc
181 FLUSH LOGS;
182 CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd';
183 include/gtid_step_assert.inc [count=1, only_count=0]
184 include/gtid_step_reset.inc
185 FLUSH LOGS;
186 DROP TABLESPACE ts;
187 include/gtid_step_assert.inc [count=1, only_count=0]
188 include/gtid_step_reset.inc
189 FLUSH LOGS;
190 CREATE TABLE test.t1(a int);
191 include/gtid_step_assert.inc [count=1, only_count=0]
192 include/gtid_step_reset.inc
193 FLUSH LOGS;
194 CREATE TABLE test.t2 AS SELECT * FROM t1;;
195 include/gtid_step_assert.inc [count=1, only_count=0]
196 include/gtid_step_reset.inc
197 FLUSH LOGS;
198 DROP TABLE test.t1;
199 include/gtid_step_assert.inc [count=1, only_count=0]
200 include/gtid_step_reset.inc
201 FLUSH LOGS;
202 DROP TABLE test.t2;
203 include/gtid_step_assert.inc [count=1, only_count=0]
204 [connection slave]
205 include/start_slave_io.inc
206 Warnings:
207 Note 3083 Replication thread(s) for channel '' are already runnning.
208 [connection master]
209 include/sync_slave_io_with_master.inc
210 [connection slave]
211 CREATE USER user1;
212 START REPLICA SQL_THREAD;
213 include/wait_for_slave_sql_error.inc [errno=1396]
214 DROP USER user1;
215 SET @@GLOBAL.debug="+d,rli_pre_commit_error";
216 START REPLICA SQL_THREAD;
217 include/wait_for_slave_sql_error.inc [errno=1105]
218 SET @@GLOBAL.debug="-d,rli_pre_commit_error";
219 [connection master]
220 Loop: 1 out of 44; current query: 'CREATE USER user1 IDENTIFIED WITH 'mysql_native_password''; pre-binlog check: 'SELECT count(*) = 0 FROM mysql.user WHERE user = 'user1''; pre-commit check: 'SELECT count(*) = 1 FROM mysql.user WHERE user = 'user1'';
221 [connection slave]
222 *** Query: 'CREATE USER user1 IDENTIFIED WITH 'mysql_native_password''. Crash right after the query has been prepared in the engine before being logged. ***
223 SET @@GLOBAL.debug="+d,crash_commit_before_log";
224 include/gtid_step_reset.inc
225 START REPLICA SQL_THREAD;
226 include/rpl_start_server.inc [server_number=2]
227 include/gtid_step_assert.inc [count=0, only_count=0]
228 *** Query: 'CREATE USER user1 IDENTIFIED WITH 'mysql_native_password''. Crash right after the query has been binary-logged before committed in the engine. ***
229 SET @@GLOBAL.debug="+d,crash_commit_after_log";
230 include/gtid_step_reset.inc
231 START REPLICA SQL_THREAD;
232 include/rpl_start_server.inc [server_number=2]
233 [connection slave]
234 include/gtid_step_assert.inc [count=1, only_count=1]
235 [connection master]
236 Loop: 2 out of 44; current query: 'GRANT SELECT ON *.* TO user1'; pre-binlog check: 'SELECT select_priv = 'N' FROM mysql.user WHERE user = 'user1''; pre-commit check: 'SELECT select_priv = 'Y' FROM mysql.user WHERE user = 'user1'';
237 [connection slave]
238 *** Query: 'GRANT SELECT ON *.* TO user1'. Crash right after the query has been prepared in the engine before being logged. ***
239 SET @@GLOBAL.debug="+d,crash_commit_before_log";
240 include/gtid_step_reset.inc
241 START REPLICA SQL_THREAD;
242 include/rpl_start_server.inc [server_number=2]
243 include/gtid_step_assert.inc [count=0, only_count=1]
244 *** Query: 'GRANT SELECT ON *.* TO user1'. Crash right after the query has been binary-logged before committed in the engine. ***
245 SET @@GLOBAL.debug="+d,crash_commit_after_log";
246 include/gtid_step_reset.inc
247 START REPLICA SQL_THREAD;
248 include/rpl_start_server.inc [server_number=2]
249 [connection slave]
250 include/gtid_step_assert.inc [count=1, only_count=1]
251 [connection master]
252 Loop: 3 out of 44; current query: 'REVOKE SELECT ON *.* FROM user1'; pre-binlog check: 'SELECT select_priv = 'Y' FROM mysql.user WHERE user = 'user1''; pre-commit check: 'SELECT select_priv = 'N' FROM mysql.user WHERE user = 'user1'';
253 [connection slave]
254 *** Query: 'REVOKE SELECT ON *.* FROM user1'. Crash right after the query has been prepared in the engine before being logged. ***
255 SET @@GLOBAL.debug="+d,crash_commit_before_log";
256 include/gtid_step_reset.inc
257 START REPLICA SQL_THREAD;
258 include/rpl_start_server.inc [server_number=2]
259 include/gtid_step_assert.inc [count=0, only_count=1]
260 *** Query: 'REVOKE SELECT ON *.* FROM user1'. Crash right after the query has been binary-logged before committed in the engine. ***
261 SET @@GLOBAL.debug="+d,crash_commit_after_log";
262 include/gtid_step_reset.inc
263 START REPLICA SQL_THREAD;
264 include/rpl_start_server.inc [server_number=2]
265 [connection slave]
266 include/gtid_step_assert.inc [count=1, only_count=1]
267 [connection master]
268 Loop: 4 out of 44; current query: 'ALTER USER user1 IDENTIFIED BY '123456''; pre-binlog check: 'SELECT authentication_string = '' FROM mysql.user WHERE user LIKE 'user1''; pre-commit check: 'SELECT authentication_string != '' FROM mysql.user WHERE user LIKE 'user1'';
269 [connection slave]
270 *** Query: 'ALTER USER user1 IDENTIFIED BY '123456''. Crash right after the query has been prepared in the engine before being logged. ***
271 SET @@GLOBAL.debug="+d,crash_commit_before_log";
272 include/gtid_step_reset.inc
273 START REPLICA SQL_THREAD;
274 include/rpl_start_server.inc [server_number=2]
275 include/gtid_step_assert.inc [count=0, only_count=1]
276 *** Query: 'ALTER USER user1 IDENTIFIED BY '123456''. Crash right after the query has been binary-logged before committed in the engine. ***
277 SET @@GLOBAL.debug="+d,crash_commit_after_log";
278 include/gtid_step_reset.inc
279 START REPLICA SQL_THREAD;
280 include/rpl_start_server.inc [server_number=2]
281 [connection slave]
282 include/gtid_step_assert.inc [count=1, only_count=1]
283 [connection master]
284 Loop: 5 out of 44; current query: 'SET PASSWORD FOR user1='abcdef''; pre-binlog check: 'SELECT authentication_string = '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' FROM mysql.user WHERE user LIKE 'user1''; pre-commit check: 'SELECT authentication_string != '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' FROM mysql.user WHERE user LIKE 'user1'';
285 [connection slave]
286 *** Query: 'SET PASSWORD FOR user1='abcdef''. Crash right after the query has been prepared in the engine before being logged. ***
287 SET @@GLOBAL.debug="+d,crash_commit_before_log";
288 include/gtid_step_reset.inc
289 START REPLICA SQL_THREAD;
290 include/rpl_start_server.inc [server_number=2]
291 include/gtid_step_assert.inc [count=0, only_count=1]
292 *** Query: 'SET PASSWORD FOR user1='abcdef''. Crash right after the query has been binary-logged before committed in the engine. ***
293 SET @@GLOBAL.debug="+d,crash_commit_after_log";
294 include/gtid_step_reset.inc
295 START REPLICA SQL_THREAD;
296 include/rpl_start_server.inc [server_number=2]
297 [connection slave]
298 include/gtid_step_assert.inc [count=1, only_count=1]
299 [connection master]
300 Loop: 6 out of 44; current query: 'RENAME USER user1 TO user2'; pre-binlog check: 'SELECT count(*) = 1 FROM mysql.user WHERE user = 'user1''; pre-commit check: 'SELECT count(*) = 0 FROM mysql.user WHERE user = 'user1'';
301 [connection slave]
302 *** Query: 'RENAME USER user1 TO user2'. Crash right after the query has been prepared in the engine before being logged. ***
303 SET @@GLOBAL.debug="+d,crash_commit_before_log";
304 include/gtid_step_reset.inc
305 START REPLICA SQL_THREAD;
306 include/rpl_start_server.inc [server_number=2]
307 include/gtid_step_assert.inc [count=0, only_count=1]
308 *** Query: 'RENAME USER user1 TO user2'. Crash right after the query has been binary-logged before committed in the engine. ***
309 SET @@GLOBAL.debug="+d,crash_commit_after_log";
310 include/gtid_step_reset.inc
311 START REPLICA SQL_THREAD;
312 include/rpl_start_server.inc [server_number=2]
313 [connection slave]
314 include/gtid_step_assert.inc [count=1, only_count=1]
315 [connection master]
316 Loop: 7 out of 44; current query: 'CREATE ROLE roleA,roleB'; pre-binlog check: 'SELECT COUNT(*) = 0 FROM mysql.user WHERE user LIKE 'roleB' OR user LIKE 'roleA';'; pre-commit check: 'SELECT COUNT(*) = 2 FROM mysql.user WHERE user LIKE 'roleB' OR user LIKE 'roleA';';
317 [connection slave]
318 *** Query: 'CREATE ROLE roleA,roleB'. Crash right after the query has been prepared in the engine before being logged. ***
319 SET @@GLOBAL.debug="+d,crash_commit_before_log";
320 include/gtid_step_reset.inc
321 START REPLICA SQL_THREAD;
322 include/rpl_start_server.inc [server_number=2]
323 include/gtid_step_assert.inc [count=0, only_count=1]
324 *** Query: 'CREATE ROLE roleA,roleB'. Crash right after the query has been binary-logged before committed in the engine. ***
325 SET @@GLOBAL.debug="+d,crash_commit_after_log";
326 include/gtid_step_reset.inc
327 START REPLICA SQL_THREAD;
328 include/rpl_start_server.inc [server_number=2]
329 [connection slave]
330 include/gtid_step_assert.inc [count=1, only_count=1]
331 [connection master]
332 Loop: 8 out of 44; current query: 'GRANT roleA TO roleB'; pre-binlog check: 'SELECT count(*) = 0 FROM mysql.role_edges WHERE from_user = 'roleA''; pre-commit check: 'SELECT count(*) = 1 FROM mysql.role_edges WHERE from_user = 'roleA'';
333 [connection slave]
334 *** Query: 'GRANT roleA TO roleB'. Crash right after the query has been prepared in the engine before being logged. ***
335 SET @@GLOBAL.debug="+d,crash_commit_before_log";
336 include/gtid_step_reset.inc
337 START REPLICA SQL_THREAD;
338 include/rpl_start_server.inc [server_number=2]
339 include/gtid_step_assert.inc [count=0, only_count=1]
340 *** Query: 'GRANT roleA TO roleB'. Crash right after the query has been binary-logged before committed in the engine. ***
341 SET @@GLOBAL.debug="+d,crash_commit_after_log";
342 include/gtid_step_reset.inc
343 START REPLICA SQL_THREAD;
344 include/rpl_start_server.inc [server_number=2]
345 [connection slave]
346 include/gtid_step_assert.inc [count=1, only_count=1]
347 [connection master]
348 Loop: 9 out of 44; current query: 'REVOKE roleA FROM roleB'; pre-binlog check: 'SELECT count(*) = 1 FROM mysql.role_edges WHERE from_user = 'roleA''; pre-commit check: 'SELECT count(*) = 0 FROM mysql.role_edges WHERE from_user = 'roleA'';
349 [connection slave]
350 *** Query: 'REVOKE roleA FROM roleB'. Crash right after the query has been prepared in the engine before being logged. ***
351 SET @@GLOBAL.debug="+d,crash_commit_before_log";
352 include/gtid_step_reset.inc
353 START REPLICA SQL_THREAD;
354 include/rpl_start_server.inc [server_number=2]
355 include/gtid_step_assert.inc [count=0, only_count=1]
356 *** Query: 'REVOKE roleA FROM roleB'. Crash right after the query has been binary-logged before committed in the engine. ***
357 SET @@GLOBAL.debug="+d,crash_commit_after_log";
358 include/gtid_step_reset.inc
359 START REPLICA SQL_THREAD;
360 include/rpl_start_server.inc [server_number=2]
361 [connection slave]
362 include/gtid_step_assert.inc [count=1, only_count=1]
363 [connection master]
364 Loop: 10 out of 44; current query: 'GRANT roleA TO user2'; pre-binlog check: 'SELECT count(*) = 0 FROM mysql.role_edges WHERE from_user = 'roleA''; pre-commit check: 'SELECT count(*) = 1 FROM mysql.role_edges WHERE from_user = 'roleA'';
365 [connection slave]
366 *** Query: 'GRANT roleA TO user2'. Crash right after the query has been prepared in the engine before being logged. ***
367 SET @@GLOBAL.debug="+d,crash_commit_before_log";
368 include/gtid_step_reset.inc
369 START REPLICA SQL_THREAD;
370 include/rpl_start_server.inc [server_number=2]
371 include/gtid_step_assert.inc [count=0, only_count=1]
372 *** Query: 'GRANT roleA TO user2'. Crash right after the query has been binary-logged before committed in the engine. ***
373 SET @@GLOBAL.debug="+d,crash_commit_after_log";
374 include/gtid_step_reset.inc
375 START REPLICA SQL_THREAD;
376 include/rpl_start_server.inc [server_number=2]
377 [connection slave]
378 include/gtid_step_assert.inc [count=1, only_count=1]
379 [connection master]
380 Loop: 11 out of 44; current query: 'ALTER USER user2 DEFAULT ROLE roleA;'; pre-binlog check: 'SELECT count(*) = 0 FROM mysql.default_roles WHERE user = 'user2''; pre-commit check: 'SELECT count(*) = 1 FROM mysql.default_roles WHERE user = 'user2'';
381 [connection slave]
382 *** Query: 'ALTER USER user2 DEFAULT ROLE roleA;'. Crash right after the query has been prepared in the engine before being logged. ***
383 SET @@GLOBAL.debug="+d,crash_commit_before_log";
384 include/gtid_step_reset.inc
385 START REPLICA SQL_THREAD;
386 include/rpl_start_server.inc [server_number=2]
387 include/gtid_step_assert.inc [count=0, only_count=1]
388 *** Query: 'ALTER USER user2 DEFAULT ROLE roleA;'. Crash right after the query has been binary-logged before committed in the engine. ***
389 SET @@GLOBAL.debug="+d,crash_commit_after_log";
390 include/gtid_step_reset.inc
391 START REPLICA SQL_THREAD;
392 include/rpl_start_server.inc [server_number=2]
393 [connection slave]
394 include/gtid_step_assert.inc [count=1, only_count=1]
395 [connection master]
396 Loop: 12 out of 44; current query: 'DROP ROLE roleA,roleB'; pre-binlog check: 'SELECT count(*) = 2 FROM mysql.user WHERE user LIKE 'roleA' OR user LIKE 'roleB''; pre-commit check: 'SELECT count(*) = 0 FROM mysql.user WHERE user LIKE 'roleA' OR user LIKE 'roleB'';
397 [connection slave]
398 *** Query: 'DROP ROLE roleA,roleB'. Crash right after the query has been prepared in the engine before being logged. ***
399 SET @@GLOBAL.debug="+d,crash_commit_before_log";
400 include/gtid_step_reset.inc
401 START REPLICA SQL_THREAD;
402 include/rpl_start_server.inc [server_number=2]
403 include/gtid_step_assert.inc [count=0, only_count=1]
404 *** Query: 'DROP ROLE roleA,roleB'. Crash right after the query has been binary-logged before committed in the engine. ***
405 SET @@GLOBAL.debug="+d,crash_commit_after_log";
406 include/gtid_step_reset.inc
407 START REPLICA SQL_THREAD;
408 include/rpl_start_server.inc [server_number=2]
409 [connection slave]
410 include/gtid_step_assert.inc [count=1, only_count=1]
411 [connection master]
412 Loop: 13 out of 44; current query: 'DROP USER user2'; pre-binlog check: 'SELECT count(*) = 1 FROM mysql.user WHERE user = 'user2''; pre-commit check: 'SELECT count(*) = 0 FROM mysql.user WHERE user = 'user2'';
413 [connection slave]
414 *** Query: 'DROP USER user2'. Crash right after the query has been prepared in the engine before being logged. ***
415 SET @@GLOBAL.debug="+d,crash_commit_before_log";
416 include/gtid_step_reset.inc
417 START REPLICA SQL_THREAD;
418 include/rpl_start_server.inc [server_number=2]
419 include/gtid_step_assert.inc [count=0, only_count=1]
420 *** Query: 'DROP USER user2'. Crash right after the query has been binary-logged before committed in the engine. ***
421 SET @@GLOBAL.debug="+d,crash_commit_after_log";
422 include/gtid_step_reset.inc
423 START REPLICA SQL_THREAD;
424 include/rpl_start_server.inc [server_number=2]
425 [connection slave]
426 include/gtid_step_assert.inc [count=1, only_count=1]
427 [connection master]
428 Loop: 14 out of 44; current query: 'CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1'; pre-binlog check: 'SELECT count(*) = 0 FROM information_schema.TRIGGERS where TRIGGER_NAME = 'tr_0''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.TRIGGERS where TRIGGER_NAME = 'tr_0'';
429 [connection slave]
430 *** Query: 'CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1'. Crash right after the query has been prepared in the engine before being logged. ***
431 SET @@GLOBAL.debug="+d,crash_commit_before_log";
432 include/gtid_step_reset.inc
433 START REPLICA SQL_THREAD;
434 include/rpl_start_server.inc [server_number=2]
435 include/gtid_step_assert.inc [count=0, only_count=1]
436 *** Query: 'CREATE TRIGGER tr_0 BEFORE INSERT ON t_1 FOR EACH ROW SET @a:=1'. Crash right after the query has been binary-logged before committed in the engine. ***
437 SET @@GLOBAL.debug="+d,crash_commit_after_log";
438 include/gtid_step_reset.inc
439 START REPLICA SQL_THREAD;
440 include/rpl_start_server.inc [server_number=2]
441 [connection slave]
442 include/gtid_step_assert.inc [count=1, only_count=1]
443 [connection master]
444 Loop: 15 out of 44; current query: 'DROP TRIGGER tr_0'; pre-binlog check: 'SELECT count(*) = 1 FROM information_schema.TRIGGERS where TRIGGER_NAME = 'tr_0''; pre-commit check: 'SELECT count(*) = 0 FROM information_schema.TRIGGERS where TRIGGER_NAME = 'tr_0'';
445 [connection slave]
446 *** Query: 'DROP TRIGGER tr_0'. Crash right after the query has been prepared in the engine before being logged. ***
447 SET @@GLOBAL.debug="+d,crash_commit_before_log";
448 include/gtid_step_reset.inc
449 START REPLICA SQL_THREAD;
450 include/rpl_start_server.inc [server_number=2]
451 include/gtid_step_assert.inc [count=0, only_count=1]
452 *** Query: 'DROP TRIGGER tr_0'. Crash right after the query has been binary-logged before committed in the engine. ***
453 SET @@GLOBAL.debug="+d,crash_commit_after_log";
454 include/gtid_step_reset.inc
455 START REPLICA SQL_THREAD;
456 include/rpl_start_server.inc [server_number=2]
457 [connection slave]
458 include/gtid_step_assert.inc [count=1, only_count=1]
459 [connection master]
460 Loop: 16 out of 44; current query: 'CREATE FUNCTION f_0() RETURNS INT RETURN 5;'; pre-binlog check: 'SELECT count(*) = 0 FROM information_schema.ROUTINES where ROUTINE_NAME = 'f_0''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.ROUTINES where ROUTINE_NAME = 'f_0'';
461 [connection slave]
462 *** Query: 'CREATE FUNCTION f_0() RETURNS INT RETURN 5;'. Crash right after the query has been prepared in the engine before being logged. ***
463 SET @@GLOBAL.debug="+d,crash_commit_before_log";
464 include/gtid_step_reset.inc
465 START REPLICA SQL_THREAD;
466 include/rpl_start_server.inc [server_number=2]
467 include/gtid_step_assert.inc [count=0, only_count=1]
468 *** Query: 'CREATE FUNCTION f_0() RETURNS INT RETURN 5;'. Crash right after the query has been binary-logged before committed in the engine. ***
469 SET @@GLOBAL.debug="+d,crash_commit_after_log";
470 include/gtid_step_reset.inc
471 START REPLICA SQL_THREAD;
472 include/rpl_start_server.inc [server_number=2]
473 [connection slave]
474 include/gtid_step_assert.inc [count=1, only_count=1]
475 [connection master]
476 Loop: 17 out of 44; current query: 'ALTER FUNCTION f_0 COMMENT 'comment''; pre-binlog check: 'SELECT count(*) = 1 FROM information_schema.ROUTINES where ROUTINE_NAME = 'f_0''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.ROUTINES where ROUTINE_NAME = 'f_0'';
477 [connection slave]
478 *** Query: 'ALTER FUNCTION f_0 COMMENT 'comment''. Crash right after the query has been prepared in the engine before being logged. ***
479 SET @@GLOBAL.debug="+d,crash_commit_before_log";
480 include/gtid_step_reset.inc
481 START REPLICA SQL_THREAD;
482 include/rpl_start_server.inc [server_number=2]
483 include/gtid_step_assert.inc [count=0, only_count=1]
484 *** Query: 'ALTER FUNCTION f_0 COMMENT 'comment''. Crash right after the query has been binary-logged before committed in the engine. ***
485 SET @@GLOBAL.debug="+d,crash_commit_after_log";
486 include/gtid_step_reset.inc
487 START REPLICA SQL_THREAD;
488 include/rpl_start_server.inc [server_number=2]
489 [connection slave]
490 include/gtid_step_assert.inc [count=1, only_count=1]
491 [connection master]
492 Loop: 18 out of 44; current query: 'DROP FUNCTION f_0'; pre-binlog check: 'SELECT count(*) = 1 FROM information_schema.ROUTINES where ROUTINE_NAME = 'f_0''; pre-commit check: 'SELECT count(*) = 0 FROM information_schema.ROUTINES where ROUTINE_NAME = 'f_0'';
493 [connection slave]
494 *** Query: 'DROP FUNCTION f_0'. Crash right after the query has been prepared in the engine before being logged. ***
495 SET @@GLOBAL.debug="+d,crash_commit_before_log";
496 include/gtid_step_reset.inc
497 START REPLICA SQL_THREAD;
498 include/rpl_start_server.inc [server_number=2]
499 include/gtid_step_assert.inc [count=0, only_count=1]
500 *** Query: 'DROP FUNCTION f_0'. Crash right after the query has been binary-logged before committed in the engine. ***
501 SET @@GLOBAL.debug="+d,crash_commit_after_log";
502 include/gtid_step_reset.inc
503 START REPLICA SQL_THREAD;
504 include/rpl_start_server.inc [server_number=2]
505 [connection slave]
506 include/gtid_step_assert.inc [count=1, only_count=1]
507 [connection master]
508 Loop: 19 out of 44; current query: 'CREATE PROCEDURE p_0() BEGIN END'; pre-binlog check: 'SELECT count(*) = 0 FROM information_schema.ROUTINES where ROUTINE_NAME = 'p_0''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.ROUTINES where ROUTINE_NAME = 'p_0'';
509 [connection slave]
510 *** Query: 'CREATE PROCEDURE p_0() BEGIN END'. Crash right after the query has been prepared in the engine before being logged. ***
511 SET @@GLOBAL.debug="+d,crash_commit_before_log";
512 include/gtid_step_reset.inc
513 START REPLICA SQL_THREAD;
514 include/rpl_start_server.inc [server_number=2]
515 include/gtid_step_assert.inc [count=0, only_count=1]
516 *** Query: 'CREATE PROCEDURE p_0() BEGIN END'. Crash right after the query has been binary-logged before committed in the engine. ***
517 SET @@GLOBAL.debug="+d,crash_commit_after_log";
518 include/gtid_step_reset.inc
519 START REPLICA SQL_THREAD;
520 include/rpl_start_server.inc [server_number=2]
521 [connection slave]
522 include/gtid_step_assert.inc [count=1, only_count=1]
523 [connection master]
524 Loop: 20 out of 44; current query: 'ALTER PROCEDURE p_0 COMMENT 'comment''; pre-binlog check: 'SELECT count(*) = 1 FROM information_schema.ROUTINES where ROUTINE_NAME = 'p_0''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.ROUTINES where ROUTINE_NAME = 'p_0'';
525 [connection slave]
526 *** Query: 'ALTER PROCEDURE p_0 COMMENT 'comment''. Crash right after the query has been prepared in the engine before being logged. ***
527 SET @@GLOBAL.debug="+d,crash_commit_before_log";
528 include/gtid_step_reset.inc
529 START REPLICA SQL_THREAD;
530 include/rpl_start_server.inc [server_number=2]
531 include/gtid_step_assert.inc [count=0, only_count=1]
532 *** Query: 'ALTER PROCEDURE p_0 COMMENT 'comment''. Crash right after the query has been binary-logged before committed in the engine. ***
533 SET @@GLOBAL.debug="+d,crash_commit_after_log";
534 include/gtid_step_reset.inc
535 START REPLICA SQL_THREAD;
536 include/rpl_start_server.inc [server_number=2]
537 [connection slave]
538 include/gtid_step_assert.inc [count=1, only_count=1]
539 [connection master]
540 Loop: 21 out of 44; current query: 'DROP PROCEDURE p_0'; pre-binlog check: 'SELECT count(*) = 1 FROM information_schema.ROUTINES where ROUTINE_NAME = 'p_0''; pre-commit check: 'SELECT count(*) = 0 FROM information_schema.ROUTINES where ROUTINE_NAME = 'p_0'';
541 [connection slave]
542 *** Query: 'DROP PROCEDURE p_0'. Crash right after the query has been prepared in the engine before being logged. ***
543 SET @@GLOBAL.debug="+d,crash_commit_before_log";
544 include/gtid_step_reset.inc
545 START REPLICA SQL_THREAD;
546 include/rpl_start_server.inc [server_number=2]
547 include/gtid_step_assert.inc [count=0, only_count=1]
548 *** Query: 'DROP PROCEDURE p_0'. Crash right after the query has been binary-logged before committed in the engine. ***
549 SET @@GLOBAL.debug="+d,crash_commit_after_log";
550 include/gtid_step_reset.inc
551 START REPLICA SQL_THREAD;
552 include/rpl_start_server.inc [server_number=2]
553 [connection slave]
554 include/gtid_step_assert.inc [count=1, only_count=1]
555 [connection master]
556 Loop: 22 out of 44; current query: 'CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2'; pre-binlog check: 'SELECT count(*) = 0 FROM information_schema.EVENTS where EVENT_NAME = 'e_0''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.EVENTS where EVENT_NAME = 'e_0'';
557 [connection slave]
558 *** Query: 'CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2'. Crash right after the query has been prepared in the engine before being logged. ***
559 SET @@GLOBAL.debug="+d,crash_commit_before_log";
560 include/gtid_step_reset.inc
561 START REPLICA SQL_THREAD;
562 include/rpl_start_server.inc [server_number=2]
563 include/gtid_step_assert.inc [count=0, only_count=1]
564 *** Query: 'CREATE EVENT e_0 ON SCHEDULE EVERY 2 DAY DO SELECT 2'. Crash right after the query has been binary-logged before committed in the engine. ***
565 SET @@GLOBAL.debug="+d,crash_commit_after_log";
566 include/gtid_step_reset.inc
567 START REPLICA SQL_THREAD;
568 include/rpl_start_server.inc [server_number=2]
569 [connection slave]
570 include/gtid_step_assert.inc [count=1, only_count=1]
571 [connection master]
572 Loop: 23 out of 44; current query: 'ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;'; pre-binlog check: 'SELECT count(*) = 1 FROM information_schema.EVENTS where EVENT_NAME = 'e_0''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.EVENTS where EVENT_NAME = 'e_0'';
573 [connection slave]
574 *** Query: 'ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;'. Crash right after the query has been prepared in the engine before being logged. ***
575 SET @@GLOBAL.debug="+d,crash_commit_before_log";
576 include/gtid_step_reset.inc
577 START REPLICA SQL_THREAD;
578 include/rpl_start_server.inc [server_number=2]
579 include/gtid_step_assert.inc [count=0, only_count=1]
580 *** Query: 'ALTER EVENT e_0 ON SCHEDULE EVERY 2 day DO SELECT 1;'. Crash right after the query has been binary-logged before committed in the engine. ***
581 SET @@GLOBAL.debug="+d,crash_commit_after_log";
582 include/gtid_step_reset.inc
583 START REPLICA SQL_THREAD;
584 include/rpl_start_server.inc [server_number=2]
585 [connection slave]
586 include/gtid_step_assert.inc [count=1, only_count=1]
587 [connection master]
588 Loop: 24 out of 44; current query: 'DROP EVENT e_0'; pre-binlog check: 'SELECT count(*) = 1 FROM information_schema.EVENTS where EVENT_NAME = 'e_0''; pre-commit check: 'SELECT count(*) = 0 FROM information_schema.EVENTS where EVENT_NAME = 'e_0'';
589 [connection slave]
590 *** Query: 'DROP EVENT e_0'. Crash right after the query has been prepared in the engine before being logged. ***
591 SET @@GLOBAL.debug="+d,crash_commit_before_log";
592 include/gtid_step_reset.inc
593 START REPLICA SQL_THREAD;
594 include/rpl_start_server.inc [server_number=2]
595 include/gtid_step_assert.inc [count=0, only_count=1]
596 *** Query: 'DROP EVENT e_0'. Crash right after the query has been binary-logged before committed in the engine. ***
597 SET @@GLOBAL.debug="+d,crash_commit_after_log";
598 include/gtid_step_reset.inc
599 START REPLICA SQL_THREAD;
600 include/rpl_start_server.inc [server_number=2]
601 [connection slave]
602 include/gtid_step_assert.inc [count=1, only_count=1]
603 [connection master]
604 Loop: 25 out of 44; current query: 'CREATE VIEW v_0 AS SELECT * FROM t_1'; pre-binlog check: 'SELECT count(*) = 0 FROM information_schema.VIEWS where TABLE_NAME = 'v_0''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.VIEWS where TABLE_NAME = 'v_0'';
605 [connection slave]
606 *** Query: 'CREATE VIEW v_0 AS SELECT * FROM t_1'. Crash right after the query has been prepared in the engine before being logged. ***
607 SET @@GLOBAL.debug="+d,crash_commit_before_log";
608 include/gtid_step_reset.inc
609 START REPLICA SQL_THREAD;
610 include/rpl_start_server.inc [server_number=2]
611 include/gtid_step_assert.inc [count=0, only_count=1]
612 *** Query: 'CREATE VIEW v_0 AS SELECT * FROM t_1'. Crash right after the query has been binary-logged before committed in the engine. ***
613 SET @@GLOBAL.debug="+d,crash_commit_after_log";
614 include/gtid_step_reset.inc
615 START REPLICA SQL_THREAD;
616 include/rpl_start_server.inc [server_number=2]
617 [connection slave]
618 include/gtid_step_assert.inc [count=1, only_count=1]
619 [connection master]
620 Loop: 26 out of 44; current query: 'ALTER VIEW v_0 AS SELECT * FROM t_1'; pre-binlog check: 'SELECT count(*) = 1 FROM information_schema.VIEWS where TABLE_NAME = 'v_0''; pre-commit check: 'SELECT count(*) = 1 FROM information_schema.VIEWS where TABLE_NAME = 'v_0'';
621 [connection slave]
622 *** Query: 'ALTER VIEW v_0 AS SELECT * FROM t_1'. Crash right after the query has been prepared in the engine before being logged. ***
623 SET @@GLOBAL.debug="+d,crash_commit_before_log";
624 include/gtid_step_reset.inc
625 START REPLICA SQL_THREAD;
626 include/rpl_start_server.inc [server_number=2]
627 include/gtid_step_assert.inc [count=0, only_count=1]
628 *** Query: 'ALTER VIEW v_0 AS SELECT * FROM t_1'. Crash right after the query has been binary-logged before committed in the engine. ***
629 SET @@GLOBAL.debug="+d,crash_commit_after_log";
630 include/gtid_step_reset.inc
631 START REPLICA SQL_THREAD;
632 include/rpl_start_server.inc [server_number=2]
633 [connection slave]
634 include/gtid_step_assert.inc [count=1, only_count=1]
635 [connection master]
636 Loop: 27 out of 44; current query: 'DROP VIEW v_0'; pre-binlog check: 'SELECT count(*) = 1 FROM information_schema.VIEWS where TABLE_NAME = 'v_0''; pre-commit check: 'SELECT count(*) = 0 FROM information_schema.VIEWS where TABLE_NAME = 'v_0'';
637 [connection slave]
638 *** Query: 'DROP VIEW v_0'. Crash right after the query has been prepared in the engine before being logged. ***
639 SET @@GLOBAL.debug="+d,crash_commit_before_log";
640 include/gtid_step_reset.inc
641 START REPLICA SQL_THREAD;
642 include/rpl_start_server.inc [server_number=2]
643 include/gtid_step_assert.inc [count=0, only_count=1]
644 *** Query: 'DROP VIEW v_0'. Crash right after the query has been binary-logged before committed in the engine. ***
645 SET @@GLOBAL.debug="+d,crash_commit_after_log";
646 include/gtid_step_reset.inc
647 START REPLICA SQL_THREAD;
648 include/rpl_start_server.inc [server_number=2]
649 [connection slave]
650 include/gtid_step_assert.inc [count=1, only_count=1]
651 [connection master]
652 Loop: 28 out of 44; current query: 'CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB''; pre-binlog check: 'SELECT count(*) = 0 FROM mysql.func where NAME = 'metaphon''; pre-commit check: 'SELECT count(*) = 1 FROM mysql.func where NAME = 'metaphon'';
653 [connection slave]
654 *** Query: 'CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB''. Crash right after the query has been prepared in the engine before being logged. ***
655 SET @@GLOBAL.debug="+d,crash_commit_before_log";
656 include/gtid_step_reset.inc
657 START REPLICA SQL_THREAD;
658 include/rpl_start_server.inc [server_number=2]
659 include/gtid_step_assert.inc [count=0, only_count=1]
660 *** Query: 'CREATE FUNCTION metaphon RETURNS STRING SONAME 'udf_example_LIB''. Crash right after the query has been binary-logged before committed in the engine. ***
661 SET @@GLOBAL.debug="+d,crash_commit_after_log";
662 include/gtid_step_reset.inc
663 START REPLICA SQL_THREAD;
664 include/rpl_start_server.inc [server_number=2]
665 [connection slave]
666 include/gtid_step_assert.inc [count=1, only_count=1]
667 [connection master]
668 Loop: 29 out of 44; current query: 'DROP FUNCTION metaphon;'; pre-binlog check: 'SELECT count(*) = 1 FROM mysql.func where NAME = 'metaphon''; pre-commit check: 'SELECT count(*) = 0 FROM mysql.func where NAME = 'metaphon'';
669 [connection slave]
670 *** Query: 'DROP FUNCTION metaphon;'. Crash right after the query has been prepared in the engine before being logged. ***
671 SET @@GLOBAL.debug="+d,crash_commit_before_log";
672 include/gtid_step_reset.inc
673 START REPLICA SQL_THREAD;
674 include/rpl_start_server.inc [server_number=2]
675 include/gtid_step_assert.inc [count=0, only_count=1]
676 *** Query: 'DROP FUNCTION metaphon;'. Crash right after the query has been binary-logged before committed in the engine. ***
677 SET @@GLOBAL.debug="+d,crash_commit_after_log";
678 include/gtid_step_reset.inc
679 START REPLICA SQL_THREAD;
680 include/rpl_start_server.inc [server_number=2]
681 [connection slave]
682 include/gtid_step_assert.inc [count=1, only_count=1]
683 [connection master]
684 Loop: 30 out of 44; current query: 'CREATE TABLE test.t1(a int)'; pre-binlog check: 'SELECT count(*)=0 FROM information_schema.tables where table_name='t1''; pre-commit check: 'SELECT count(*)=1 FROM information_schema.tables where table_name='t1'';
685 [connection slave]
686 *** Query: 'CREATE TABLE test.t1(a int)'. Crash right after the query has been prepared in the engine before being logged. ***
687 SET @@GLOBAL.debug="+d,crash_commit_before_log";
688 include/gtid_step_reset.inc
689 START REPLICA SQL_THREAD;
690 include/rpl_start_server.inc [server_number=2]
691 include/gtid_step_assert.inc [count=0, only_count=1]
692 *** Query: 'CREATE TABLE test.t1(a int)'. Crash right after the query has been binary-logged before committed in the engine. ***
693 SET @@GLOBAL.debug="+d,crash_commit_after_log";
694 include/gtid_step_reset.inc
695 START REPLICA SQL_THREAD;
696 include/rpl_start_server.inc [server_number=2]
697 [connection slave]
698 include/gtid_step_assert.inc [count=1, only_count=1]
699 [connection master]
700 Loop: 31 out of 44; current query: 'ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);'; pre-binlog check: 'SELECT count(*)=1 FROM information_schema.columns where table_name='t1''; pre-commit check: 'SELECT count(*)=2 FROM information_schema.columns where table_name='t1'';
701 [connection slave]
702 *** Query: 'ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);'. Crash right after the query has been prepared in the engine before being logged. ***
703 SET @@GLOBAL.debug="+d,crash_commit_before_log";
704 include/gtid_step_reset.inc
705 START REPLICA SQL_THREAD;
706 include/rpl_start_server.inc [server_number=2]
707 include/gtid_step_assert.inc [count=0, only_count=1]
708 *** Query: 'ALTER TABLE test.t1 ADD COLUMN t1_new_col varchar(100);'. Crash right after the query has been binary-logged before committed in the engine. ***
709 SET @@GLOBAL.debug="+d,crash_commit_after_log";
710 include/gtid_step_reset.inc
711 START REPLICA SQL_THREAD;
712 include/rpl_start_server.inc [server_number=2]
713 [connection slave]
714 include/gtid_step_assert.inc [count=1, only_count=1]
715 [connection master]
716 Loop: 32 out of 44; current query: 'ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);'; pre-binlog check: 'SELECT count(*)=0 FROM information_schema.innodb_indexes where name='new_t1_idx''; pre-commit check: 'SELECT count(*)=1 FROM information_schema.innodb_indexes where name='new_t1_idx'';
717 [connection slave]
718 *** Query: 'ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);'. Crash right after the query has been prepared in the engine before being logged. ***
719 SET @@GLOBAL.debug="+d,crash_commit_before_log";
720 include/gtid_step_reset.inc
721 START REPLICA SQL_THREAD;
722 include/rpl_start_server.inc [server_number=2]
723 include/gtid_step_assert.inc [count=0, only_count=1]
724 *** Query: 'ALTER TABLE test.t1 ADD index new_t1_idx(t1_new_col);'. Crash right after the query has been binary-logged before committed in the engine. ***
725 SET @@GLOBAL.debug="+d,crash_commit_after_log";
726 include/gtid_step_reset.inc
727 START REPLICA SQL_THREAD;
728 include/rpl_start_server.inc [server_number=2]
729 [connection slave]
730 include/gtid_step_assert.inc [count=1, only_count=1]
731 [connection master]
732 Loop: 33 out of 44; current query: 'ALTER TABLE test.t1 RENAME TO test.t2'; pre-binlog check: 'SELECT count(*)=0 FROM information_schema.tables where table_name='t2''; pre-commit check: 'SELECT count(*)=1 FROM information_schema.tables where table_name='t2'';
733 [connection slave]
734 *** Query: 'ALTER TABLE test.t1 RENAME TO test.t2'. Crash right after the query has been prepared in the engine before being logged. ***
735 SET @@GLOBAL.debug="+d,crash_commit_before_log";
736 include/gtid_step_reset.inc
737 START REPLICA SQL_THREAD;
738 include/rpl_start_server.inc [server_number=2]
739 include/gtid_step_assert.inc [count=0, only_count=1]
740 *** Query: 'ALTER TABLE test.t1 RENAME TO test.t2'. Crash right after the query has been binary-logged before committed in the engine. ***
741 SET @@GLOBAL.debug="+d,crash_commit_after_log";
742 include/gtid_step_reset.inc
743 START REPLICA SQL_THREAD;
744 include/rpl_start_server.inc [server_number=2]
745 [connection slave]
746 include/gtid_step_assert.inc [count=1, only_count=1]
747 [connection master]
748 Loop: 34 out of 44; current query: 'ALTER TABLE test.t2 DROP COLUMN a;'; pre-binlog check: 'SELECT count(*)=2 FROM information_schema.columns where table_name='t2''; pre-commit check: 'SELECT count(*)=1 FROM information_schema.columns where table_name='t2'';
749 [connection slave]
750 *** Query: 'ALTER TABLE test.t2 DROP COLUMN a;'. Crash right after the query has been prepared in the engine before being logged. ***
751 SET @@GLOBAL.debug="+d,crash_commit_before_log";
752 include/gtid_step_reset.inc
753 START REPLICA SQL_THREAD;
754 include/rpl_start_server.inc [server_number=2]
755 include/gtid_step_assert.inc [count=0, only_count=1]
756 *** Query: 'ALTER TABLE test.t2 DROP COLUMN a;'. Crash right after the query has been binary-logged before committed in the engine. ***
757 SET @@GLOBAL.debug="+d,crash_commit_after_log";
758 include/gtid_step_reset.inc
759 START REPLICA SQL_THREAD;
760 include/rpl_start_server.inc [server_number=2]
761 [connection slave]
762 include/gtid_step_assert.inc [count=1, only_count=1]
763 [connection master]
764 Loop: 35 out of 44; current query: 'TRUNCATE TABLE test.t2'; pre-binlog check: 'SELECT count(*)=1 FROM information_schema.tables where table_name='t2''; pre-commit check: 'SELECT count(*)=1 FROM information_schema.tables where table_name='t2'';
765 [connection slave]
766 *** Query: 'TRUNCATE TABLE test.t2'. Crash right after the query has been prepared in the engine before being logged. ***
767 SET @@GLOBAL.debug="+d,crash_commit_before_log";
768 include/gtid_step_reset.inc
769 START REPLICA SQL_THREAD;
770 include/rpl_start_server.inc [server_number=2]
771 include/gtid_step_assert.inc [count=0, only_count=1]
772 *** Query: 'TRUNCATE TABLE test.t2'. Crash right after the query has been binary-logged before committed in the engine. ***
773 SET @@GLOBAL.debug="+d,crash_commit_after_log";
774 include/gtid_step_reset.inc
775 START REPLICA SQL_THREAD;
776 include/rpl_start_server.inc [server_number=2]
777 [connection slave]
778 include/gtid_step_assert.inc [count=1, only_count=1]
779 [connection master]
780 Loop: 36 out of 44; current query: 'ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);'; pre-binlog check: 'SELECT count(*)=0 FROM information_schema.innodb_indexes where name='full_t2_idx''; pre-commit check: 'SELECT count(*)=1 FROM information_schema.innodb_indexes where name='full_t2_idx'';
781 [connection slave]
782 *** Query: 'ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);'. Crash right after the query has been prepared in the engine before being logged. ***
783 SET @@GLOBAL.debug="+d,crash_commit_before_log";
784 include/gtid_step_reset.inc
785 START REPLICA SQL_THREAD;
786 include/rpl_start_server.inc [server_number=2]
787 include/gtid_step_assert.inc [count=0, only_count=1]
788 *** Query: 'ALTER TABLE test.t2 ADD fulltext index full_t2_idx(t1_new_col);'. Crash right after the query has been binary-logged before committed in the engine. ***
789 SET @@GLOBAL.debug="+d,crash_commit_after_log";
790 include/gtid_step_reset.inc
791 START REPLICA SQL_THREAD;
792 include/rpl_start_server.inc [server_number=2]
793 [connection slave]
794 include/gtid_step_assert.inc [count=1, only_count=1]
795 [connection master]
796 Loop: 37 out of 44; current query: 'ALTER TABLE test.t2 DROP index full_t2_idx;'; pre-binlog check: 'SELECT count(*)=1 FROM information_schema.innodb_indexes where name='full_t2_idx''; pre-commit check: 'SELECT count(*)=0 FROM information_schema.innodb_indexes where name='full_t2_idx'';
797 [connection slave]
798 *** Query: 'ALTER TABLE test.t2 DROP index full_t2_idx;'. Crash right after the query has been prepared in the engine before being logged. ***
799 SET @@GLOBAL.debug="+d,crash_commit_before_log";
800 include/gtid_step_reset.inc
801 START REPLICA SQL_THREAD;
802 include/rpl_start_server.inc [server_number=2]
803 include/gtid_step_assert.inc [count=0, only_count=1]
804 *** Query: 'ALTER TABLE test.t2 DROP index full_t2_idx;'. Crash right after the query has been binary-logged before committed in the engine. ***
805 SET @@GLOBAL.debug="+d,crash_commit_after_log";
806 include/gtid_step_reset.inc
807 START REPLICA SQL_THREAD;
808 include/rpl_start_server.inc [server_number=2]
809 [connection slave]
810 include/gtid_step_assert.inc [count=1, only_count=1]
811 [connection master]
812 Loop: 38 out of 44; current query: 'DROP TABLE test.t2'; pre-binlog check: 'SELECT count(*)=1 FROM information_schema.tables where table_name='t2''; pre-commit check: 'SELECT count(*)=0 FROM information_schema.tables where table_name='t2'';
813 [connection slave]
814 *** Query: 'DROP TABLE test.t2'. Crash right after the query has been prepared in the engine before being logged. ***
815 SET @@GLOBAL.debug="+d,crash_commit_before_log";
816 include/gtid_step_reset.inc
817 START REPLICA SQL_THREAD;
818 include/rpl_start_server.inc [server_number=2]
819 include/gtid_step_assert.inc [count=0, only_count=1]
820 *** Query: 'DROP TABLE test.t2'. Crash right after the query has been binary-logged before committed in the engine. ***
821 SET @@GLOBAL.debug="+d,crash_commit_after_log";
822 include/gtid_step_reset.inc
823 START REPLICA SQL_THREAD;
824 include/rpl_start_server.inc [server_number=2]
825 [connection slave]
826 include/gtid_step_assert.inc [count=1, only_count=1]
827 [connection master]
828 Loop: 39 out of 44; current query: 'CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd''; pre-binlog check: 'SELECT count(*)=0 FROM information_schema.INNODB_TABLESPACES WHERE name = 'ts''; pre-commit check: 'SELECT count(*)=1 FROM information_schema.INNODB_TABLESPACES WHERE name = 'ts'';
829 [connection slave]
830 *** Query: 'CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd''. Crash right after the query has been prepared in the engine before being logged. ***
831 SET @@GLOBAL.debug="+d,crash_commit_before_log";
832 include/gtid_step_reset.inc
833 START REPLICA SQL_THREAD;
834 include/rpl_start_server.inc [server_number=2]
835 include/gtid_step_assert.inc [count=0, only_count=1]
836 *** Query: 'CREATE TABLESPACE ts ADD DATAFILE 'ts_0.ibd''. Crash right after the query has been binary-logged before committed in the engine. ***
837 SET @@GLOBAL.debug="+d,crash_commit_after_log";
838 include/gtid_step_reset.inc
839 START REPLICA SQL_THREAD;
840 include/rpl_start_server.inc [server_number=2]
841 [connection slave]
842 include/gtid_step_assert.inc [count=1, only_count=1]
843 [connection master]
844 Loop: 40 out of 44; current query: 'DROP TABLESPACE ts'; pre-binlog check: 'SELECT count(*)=1 FROM information_schema.INNODB_TABLESPACES WHERE name = 'ts''; pre-commit check: 'SELECT count(*)=0 FROM information_schema.INNODB_TABLESPACES WHERE name = 'ts'';
845 [connection slave]
846 *** Query: 'DROP TABLESPACE ts'. Crash right after the query has been prepared in the engine before being logged. ***
847 SET @@GLOBAL.debug="+d,crash_commit_before_log";
848 include/gtid_step_reset.inc
849 START REPLICA SQL_THREAD;
850 include/rpl_start_server.inc [server_number=2]
851 include/gtid_step_assert.inc [count=0, only_count=1]
852 *** Query: 'DROP TABLESPACE ts'. Crash right after the query has been binary-logged before committed in the engine. ***
853 SET @@GLOBAL.debug="+d,crash_commit_after_log";
854 include/gtid_step_reset.inc
855 START REPLICA SQL_THREAD;
856 include/rpl_start_server.inc [server_number=2]
857 [connection slave]
858 include/gtid_step_assert.inc [count=1, only_count=1]
859 [connection master]
860 Loop: 41 out of 44; current query: 'CREATE TABLE test.t1(a int)'; pre-binlog check: 'SELECT count(*)=0 FROM information_schema.tables where table_name='t1''; pre-commit check: 'SELECT count(*)=1 FROM information_schema.tables where table_name='t1'';
861 [connection slave]
862 *** Query: 'CREATE TABLE test.t1(a int)'. Crash right after the query has been prepared in the engine before being logged. ***
863 SET @@GLOBAL.debug="+d,crash_commit_before_log";
864 include/gtid_step_reset.inc
865 START REPLICA SQL_THREAD;
866 include/rpl_start_server.inc [server_number=2]
867 include/gtid_step_assert.inc [count=0, only_count=1]
868 *** Query: 'CREATE TABLE test.t1(a int)'. Crash right after the query has been binary-logged before committed in the engine. ***
869 SET @@GLOBAL.debug="+d,crash_commit_after_log";
870 include/gtid_step_reset.inc
871 START REPLICA SQL_THREAD;
872 include/rpl_start_server.inc [server_number=2]
873 [connection slave]
874 include/gtid_step_assert.inc [count=1, only_count=1]
875 [connection master]
876 Loop: 42 out of 44; current query: 'CREATE TABLE test.t2 AS SELECT * FROM t1;'; pre-binlog check: 'SELECT count(*)=0 FROM information_schema.tables where table_name='t2''; pre-commit check: 'SELECT count(*)=1 FROM information_schema.tables where table_name='t2'';
877 [connection slave]
878 *** Query: 'CREATE TABLE test.t2 AS SELECT * FROM t1;'. Crash right after the query has been prepared in the engine before being logged. ***
879 SET @@GLOBAL.debug="+d,crash_commit_before_log";
880 include/gtid_step_reset.inc
881 START REPLICA SQL_THREAD;
882 include/rpl_start_server.inc [server_number=2]
883 include/gtid_step_assert.inc [count=0, only_count=1]
884 *** Query: 'CREATE TABLE test.t2 AS SELECT * FROM t1;'. Crash right after the query has been binary-logged before committed in the engine. ***
885 SET @@GLOBAL.debug="+d,crash_commit_after_log";
886 include/gtid_step_reset.inc
887 START REPLICA SQL_THREAD;
888 include/rpl_start_server.inc [server_number=2]
889 [connection slave]
890 include/gtid_step_assert.inc [count=1, only_count=1]
891 [connection master]
892 Loop: 43 out of 44; current query: 'DROP TABLE test.t1'; pre-binlog check: 'SELECT count(*)=1 FROM information_schema.tables where table_name='t1''; pre-commit check: 'SELECT count(*)=0 FROM information_schema.tables where table_name='t1'';
893 [connection slave]
894 *** Query: 'DROP TABLE test.t1'. Crash right after the query has been prepared in the engine before being logged. ***
895 SET @@GLOBAL.debug="+d,crash_commit_before_log";
896 include/gtid_step_reset.inc
897 START REPLICA SQL_THREAD;
898 include/rpl_start_server.inc [server_number=2]
899 include/gtid_step_assert.inc [count=0, only_count=1]
900 *** Query: 'DROP TABLE test.t1'. Crash right after the query has been binary-logged before committed in the engine. ***
901 SET @@GLOBAL.debug="+d,crash_commit_after_log";
902 include/gtid_step_reset.inc
903 START REPLICA SQL_THREAD;
904 include/rpl_start_server.inc [server_number=2]
905 [connection slave]
906 include/gtid_step_assert.inc [count=1, only_count=1]
907 [connection master]
908 Loop: 44 out of 44; current query: 'DROP TABLE test.t2'; pre-binlog check: 'SELECT count(*)=1 FROM information_schema.tables where table_name='t2''; pre-commit check: 'SELECT count(*)=0 FROM information_schema.tables where table_name='t2'';
909 [connection slave]
910 *** Query: 'DROP TABLE test.t2'. Crash right after the query has been prepared in the engine before being logged. ***
911 SET @@GLOBAL.debug="+d,crash_commit_before_log";
912 include/gtid_step_reset.inc
913 START REPLICA SQL_THREAD;
914 include/rpl_start_server.inc [server_number=2]
915 include/gtid_step_assert.inc [count=0, only_count=1]
916 *** Query: 'DROP TABLE test.t2'. Crash right after the query has been binary-logged before committed in the engine. ***
917 SET @@GLOBAL.debug="+d,crash_commit_after_log";
918 include/gtid_step_reset.inc
919 START REPLICA SQL_THREAD;
920 include/rpl_start_server.inc [server_number=2]
921 [connection slave]
922 include/gtid_step_assert.inc [count=1, only_count=1]
923 [connection slave]
924 include/start_slave.inc
925 [connection master]
926 DROP table t_1;
927 DROP DATABASE master_db;
928 include/sync_slave_sql_with_master.inc
929 include/rpl_end.inc