Bug #69862 Database hang with many sessions with "query end" status
Submitted: 29 Jul 2013 2:13 Modified: 29 Aug 2013 12:01
Reporter: Steven Wong Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: General Severity:S1 (Critical)
Version:5.5.11-log OS:Linux (CentOS release 6.3 (Final))
Assigned to: CPU Architecture:Any
Tags: END, query end

[29 Jul 2013 2:13] Steven Wong 
Description:
We experienced database hang a few times in a week, with many sessions in "query end" status. Seems that all insert/update/delete on different tables were hang, select query was ok. We tried to killed sessions and the sessions was still there. We needed to restart by kill -9 MySQL process finally. We've disabled query cache (query_cache_size = 0), and also set innodb_flush_log_at_trx_commit to 0, but no use.

How to repeat:
Cannot reproduce at will.
[29 Jul 2013 12:01] MySQL Verification Team 
Thank you for the bug report. Please try latest released version 5.5.32 (5.5.11 is quite older). Thanks.
[30 Aug 2013 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".