mirror of
https://github.com/MariaDB/server.git
synced 2025-02-05 13:22:17 +01:00
5979dcf95b
- Few of test case should make sure that InnoDB does hit the debug sync point during startup of the server. InnoDB can remove the double quotes of debug point in restart parameters.
56 lines
1.8 KiB
Text
56 lines
1.8 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.");
|
|
CREATE TABLE t1(c TEXT, KEY(c(3072)))ENGINE=InnoDB;
|
|
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,ibuf_init_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
|
|
if ($have_debug) {
|
|
let SEARCH_FILE = $MYSQLTEST_VARDIR/log/mysqld.1.err;
|
|
let SEARCH_PATTERN=\[ERROR\] InnoDB: The change buffer is corrupted or has been removed on upgrade to MariaDB 11.0 or later;
|
|
--source include/search_pattern_in_file.inc
|
|
}
|
|
let $restart_noprint=0;
|
|
let $restart_parameters=;
|
|
--source include/restart_mysqld.inc
|
|
SHOW CREATE TABLE t1;
|
|
DROP TABLE t1;
|