Debian Codegraph @

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

raw
1 # innodb_change_buffering_debug option is debug only
2 --source include/have_debug.inc
3
4 call mtr.add_suppression("Failed to find tablespace for table .* in the cache. Attempting to load the tablespace with space id");
5
6 # Suppress the known warnings in the read-only-mode
7 --source include/add_mtr_suppression_for_innodb_readonly.inc
8
9 CREATE TABLE t1(
10 a INT AUTO_INCREMENT PRIMARY KEY,
11 b CHAR(1),
12 c INT,
13 INDEX(b))
14 ENGINE=InnoDB STATS_PERSISTENT=0;
15
16 # The flag innodb_change_buffering_debug is only available in debug builds.
17 # It instructs InnoDB to try to evict pages from the buffer pool when
18 # change buffering is possible, so that the change buffer will be used
19 # whenever possible.
20 SET GLOBAL innodb_change_buffering_debug = 1;
21
22 # Create enough rows for the table, so that the change buffer will be
23 # used for modifying the secondary index page. There must be multiple
24 # index pages, because changes to the root page are never buffered.
25 INSERT INTO t1 VALUES(0,'x',1);
26 INSERT INTO t1 SELECT 0,b,c FROM t1;
27 INSERT INTO t1 SELECT 0,b,c FROM t1;
28 INSERT INTO t1 SELECT 0,b,c FROM t1;
29 INSERT INTO t1 SELECT 0,b,c FROM t1;
30 INSERT INTO t1 SELECT 0,b,c FROM t1;
31 INSERT INTO t1 SELECT 0,b,c FROM t1;
32 INSERT INTO t1 SELECT 0,b,c FROM t1;
33 INSERT INTO t1 SELECT 0,b,c FROM t1;
34 INSERT INTO t1 SELECT 0,b,c FROM t1;
35 INSERT INTO t1 SELECT 0,b,c FROM t1;
36 INSERT INTO t1 SELECT 0,b,c FROM t1;
37 INSERT INTO t1 SELECT 0,b,c FROM t1;
38 INSERT INTO t1 SELECT 0,b,c FROM t1;
39
40 let $restart_parameters = restart: --innodb-force-recovery=6;
41 --source include/restart_mysqld.inc
42
43 --error ER_CANT_LOCK
44 insert into t1 values(0, 'y', 1);
45
46 let $restart_parameters = restart;
47 --source include/restart_mysqld.inc
48
49 # Cleanup
50 DROP TABLE t1;