Debian Codegraph @

mysql-test/suite/innodb_fts/t/fulltext_table_evict.test

raw
1 --echo #
2 --echo # Bug Bug #27304661 MYSQL CRASH DOING SYNC INDEX ]
3 --echo # [FATAL] INNODB: SEMAPHORE WAIT HAS LASTED > 600
4 --echo #
5
6 --source include/have_debug.inc
7
8 CREATE TABLE t1 (
9 id INT UNSIGNED AUTO_INCREMENT NOT NULL PRIMARY KEY,
10 f1 TEXT(500),
11 FULLTEXT idx (f1)
12 ) ENGINE=InnoDB;
13 insert into t1 (f1) values ('aditya'),('sachin'),('aakansha');
14
15 --source include/restart_mysqld.inc
16
17 set @save_table_definition_cache=@@global.table_definition_cache;
18 set @save_table_open_cache=@@global.table_open_cache;
19
20 set global table_definition_cache=400;
21 set global table_open_cache= 50;
22
23 SET GLOBAL DEBUG="+d,crash_if_fts_table_is_evicted";
24
25 select * from t1;
26 #Create 1000 tables, try the best to evict t1 .
27
28 --disable_query_log
29 let $loop=100;
30 while($loop)
31 {
32 eval create table t_$loop(id int, name text(100), fulltext idxt_$loop(name) )engine=innodb;
33 dec $loop;
34 }
35
36 let $loop=100;
37 while($loop)
38 {
39 eval drop table t_$loop;
40 dec $loop;
41 }
42
43 SET GLOBAL DEBUG="-d,crash_if_fts_table_is_evicted";
44 --enable_query_log
45 set @@global.table_definition_cache=@save_table_definition_cache;
46 set @@global.table_open_cache=@save_table_open_cache;
47 drop table t1;
48