Gecko [ www.jdcpatala.org ]

Name	Size	Permission
basic.test	8.74 KB	-rw-r--r--
bug_32831765.test	7.42 KB	-rw-r--r--
compatibility.test	7.83 KB	-rw-r--r--
compatibility_win.test	7.67 KB	-rw-r--r--
ddl.test	9.31 KB	-rw-r--r--
disabled.def	404 B	-rw-r--r--
fic.test	7.35 KB	-rw-r--r--
foreign_key_check.test	868 B	-rw-r--r--
foreign_key_update.test	704 B	-rw-r--r--
fulltext.test	22.17 KB	-rw-r--r--
fulltext2.test	9.21 KB	-rw-r--r--
fulltext3.test	2.4 KB	-rw-r--r--
fulltext_cache.test	1.58 KB	-rw-r--r--
fulltext_distinct.test	1.28 KB	-rw-r--r--
fulltext_left_join.test	4.58 KB	-rw-r--r--
fulltext_misc.test	5.6 KB	-rw-r--r--
fulltext_multi.test	953 B	-rw-r--r--
fulltext_order_by.test	5.7 KB	-rw-r--r--
fulltext_plugin-master.opt	19 B	-rw-r--r--
fulltext_table_evict.test	1.17 KB	-rw-r--r--
fulltext_update.test	1.12 KB	-rw-r--r--
fulltext_var.test	1.39 KB	-rw-r--r--
index_table.test	3.32 KB	-rw-r--r--
innobase_drop_fts_index_table....	407 B	-rw-r--r--
large_records.test	12.23 KB	-rw-r--r--
limit_union.test	4.88 KB	-rw-r--r--
mecab_sjis-master.opt	40 B	-rw-r--r--
mecab_sjis.test	364 B	-rw-r--r--
mecab_ujis-master.opt	40 B	-rw-r--r--
mecab_ujis.test	368 B	-rw-r--r--
mecab_utf8-master.opt	40 B	-rw-r--r--
mecab_utf8.test	335 B	-rw-r--r--
misc.test	56.53 KB	-rw-r--r--
misc_1.test	33.18 KB	-rw-r--r--
misc_debug.test	5.17 KB	-rw-r--r--
multiple_index.test	6.37 KB	-rw-r--r--
ngram-master.opt	19 B	-rw-r--r--
ngram.test	13.15 KB	-rw-r--r--
ngram_1.test	2.01 KB	-rw-r--r--
ngram_2-master.opt	19 B	-rw-r--r--
ngram_2.test	4.18 KB	-rw-r--r--
ngram_debug.test	6.61 KB	-rw-r--r--
opt-master.opt	21 B	-rw-r--r--
opt.test	34.27 KB	-rw-r--r--
phrase.test	1 KB	-rw-r--r--
phrase_clear_no_match.test	2.41 KB	-rw-r--r--
plugin-master.opt	19 B	-rw-r--r--
plugin.test	6.69 KB	-rw-r--r--
plugin_1-master.opt	19 B	-rw-r--r--
plugin_1.test	11.22 KB	-rw-r--r--
plugin_debug-master.opt	19 B	-rw-r--r--
plugin_debug.test	9.57 KB	-rw-r--r--
proximity.test	7.89 KB	-rw-r--r--
result_cache_limit.test	1.76 KB	-rw-r--r--
savepoint.test	9.09 KB	-rw-r--r--
stopword.test	30.68 KB	-rw-r--r--
subexpr.test	2.09 KB	-rw-r--r--
sync.test	5.37 KB	-rw-r--r--
sync_block.test	3.36 KB	-rw-r--r--
sync_ddl.test	5.32 KB	-rw-r--r--
tablespace_location.test	5.06 KB	-rw-r--r--
tablespace_location_error.test	494 B	-rw-r--r--
transaction.test	31.15 KB	-rw-r--r--
truncate.opt	29 B	-rw-r--r--
truncate.test	1.51 KB	-rw-r--r--

Code Editor : bug_32831765.test

--echo #
--echo # Bug#32831765 SERVER HITS OOM CONDITION WHEN LOADING TWO
--echo # INNODB TABLES WITH FTS INDEXES
--echo #

--source include/have_debug.inc

