summaryrefslogtreecommitdiff
path: root/mysql-test/suite/innodb_fts/t/concurrent_insert.test
diff options
context:
space:
mode:
authorMarko Mäkelä <marko.makela@mariadb.com>2019-09-18 16:24:48 +0300
committerMarko Mäkelä <marko.makela@mariadb.com>2019-09-18 16:24:48 +0300
commitbb4214272a8a1b0e60a785e1bf1391d5753b73b6 (patch)
tree27d4dd0eff246902f9f25c102cf5f5aa9d10a05d /mysql-test/suite/innodb_fts/t/concurrent_insert.test
parent24859049c6b2d0b6f83f1f93ced15414d7266fb6 (diff)
parent8a79fa0e4d0385818da056f7a4a39fde95d62fe3 (diff)
downloadmariadb-git-bb4214272a8a1b0e60a785e1bf1391d5753b73b6.tar.gz
Merge 10.1 into 10.2
Diffstat (limited to 'mysql-test/suite/innodb_fts/t/concurrent_insert.test')
-rw-r--r--mysql-test/suite/innodb_fts/t/concurrent_insert.test31
1 files changed, 31 insertions, 0 deletions
diff --git a/mysql-test/suite/innodb_fts/t/concurrent_insert.test b/mysql-test/suite/innodb_fts/t/concurrent_insert.test
index e5d61cd8b05..77097d44dc5 100644
--- a/mysql-test/suite/innodb_fts/t/concurrent_insert.test
+++ b/mysql-test/suite/innodb_fts/t/concurrent_insert.test
@@ -18,3 +18,34 @@ reap;
SET DEBUG_SYNC = 'RESET';
DROP TABLE t1;
+
+--echo #
+--echo # MDEV-19529 InnoDB hang on DROP FULLTEXT INDEX
+--echo #
+
+CREATE TABLE t1(f1 CHAR(100), FULLTEXT(f1))ENGINE=InnoDB;
+INSERT INTO t1 VALUES('test');
+CREATE TABLE t2 (f1 char(100), FULLTEXT idx1(f1))ENGINE=InnoDB;
+INSERT INTO t2 VALUES('mariadb');
+
+connection default;
+SET GLOBAL debug_dbug ='+d,fts_instrument_sync_request,ib_optimize_wq_hang';
+SET DEBUG_SYNC= 'fts_instrument_sync_request
+ SIGNAL drop_index_start WAIT_FOR sync_op';
+send INSERT INTO t1 VALUES('Keyword');
+
+connect(con1,localhost,root,,,);
+SET DEBUG_SYNC='now WAIT_FOR drop_index_start';
+SET DEBUG_SYNC= 'norebuild_fts_drop SIGNAL sync_op WAIT_FOR fts_drop_index';
+send ALTER TABLE t2 drop index idx1;
+
+connection default;
+reap;
+set DEBUG_SYNC= 'now SIGNAL fts_drop_index';
+
+connection con1;
+reap;
+SET global DEBUG_DBUG=RESET;
+drop table t1, t2;
+connection default;
+set DEBUG_SYNC=RESET;