Debian Codegraph @

mysql-test/suite/innodb_fts/r/bug_32831765.result

raw
1 call mtr.add_suppression("InnoDB: Total InnoDB FTS size .* for the table .* exceeds the innodb_ft_cache_size .*");
2 #
3 # Bug#32831765 SERVER HITS OOM CONDITION WHEN LOADING TWO
4 # INNODB TABLES WITH FTS INDEXES
5 #
6 create table t1 ( `id` int unsigned NOT NULL AUTO_INCREMENT, `col01` text,
7 `col02` text, `col03` text, `col04` text, `col05` text, `col06` text, `col07`
8 text, `col08` text, `col09` text, `col10` text, `col11` text, `col12` text,
9 `col13` text, `col14` text, `col15` text, `col16` text, `col17` text, `col18`
10 text, `col19` text, `col20` text, `col21` text, `col22` text, `col23` text,
11 `col24` text, `col25` text, `col26` text, `col27` text, `col28` text, `col29`
12 text, `col30` text, PRIMARY KEY (`id`), FULLTEXT KEY (`col01`), FULLTEXT KEY
13 (`col02`), FULLTEXT KEY (`col03`), FULLTEXT KEY (`col04`), FULLTEXT KEY
14 (`col05`), FULLTEXT KEY (`col06`), FULLTEXT KEY (`col07`), FULLTEXT KEY
15 (`col08`), FULLTEXT KEY (`col09`), FULLTEXT KEY (`col10`), FULLTEXT KEY
16 (`col11`), FULLTEXT KEY (`col12`), FULLTEXT KEY (`col13`), FULLTEXT KEY
17 (`col14`), FULLTEXT KEY (`col15`), FULLTEXT KEY (`col16`), FULLTEXT KEY
18 (`col17`), FULLTEXT KEY (`col18`), FULLTEXT KEY (`col19`), FULLTEXT KEY
19 (`col20`), FULLTEXT KEY (`col21`), FULLTEXT KEY (`col22`), FULLTEXT KEY
20 (`col23`), FULLTEXT KEY (`col24`), FULLTEXT KEY (`col25`), FULLTEXT KEY
21 (`col26`), FULLTEXT KEY (`col27`), FULLTEXT KEY (`col28`), FULLTEXT KEY
22 (`col29`), FULLTEXT KEY (`col30`)) engine=innodb;
23 create table t2 ( `id` int unsigned NOT NULL AUTO_INCREMENT, `col01` text,
24 `col02` text, `col03` text, `col04` text, `col05` text, `col06` text, `col07`
25 text, `col08` text, `col09` text, `col10` text, `col11` text, `col12` text,
26 `col13` text, `col14` text, `col15` text, `col16` text, `col17` text, `col18`
27 text, `col19` text, `col20` text, `col21` text, `col22` text, `col23` text,
28 `col24` text, `col25` text, `col26` text, `col27` text, `col28` text, `col29`
29 text, `col30` text, PRIMARY KEY (`id`), FULLTEXT KEY (`col01`), FULLTEXT KEY
30 (`col02`), FULLTEXT KEY (`col03`), FULLTEXT KEY (`col04`), FULLTEXT KEY
31 (`col05`), FULLTEXT KEY (`col06`), FULLTEXT KEY (`col07`), FULLTEXT KEY
32 (`col08`), FULLTEXT KEY (`col09`), FULLTEXT KEY (`col10`), FULLTEXT KEY
33 (`col11`), FULLTEXT KEY (`col12`), FULLTEXT KEY (`col13`), FULLTEXT KEY
34 (`col14`), FULLTEXT KEY (`col15`), FULLTEXT KEY (`col16`), FULLTEXT KEY
35 (`col17`), FULLTEXT KEY (`col18`), FULLTEXT KEY (`col19`), FULLTEXT KEY
36 (`col20`), FULLTEXT KEY (`col21`), FULLTEXT KEY (`col22`), FULLTEXT KEY
37 (`col23`), FULLTEXT KEY (`col24`), FULLTEXT KEY (`col25`), FULLTEXT KEY
38 (`col26`), FULLTEXT KEY (`col27`), FULLTEXT KEY (`col28`), FULLTEXT KEY
39 (`col29`), FULLTEXT KEY (`col30`)) engine=innodb;
40 create table t3 ( `id` int unsigned NOT NULL AUTO_INCREMENT, `col01` text,
41 `col02` text, `col03` text, `col04` text, `col05` text, `col06` text, `col07`
42 text, `col08` text, `col09` text, `col10` text, `col11` text, `col12` text,
43 `col13` text, `col14` text, `col15` text, `col16` text, `col17` text, `col18`
44 text, `col19` text, `col20` text, `col21` text, `col22` text, `col23` text,
45 `col24` text, `col25` text, `col26` text, `col27` text, `col28` text, `col29`
46 text, `col30` text, PRIMARY KEY (`id`), FULLTEXT KEY (`col01`), FULLTEXT KEY
47 (`col02`), FULLTEXT KEY (`col03`), FULLTEXT KEY (`col04`), FULLTEXT KEY
48 (`col05`), FULLTEXT KEY (`col06`), FULLTEXT KEY (`col07`), FULLTEXT KEY
49 (`col08`), FULLTEXT KEY (`col09`), FULLTEXT KEY (`col10`), FULLTEXT KEY
50 (`col11`), FULLTEXT KEY (`col12`), FULLTEXT KEY (`col13`), FULLTEXT KEY
51 (`col14`), FULLTEXT KEY (`col15`), FULLTEXT KEY (`col16`), FULLTEXT KEY
52 (`col17`), FULLTEXT KEY (`col18`), FULLTEXT KEY (`col19`), FULLTEXT KEY
53 (`col20`), FULLTEXT KEY (`col21`), FULLTEXT KEY (`col22`), FULLTEXT KEY
54 (`col23`), FULLTEXT KEY (`col24`), FULLTEXT KEY (`col25`), FULLTEXT KEY
55 (`col26`), FULLTEXT KEY (`col27`), FULLTEXT KEY (`col28`), FULLTEXT KEY
56 (`col29`), FULLTEXT KEY (`col30`)) engine=innodb;
57 create table t4 ( `id` int unsigned NOT NULL AUTO_INCREMENT, `col01` text,
58 `col02` text, `col03` text, `col04` text, `col05` text, `col06` text, `col07`
59 text, `col08` text, `col09` text, `col10` text, `col11` text, `col12` text,
60 `col13` text, `col14` text, `col15` text, `col16` text, `col17` text, `col18`
61 text, `col19` text, `col20` text, `col21` text, `col22` text, `col23` text,
62 `col24` text, `col25` text, `col26` text, `col27` text, `col28` text, `col29`
63 text, `col30` text, PRIMARY KEY (`id`), FULLTEXT KEY (`col01`), FULLTEXT KEY
64 (`col02`), FULLTEXT KEY (`col03`), FULLTEXT KEY (`col04`), FULLTEXT KEY
65 (`col05`), FULLTEXT KEY (`col06`), FULLTEXT KEY (`col07`), FULLTEXT KEY
66 (`col08`), FULLTEXT KEY (`col09`), FULLTEXT KEY (`col10`), FULLTEXT KEY
67 (`col11`), FULLTEXT KEY (`col12`), FULLTEXT KEY (`col13`), FULLTEXT KEY
68 (`col14`), FULLTEXT KEY (`col15`), FULLTEXT KEY (`col16`), FULLTEXT KEY
69 (`col17`), FULLTEXT KEY (`col18`), FULLTEXT KEY (`col19`), FULLTEXT KEY
70 (`col20`), FULLTEXT KEY (`col21`), FULLTEXT KEY (`col22`), FULLTEXT KEY
71 (`col23`), FULLTEXT KEY (`col24`), FULLTEXT KEY (`col25`), FULLTEXT KEY
72 (`col26`), FULLTEXT KEY (`col27`), FULLTEXT KEY (`col28`), FULLTEXT KEY
73 (`col29`), FULLTEXT KEY (`col30`)) engine=innodb;
74 #create procedure to inset into the table.
75 CREATE PROCEDURE `proc_insert`(IN tab_name VARCHAR(40))
76 BEGIN
77 DECLARE i INT DEFAULT 1;
78 SET @insert_tbl =CONCAT('INSERT INTO ', tab_name, '( `col01`, `col02`,
79 `col03`, `col04`, `col05`, `col06`, `col07`, `col08`, `col09`, `col10`,
80 `col11`, `col12`, `col13`, `col14`, `col15`, `col16`, `col17`, `col18`,
81 `col19`, `col20`, `col21`, `col22`, `col23`, `col24`, `col25`, `col26`,
82 `col27`, `col28`, `col29`, `col30`)
83 VALUES ( MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
84 MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
85 MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
86 MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
87 MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
88 MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
89 MD5(RAND()))');
90 PREPARE ins_stmt FROM @insert_tbl;
91 while (i <= 2000) DO
92 EXECUTE ins_stmt;
93 SET i = i + 1;
94 END WHILE;
95 DEALLOCATE PREPARE ins_stmt;
96 END |
97 SET @save_dbug= @@GLOBAL.debug_dbug;
98 SET GLOBAL debug_dbug="+d,fts_optimize_wq_count_check";
99 connect con1,localhost,root,,;
100 call proc_insert('t1');
101 connect con2,localhost,root,,;
102 call proc_insert('t1');
103 connect con3,localhost,root,,;
104 call proc_insert('t2');
105 connect con4,localhost,root,,;
106 call proc_insert('t2');
107 connect con5,localhost,root,,;
108 call proc_insert('t3');
109 connect con6,localhost,root,,;
110 call proc_insert('t3');
111 connect con7,localhost,root,,;
112 call proc_insert('t4');
113 connection default;
114 call proc_insert('t4');
115 SET GLOBAL debug_dbug= @save_dbug;
116 connection con1;
117 disconnect con1;
118 connection con2;
119 disconnect con2;
120 connection con3;
121 disconnect con3;
122 connection con4;
123 disconnect con4;
124 connection con5;
125 disconnect con5;
126 connection con6;
127 disconnect con6;
128 connection con7;
129 disconnect con7;
130 connection default;
131 DROP TABLE t1,t2,t3,t4;
132 DROP PROCEDURE proc_insert;