mirror of
https://github.com/MariaDB/server.git
synced 2025-10-31 10:56:12 +01:00
35c732cdde
RESET MASTER waits for storage engines to reply to a binlog checkpoint requests. If this response is delayed for a long time for some reason, then RESET MASTER can hang. Fix this by forcing a log sync in all engines just before waiting for the checkpoint reply. (Waiting for old checkpoint responses is needed to preserve durability of any commits that were synced to disk in the to-be-deleted binlog but not yet synced in the engine.) Reviewed-by: Andrei Elkin <andrei.elkin@mariadb.com> Signed-off-by: Kristian Nielsen <knielsen@knielsen-hq.org>
28 lines
1,012 B
Text
28 lines
1,012 B
Text
*** MDEV-25611: RESET MASTER hangs waiting for InnoDB to flush its log
|
|
SET @old_dbug= @@global.DEBUG_DBUG;
|
|
SET GLOBAL debug_dbug="+d,ib_log_checkpoint_avoid";
|
|
SET @old_flush= @@GLOBAL.innodb_flush_log_at_trx_commit;
|
|
SET GLOBAL innodb_flush_log_at_trx_commit= 0;
|
|
SET @old_flush_timeout= @@GLOBAL.innoDB_flush_log_at_timeout;
|
|
SET GLOBAL innoDB_flush_log_at_timeout=2700;
|
|
connection default;
|
|
CREATE TABLE t1 (a INT PRIMARY KEY, b INT) ENGINE=InnoDB STATS_PERSISTENT=0;
|
|
INSERT INTO t1 VALUES (1,1);
|
|
INSERT INTO t1 VALUES (2,1);
|
|
INSERT INTO t1 VALUES (3,1);
|
|
connect stop_purge,localhost,root,,;
|
|
START TRANSACTION WITH CONSISTENT SNAPSHOT;
|
|
connection default;
|
|
INSERT INTO t1 VALUES (4,2);
|
|
DELETE FROM t1 WHERE a in (1,2,3);
|
|
FLUSH BINARY LOGS;
|
|
connection stop_purge;
|
|
ROLLBACK;
|
|
connection default;
|
|
disconnect stop_purge;
|
|
RESET MASTER;
|
|
connection default;
|
|
DROP TABLE t1;
|
|
SET GLOBAL debug_dbug= @old_dbug;
|
|
SET GLOBAL innodb_flush_log_at_trx_commit= @old_flush;
|
|
SET GLOBAL innoDB_flush_log_at_timeout= @old_flush_timeout;
|