Bug #56250 Deadlock between INSERT DELAYED and FLUSH TABLES

• Submitted: 25 Aug 2010 13:07
• Modified: 10 Mar 2014 13:01
• Reporter: Jon Olav Hauglid
• Status: Can't repeat
• Category: MySQL Server: Locking
• Severity: S3 (Non-critical)
• Version: 5.1, 5.5
• OS: Any
• Assigned to: Jon Olav Hauglid
• CPU Architecture: Any

[25 Aug 2010 13:07] Jon Olav Hauglid

Description:
Even with the fix for Bug#54332, it is possible to get a deadlock
with the combination of INSERT DELAYED and FLUSH TABLES.
The test case below also causes a deadlock in 5.1.

How to repeat:
CREATE TABLE t1 (a INT);
CREATE TABLE t2 (a INT);
connect (con1, localhost, root);

connection default;
LOCK TABLE t2 WRITE;

connection con1;
--sleep 1
--send INSERT DELAYED INTO t1 VALUES ((SELECT COUNT(*) FROM t2))

connection default;
--sleep 1
FLUSH TABLES;

[10 Mar 2014 13:01] Jon Olav Hauglid

INSERT DELAYED was removed in 5.7.0