create table t1 ( `id` int unsigned NOT NULL AUTO_INCREMENT, `col01` text,
`col02` text, `col03` text, `col04` text, `col05` text, `col06` text, `col07`
text, `col08` text, `col09` text, `col10` text, `col11` text, `col12` text,
`col13` text, `col14` text, `col15` text, `col16` text, `col17` text, `col18`
text, `col19` text, `col20` text, `col21` text, `col22` text, `col23` text,
`col24` text, `col25` text, `col26` text, `col27` text, `col28` text, `col29`
text, `col30` text, PRIMARY KEY (`id`), FULLTEXT KEY (`col01`), FULLTEXT KEY
(`col02`), FULLTEXT KEY (`col03`), FULLTEXT KEY (`col04`), FULLTEXT KEY
(`col05`), FULLTEXT KEY (`col06`), FULLTEXT KEY (`col07`), FULLTEXT KEY
(`col08`), FULLTEXT KEY (`col09`), FULLTEXT KEY (`col10`), FULLTEXT KEY
(`col11`), FULLTEXT KEY (`col12`), FULLTEXT KEY (`col13`), FULLTEXT KEY
(`col14`), FULLTEXT KEY (`col15`), FULLTEXT KEY (`col16`), FULLTEXT KEY
(`col17`), FULLTEXT KEY (`col18`), FULLTEXT KEY (`col19`), FULLTEXT KEY
(`col20`), FULLTEXT KEY (`col21`), FULLTEXT KEY (`col22`), FULLTEXT KEY
(`col23`), FULLTEXT KEY (`col24`), FULLTEXT KEY (`col25`), FULLTEXT KEY
(`col26`), FULLTEXT KEY (`col27`), FULLTEXT KEY (`col28`), FULLTEXT KEY
(`col29`), FULLTEXT KEY (`col30`)) engine=innodb;

create table t2 ( `id` int unsigned NOT NULL AUTO_INCREMENT, `col01` text,
`col02` text, `col03` text, `col04` text, `col05` text, `col06` text, `col07`
text, `col08` text, `col09` text, `col10` text, `col11` text, `col12` text,
`col13` text, `col14` text, `col15` text, `col16` text, `col17` text, `col18`
text, `col19` text, `col20` text, `col21` text, `col22` text, `col23` text,
`col24` text, `col25` text, `col26` text, `col27` text, `col28` text, `col29`
text, `col30` text, PRIMARY KEY (`id`), FULLTEXT KEY (`col01`), FULLTEXT KEY
(`col02`), FULLTEXT KEY (`col03`), FULLTEXT KEY (`col04`), FULLTEXT KEY
(`col05`), FULLTEXT KEY (`col06`), FULLTEXT KEY (`col07`), FULLTEXT KEY
(`col08`), FULLTEXT KEY (`col09`), FULLTEXT KEY (`col10`), FULLTEXT KEY
(`col11`), FULLTEXT KEY (`col12`), FULLTEXT KEY (`col13`), FULLTEXT KEY
(`col14`), FULLTEXT KEY (`col15`), FULLTEXT KEY (`col16`), FULLTEXT KEY
(`col17`), FULLTEXT KEY (`col18`), FULLTEXT KEY (`col19`), FULLTEXT KEY
(`col20`), FULLTEXT KEY (`col21`), FULLTEXT KEY (`col22`), FULLTEXT KEY
(`col23`), FULLTEXT KEY (`col24`), FULLTEXT KEY (`col25`), FULLTEXT KEY
(`col26`), FULLTEXT KEY (`col27`), FULLTEXT KEY (`col28`), FULLTEXT KEY
(`col29`), FULLTEXT KEY (`col30`)) engine=innodb;

create table t3 ( `id` int unsigned NOT NULL AUTO_INCREMENT, `col01` text,
`col02` text, `col03` text, `col04` text, `col05` text, `col06` text, `col07`
text, `col08` text, `col09` text, `col10` text, `col11` text, `col12` text,
`col13` text, `col14` text, `col15` text, `col16` text, `col17` text, `col18`
text, `col19` text, `col20` text, `col21` text, `col22` text, `col23` text,
`col24` text, `col25` text, `col26` text, `col27` text, `col28` text, `col29`
text, `col30` text, PRIMARY KEY (`id`), FULLTEXT KEY (`col01`), FULLTEXT KEY
(`col02`), FULLTEXT KEY (`col03`), FULLTEXT KEY (`col04`), FULLTEXT KEY
(`col05`), FULLTEXT KEY (`col06`), FULLTEXT KEY (`col07`), FULLTEXT KEY
(`col08`), FULLTEXT KEY (`col09`), FULLTEXT KEY (`col10`), FULLTEXT KEY
(`col11`), FULLTEXT KEY (`col12`), FULLTEXT KEY (`col13`), FULLTEXT KEY
(`col14`), FULLTEXT KEY (`col15`), FULLTEXT KEY (`col16`), FULLTEXT KEY
(`col17`), FULLTEXT KEY (`col18`), FULLTEXT KEY (`col19`), FULLTEXT KEY
(`col20`), FULLTEXT KEY (`col21`), FULLTEXT KEY (`col22`), FULLTEXT KEY
(`col23`), FULLTEXT KEY (`col24`), FULLTEXT KEY (`col25`), FULLTEXT KEY
(`col26`), FULLTEXT KEY (`col27`), FULLTEXT KEY (`col28`), FULLTEXT KEY
(`col29`), FULLTEXT KEY (`col30`)) engine=innodb;

