Debian Codegraph @

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

raw
1 #
2 # Bug #59733 Possible deadlock when buffered changes are to be discarded
3 # in buf_page_create
4 #
5
6 -- disable_query_log
7 # The flag innodb_change_buffering_debug is only available in debug builds.
8 # It instructs InnoDB to try to evict pages from the buffer pool when
9 # change buffering is possible, so that the change buffer will be used
10 # whenever possible.
11 -- error 0,ER_UNKNOWN_SYSTEM_VARIABLE
12 SET @innodb_change_buffering_debug_orig = @@innodb_change_buffering_debug;
13 -- error 0,ER_UNKNOWN_SYSTEM_VARIABLE
14 SET GLOBAL innodb_change_buffering_debug = 1;
15 -- enable_query_log
16
17 CREATE TABLE bug59733(a INT AUTO_INCREMENT PRIMARY KEY,b CHAR(1)) ENGINE=InnoDB
18 STATS_PERSISTENT=1 STATS_AUTO_RECALC=0;
19
20 # Create enough rows for the table, so that the insert buffer will be
21 # used. There must be multiple index pages, because changes to the
22 # root page are never buffered.
23
24 INSERT INTO bug59733 VALUES(0,'x');
25 INSERT INTO bug59733 SELECT 0,b FROM bug59733;
26 INSERT INTO bug59733 SELECT 0,b FROM bug59733;
27 INSERT INTO bug59733 SELECT 0,b FROM bug59733;
28 INSERT INTO bug59733 SELECT 0,b FROM bug59733;
29 INSERT INTO bug59733 SELECT 0,b FROM bug59733;
30 INSERT INTO bug59733 SELECT 0,b FROM bug59733;
31 INSERT INTO bug59733 SELECT 0,b FROM bug59733;
32 INSERT INTO bug59733 SELECT 0,b FROM bug59733;
33 INSERT INTO bug59733 SELECT 0,b FROM bug59733;
34 INSERT INTO bug59733 SELECT 0,b FROM bug59733;
35 INSERT INTO bug59733 SELECT 0,b FROM bug59733;
36
37 # Create the secondary index for which changes will be buffered.
38 CREATE INDEX b ON bug59733 (b);
39
40 # This should be buffered, if innodb_change_buffering_debug = 1 is in effect.
41 DELETE FROM bug59733 WHERE (a%100)=0;
42
43 # Drop the index in order to get free pages with orphaned buffered changes.
44 DROP INDEX b ON bug59733;
45
46 # Create the index and attempt to reuse pages for which buffered changes exist.
47 CREATE INDEX b ON bug59733 (b);
48
49 DROP TABLE bug59733;
50
51 -- disable_query_log
52 -- error 0, ER_UNKNOWN_SYSTEM_VARIABLE
53 SET GLOBAL innodb_change_buffering_debug = @innodb_change_buffering_debug_orig;