mirror of
https://github.com/MariaDB/server.git
synced 2025-02-07 06:12:18 +01:00
52 lines
1.6 KiB
Text
52 lines
1.6 KiB
Text
--source include/have_innodb.inc
|
|
--source include/big_test.inc
|
|
--source include/have_sequence.inc
|
|
--source include/maybe_debug.inc
|
|
call mtr.add_suppression("InnoDB: The change buffer is corrupted");
|
|
call mtr.add_suppression("InnoDB: Plugin initialization aborted at srv0start.cc");
|
|
call mtr.add_suppression("Plugin 'InnoDB' init function returned error");
|
|
call mtr.add_suppression("Plugin 'InnoDB' registration as a STORAGE ENGINE failed.");
|
|
call mtr.add_suppression("Fewer engines are enabled now than were before the crash");
|
|
CREATE TABLE t1(c TEXT, KEY(c(3072)))ENGINE=InnoDB CHARSET=latin1;
|
|
DELIMITER |;
|
|
|
|
CREATE PROCEDURE dorepeat()
|
|
LOOP
|
|
INSERT INTO t1 VALUES ('abc');
|
|
UPDATE t1 SET c='cba';
|
|
END LOOP
|
|
|
|
|
|
|
DELIMITER ;|
|
|
connect(con1,localhost,root,,,);
|
|
send CALL dorepeat();
|
|
connection default;
|
|
sleep 10;
|
|
let $shutdown_timeout=0;
|
|
let $restart_parameters=--innodb_buffer_pool_size=5242880;
|
|
--source include/restart_mysqld.inc
|
|
DROP TABLE t1;
|
|
DROP PROCEDURE dorepeat;
|
|
|
|
--echo #
|
|
--echo # MDEV-30552 InnoDB recovery crashes when error
|
|
--echo # handling scenario
|
|
--echo #
|
|
if ($have_debug) {
|
|
SET DEBUG_DBUG="+d,ib_log_checkpoint_avoid_hard";
|
|
let $restart_parameters=--innodb_buffer_pool_size=5242880 --debug_dbug=+d,hdr_page_corrupt;
|
|
}
|
|
if (!$have_debug) {
|
|
--echo SET DEBUG_DBUG="+d,ib_log_checkpoint_avoid_hard";
|
|
let $restart_parameters=--innodb_buffer_pool_size=5242880;
|
|
}
|
|
CREATE TABLE t1(f1 INT NOT NULL)ENGINE=InnoDB;
|
|
INSERT INTO t1 SELECT * FROM seq_1_to_65536;
|
|
let $restart_noprint=1;
|
|
let $shutdown_timeout=0;
|
|
--source include/restart_mysqld.inc
|
|
let $restart_noprint=0;
|
|
let $restart_parameters=;
|
|
--source include/restart_mysqld.inc
|
|
SHOW CREATE TABLE t1;
|
|
DROP TABLE t1;
|