From a175314c3e5827eb193872241446f2f8f5c9d33c Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 4 May 2024 20:07:14 +0200 Subject: Adding upstream version 1:10.5.12. Signed-off-by: Daniel Baumann --- .../innodb/r/innodb-change-buffer-recovery.result | 54 ++++++++++++++++++++++ 1 file changed, 54 insertions(+) create mode 100644 mysql-test/suite/innodb/r/innodb-change-buffer-recovery.result (limited to 'mysql-test/suite/innodb/r/innodb-change-buffer-recovery.result') diff --git a/mysql-test/suite/innodb/r/innodb-change-buffer-recovery.result b/mysql-test/suite/innodb/r/innodb-change-buffer-recovery.result new file mode 100644 index 00000000..678c8c67 --- /dev/null +++ b/mysql-test/suite/innodb/r/innodb-change-buffer-recovery.result @@ -0,0 +1,54 @@ +# +# Bug#69122 - INNODB DOESN'T REDO-LOG INSERT BUFFER MERGE +# OPERATION IF IT IS DONE IN-PLACE +# +call mtr.add_suppression("InnoDB: innodb_read_only prevents crash recovery"); +call mtr.add_suppression("Plugin initialization aborted at srv0start\\.cc"); +call mtr.add_suppression("Plugin 'InnoDB'"); +FLUSH TABLES; +CREATE TABLE t1( +a INT AUTO_INCREMENT PRIMARY KEY, +b CHAR(1), +c INT, +INDEX(b)) +ENGINE=InnoDB STATS_PERSISTENT=0; +SET GLOBAL innodb_change_buffering_debug = 1; +INSERT INTO t1 SELECT 0,'x',1 FROM seq_1_to_8192; +BEGIN; +SELECT b FROM t1 LIMIT 3; +b +x +x +x +connect con1,localhost,root,,; +BEGIN; +DELETE FROM t1 WHERE a=1; +INSERT INTO t1 VALUES(1,'X',1); +SET DEBUG_DBUG='+d,crash_after_log_ibuf_upd_inplace'; +SELECT b FROM t1 LIMIT 3; +ERROR HY000: Lost connection to MySQL server during query +disconnect con1; +connection default; +FOUND 1 /Wrote log record for ibuf update in place operation/ in mysqld.1.err +# restart: --innodb-read-only +CHECK TABLE t1; +Table Op Msg_type Msg_text +test.t1 check Error Unknown storage engine 'InnoDB' +test.t1 check error Corrupt +FOUND 1 /innodb_read_only prevents crash recovery/ in mysqld.1.err +# restart: --innodb-force-recovery=5 +SELECT * FROM t1 LIMIT 1; +a b c +1 X 1 +SHOW ENGINE INNODB STATUS; +Type Name Status +InnoDB insert 0, delete mark 0 +SET GLOBAL innodb_fast_shutdown=0; +# restart +CHECK TABLE t1; +Table Op Msg_type Msg_text +test.t1 check status OK +SHOW ENGINE INNODB STATUS; +Type Name Status +InnoDB +DROP TABLE t1; -- cgit v1.2.3