create table t4 ( `id` int unsigned NOT NULL AUTO_INCREMENT, `col01` text,
`col02` text, `col03` text, `col04` text, `col05` text, `col06` text, `col07`
text, `col08` text, `col09` text, `col10` text, `col11` text, `col12` text,
`col13` text, `col14` text, `col15` text, `col16` text, `col17` text, `col18`
text, `col19` text, `col20` text, `col21` text, `col22` text, `col23` text,
`col24` text, `col25` text, `col26` text, `col27` text, `col28` text, `col29`
text, `col30` text, PRIMARY KEY (`id`), FULLTEXT KEY (`col01`), FULLTEXT KEY
(`col02`), FULLTEXT KEY (`col03`), FULLTEXT KEY (`col04`), FULLTEXT KEY
(`col05`), FULLTEXT KEY (`col06`), FULLTEXT KEY (`col07`), FULLTEXT KEY
(`col08`), FULLTEXT KEY (`col09`), FULLTEXT KEY (`col10`), FULLTEXT KEY
(`col11`), FULLTEXT KEY (`col12`), FULLTEXT KEY (`col13`), FULLTEXT KEY
(`col14`), FULLTEXT KEY (`col15`), FULLTEXT KEY (`col16`), FULLTEXT KEY
(`col17`), FULLTEXT KEY (`col18`), FULLTEXT KEY (`col19`), FULLTEXT KEY
(`col20`), FULLTEXT KEY (`col21`), FULLTEXT KEY (`col22`), FULLTEXT KEY
(`col23`), FULLTEXT KEY (`col24`), FULLTEXT KEY (`col25`), FULLTEXT KEY
(`col26`), FULLTEXT KEY (`col27`), FULLTEXT KEY (`col28`), FULLTEXT KEY
(`col29`), FULLTEXT KEY (`col30`)) engine=innodb;

delimiter |;

--echo #create procedure to inset into the table.
CREATE  PROCEDURE `proc_insert`(IN tab_name VARCHAR(40))
BEGIN
	DECLARE i INT DEFAULT 1;
	SET @insert_tbl =CONCAT('INSERT INTO ', tab_name, '( `col01`, `col02`,
	`col03`, `col04`, `col05`, `col06`, `col07`, `col08`, `col09`, `col10`,
	`col11`, `col12`, `col13`, `col14`, `col15`, `col16`, `col17`, `col18`,
	`col19`, `col20`, `col21`, `col22`, `col23`, `col24`, `col25`, `col26`,
	`col27`, `col28`, `col29`, `col30`)
	VALUES ( MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
	MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
	MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
	MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
	MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
	MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()), MD5(RAND()),
	MD5(RAND()))');
	PREPARE ins_stmt FROM @insert_tbl;
	while (i <= 2000) DO
		EXECUTE ins_stmt;
		SET i = i + 1;
	END WHILE;
	DEALLOCATE PREPARE ins_stmt;
END |

delimiter ;|

connect (con1,localhost,root,,);
connect (con2,localhost,root,,);
connect (con3,localhost,root,,);
connect (con4,localhost,root,,);
connect (con5,localhost,root,,);
connect (con6,localhost,root,,);
connect (con7,localhost,root,,);
connect (con8,localhost,root,,);

connection con1;
--send call proc_insert('t1');

connection con2;
--send call proc_insert('t1');

connection con3;
--send call proc_insert('t2');

connection con4;
--send call proc_insert('t2');

connection con5;
--send call proc_insert('t3');

connection con6;
--send call proc_insert('t3');

connection con7;
--send call proc_insert('t4');

connection con8;
--send call proc_insert('t4');

connection default;

# Check if number of SYNC requests are more than 1000.
SET GLOBAL DEBUG="+d,fts_optimize_wq_count_check";

# Wait for 1 minute to make sure INSERTs into FTS table will trigger
# FTS_SYNC request
let $loop=60;
while($loop > 1)
{
  sleep 1;
  dec $loop;
}

SET GLOBAL DEBUG="-d,fts_optimize_wq_count_check";

connection con1;
reap;
disconnect con1;

connection con2;
reap;
disconnect con2;

connection con3;
reap;
disconnect con3;

connection con4;
reap;
disconnect con4;

connection con5;
reap;
disconnect con5;

connection con6;
reap;
disconnect con6;

connection con7;
reap;
disconnect con7;

connection con8;
reap;
disconnect con8;

connection default;
--echo # clean up
DROP TABLE t1;
DROP TABLE t2;
DROP TABLE t3;
DROP TABLE t4;
DROP PROCEDURE proc_insert;

${this.title}

Code Editor : bug_32831765.test