Bug #7823 FLUSH TABLES WITH READ LOCK + INSERT DELAYED = deadlock
Submitted: 12 Jan 2005 3:49 Modified: 28 Apr 2005 18:07
Reporter: Christopher L. Cousins
Status: Closed
Category:Server Severity:S3 (Non-critical)
Version:4.0.23 OS:Linux (Red Hat Enterprise Linux)
Assigned to: Ingo Strüwing Target Version:

File: Maximum allowed size is 500KB.
Description:
Privacy:

If the data you need to attach is more than 500KB, you should create a compressed archive of the data and a README file that describes the data with a filename that includes the bug number (example: bug-data-7823.zip), and use FTP to upload the archive to ftp://ftp.mysql.com/pub/mysql/upload/. Once you have uploaded the file, add a comment to this bug to notify us about it. Note: This directory is unlistable, which means that once you have uploaded your file, you will not be able to see it.

All entries become the exclusive editorial property of Sun Microsystems, Inc.

[12 Jan 2005 3:52] Christopher L. Cousins 
generate 'INSERT DELAYED ...' SQL file

Attachment: id.py (application/octet-stream, text), 435 bytes.
[12 Jan 2005 3:52] Christopher L. Cousins 
generate 'FLUSH TABLES WITH READ LOCK' SQL file

Attachment: ftwrl.py (application/octet-stream, text), 143 bytes.
[4 Feb 2005 15:37] Ingo Strüwing 
My test script. We cannot test concurrency in the normal MySQL test suite.

Attachment: bug7823-1.sh (application/x-sh, text), 5.51 KiB.