| 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: | |
| Category: | MySQL Server: DDL | Severity: | S3 (Non-critical) |
| Version: | 8.0.0 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[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.
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