Debian Codegraph @

mysql-test/suite/binlog/r/binlog_mdev25611.result

raw
1 *** MDEV-25611: RESET MASTER hangs waiting for InnoDB to flush its log
2 SET @old_dbug= @@global.DEBUG_DBUG;
3 SET GLOBAL debug_dbug="+d,ib_log_checkpoint_avoid";
4 SET @old_flush= @@GLOBAL.innodb_flush_log_at_trx_commit;
5 SET GLOBAL innodb_flush_log_at_trx_commit= 0;
6 SET @old_flush_timeout= @@GLOBAL.innoDB_flush_log_at_timeout;
7 SET GLOBAL innoDB_flush_log_at_timeout=2700;
8 connection default;
9 CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB STATS_PERSISTENT=0;
10 INSERT INTO t1 VALUES (1,1);
11 INSERT INTO t1 VALUES (2,1);
12 INSERT INTO t1 VALUES (3,1);
13 connect stop_purge,localhost,root,,;
14 START TRANSACTION WITH CONSISTENT SNAPSHOT;
15 connection default;
16 INSERT INTO t1 VALUES (4,2);
17 DELETE FROM t1 WHERE a in (1,2,3);
18 FLUSH BINARY LOGS;
19 connection stop_purge;
20 ROLLBACK;
21 connection default;
22 disconnect stop_purge;
23 RESET MASTER;
24 connection default;
25 DROP TABLE t1;
26 SET GLOBAL debug_dbug= @old_dbug;
27 SET GLOBAL innodb_flush_log_at_trx_commit= @old_flush;
28 SET GLOBAL innoDB_flush_log_at_timeout= @old_flush_timeout;