Debian Codegraph @

mysql-test/suite/innodb/t/recovery_memory.test

raw
1 --source include/have_innodb.inc
2 --source include/big_test.inc
3 --source include/have_sequence.inc
4 --source include/maybe_debug.inc
5 call mtr.add_suppression("InnoDB: The change buffer is corrupted");
6 call mtr.add_suppression("InnoDB: Plugin initialization aborted at srv0start.cc");
7 call mtr.add_suppression("Plugin 'InnoDB' init function returned error");
8 call mtr.add_suppression("Plugin 'InnoDB' registration as a STORAGE ENGINE failed.");
9 call mtr.add_suppression("Fewer engines are enabled now than were before the crash");
10 CREATE TABLE t1(c TEXT, KEY(c(3072)))ENGINE=InnoDB CHARSET=latin1;
11 DELIMITER |;
12
13 CREATE PROCEDURE dorepeat()
14 LOOP
15 INSERT INTO t1 VALUES ('abc');
16 UPDATE t1 SET c='cba';
17 END LOOP
18 |
19
20 DELIMITER ;|
21 connect(con1,localhost,root,,,);
22 send CALL dorepeat();
23 connection default;
24 sleep 10;
25 let $shutdown_timeout=0;
26 let $restart_parameters=--innodb_buffer_pool_size=6m;
27 --source include/restart_mysqld.inc
28 DROP TABLE t1;
29 DROP PROCEDURE dorepeat;
30
31 --echo #
32 --echo # MDEV-30552 InnoDB recovery crashes when error
33 --echo # handling scenario
34 --echo #
35 if ($have_debug) {
36 SET DEBUG_DBUG="+d,ib_log_checkpoint_avoid_hard";
37 let $restart_parameters=--innodb_buffer_pool_size=6m --debug_dbug=+d,hdr_page_corrupt;
38 }
39 if (!$have_debug) {
40 --echo SET DEBUG_DBUG="+d,ib_log_checkpoint_avoid_hard";
41 let $restart_parameters=--innodb_buffer_pool_size=6m;
42 }
43 CREATE TABLE t1(f1 INT NOT NULL)ENGINE=InnoDB;
44 INSERT INTO t1 SELECT * FROM seq_1_to_65536;
45 let $restart_noprint=1;
46 let $shutdown_timeout=0;
47 --source include/restart_mysqld.inc
48 let $restart_noprint=0;
49 let $restart_parameters=;
50 --source include/restart_mysqld.inc
51 SHOW CREATE TABLE t1;
52 DROP TABLE t1;