MySQL Bugs: #39091: A process stucks in END state and never dies locking a table forever.

Bug #39091	A process stucks in END state and never dies locking a table forever.
Submitted:	28 Aug 2008 12:57	Modified:	14 Jan 2013 18:04
Reporter:	francesco pinta	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server: Query Cache	Severity:	S1 (Critical)
Version:	5.1.26, 5.1.31, 5.1.45, 5.1.49	OS:	Any (w2k,sles10)
Assigned to:	Matthew Lord	CPU Architecture:	Any
Tags:	end state, KILL, lock, PROCESSLIST

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:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

Output of the "SHOW PROCESSLIST"

Attachment: showprocesslist.txt (text/plain), 8.99 KiB.

Here's the processlist

Attachment: processlist.txt (text/plain), 5.02 KiB.

my.cnf

Attachment: my.cnf.txt (text/plain), 1.71 KiB.

show processlist in locked/end/killed state

Attachment: processes.txt (text/plain), 28.31 KiB.

mysqladmin debug output of same situation

Attachment: syslog.txt (text/plain), 11.16 KiB.

Output of SHOW ENGINE INNODB STATUS

Attachment: innodb_engine_status.txt (text/plain), 62.58 KiB.

Process list output, MyISAM, version 5.1.31-community

Attachment: nambar_processlist.txt (text/plain), 70.09 KiB.

output of gdb: thread apply all bt full

Attachment: gdb_all_bt_full.txt (text/plain), 461.55 KiB.

output of gdb: thread apply all bt

Attachment: gdb_all_bt.txt (text/plain), 310.71 KiB.

Output of gdb running mysqld-debug and havin threads stuck in "end" state

Attachment: gdb_mysqld-debug_output.zip (application/zip, text), 397.89 KiB.