Bug #46044 MDL deadlock on LOCK TABLE + CREATE TABLE HIGH_PRIORITY FOR UPDATE
Submitted: 8 Jul 2009 15:38 Modified: 7 Mar 2010 2:08
Reporter: Matthias Leich Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Locking Severity:S3 (Non-critical)
Version:5.4 OS:Any
Assigned to: Dmitry Lenev CPU Architecture:Any
Tags: deadlock, locking, mdl

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[8 Jul 2009 16:17] Matthias Leich
Grammar of creation of objects

Attachment: bug46044_data.zz (application/octet-stream, text), 214 bytes.

[8 Jul 2009 16:18] Matthias Leich
Grammar for stress testing

Attachment: bug46044_sql.yy (application/octet-stream, text), 396 bytes.

[8 Jul 2009 16:22] Matthias Leich
Test output + backtrace after kill -11 at the end

Attachment: bug.prt.gz (application/x-gzip, text), 31.75 KiB.