Bug #57579 blobs cause a thread to wait for itself endlessly, before long semaphore death
Submitted: 19 Oct 2010 19:10 Modified: 9 Dec 2010 18:44
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: InnoDB storage engine Severity:S1 (Critical)
Version:5.5.6, 5.5.8-debug OS:Any
Assigned to: Marko Mäkelä CPU Architecture:Any

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:

[19 Oct 2010 19:12] Shane Bester
some details....

Attachment: bug57579_5.5.6_error_stack.txt (text/plain), 20.12 KiB.

[19 Oct 2010 19:13] Shane Bester
run this is two or more threads for however long it takes...

Attachment: zlibdml.php (, text), 6.35 KiB.

[20 Oct 2010 5:06] Shane Bester
debug infos from 5.5.8-debug where i repeated with 3 threads of zlibdml.php and 2 hours runtime

Attachment: bug57579_5.5.8-debug-repeated-gdb-info.txt (text/plain), 75.92 KiB.

[21 Oct 2010 2:51] Shane Bester
more 5.5.8 debug of another hang infos from latest build

Attachment: bug57579_mysql-5.5-innodb-revno3192-gdb-debug.txt (text/plain), 135.98 KiB.

[24 Oct 2010 5:35] Shane Bester
Marko, 4 threads of *this* zlibdml on 5.5 hangs in a few minutes. let me know if you need more details??

Attachment: zlibdml.php (, text), 7.07 KiB.