Bug #82704 alter table+insert+drop db hang
Submitted: 24 Aug 2016 8:35 Modified: 6 Oct 2017 18:19
Reporter: Ramana Yeruva Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: DDL Severity:S3 (Non-critical)
Version:8.0.0 OS:Any
Assigned to: CPU Architecture:Any

[24 Aug 2016 8:35] Ramana Yeruva
Description:
repeat attached statements from more than 2 sessions(ex:3),observe hang 

How to repeat:
./mysqld -uroot --basedir=../ --datadir=./data --initialize-insecure
./mysqld -uroot --basedir=../ --datadir=./data --gdb 

cat hang.sql 
drop database if exists test;
create database if not exists test;
use test;
CREATE TABLE t1(id INT AUTO_INCREMENT,title VARCHAR(100),FULLTEXT fidx(title),PRIMARY KEY(id)) ENGINE=InnoDB;
INSERT INTO t1(title) VALUES('mysql database');
SET GLOBAL innodb_ft_aux_table="test/t1";
ALTER TABLE t1 DROP INDEX fidx;
DROP TABLE t1;

attaching call stack below
[6 Oct 2017 18:19] Paul Dubois
Posted by developer:
 
Fixed in 8.0.4, 9.0.0.

Concurrent INSERT, ALTER TABLE, and DROP DATABASE operations could
result in deadlock.