MySQL Bugs: #45544: items with "freeing items" and "Sending data" never finish

Bug #45544	items with "freeing items" and "Sending data" never finish
Submitted:	17 Jun 2009 2:11	Modified:	13 Jul 2009 6:24
Reporter:	Ala'a Ibrahim	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.1.34-community-log MySQL Community Ser	OS:	Linux
Assigned to:		CPU Architecture:	Any
Tags:	freeing items, lock, sending data, Stuck

Description:
In one of the servers we have an issue that happens to one of the servers that some items that have the status of "freeing items" and "Sending data" are just stuck there, causing a lot of locks on the server, and the load of the server drops to almost 0.

The server then wouldn't restart, and the only solution is to kill the mysqld process, and fix the crashed tables that result from the kill.

How to repeat:
There is no specific knowledge of when does this happens or why, but it happens like once every 3 days.

Thank you for the report.

Do you have query cache enabled? Do you use InnoDB tables? See last comment to bug #42951 if so and check if suggestion solves your problem.

I'm from ala'a team

this is vbulletin system, all tables is myisam, and only one table innodb (session table).

we configured innodb to work as memory, innodb data file and log files store in memory partition for more performance.

Query cache is enabled.

I'll attache my.cnf file.

we've 32GB RAM.

my.cnf

Attachment: my.conf (application/octet-stream, text), 1.83 KiB.

Thank you for the feedback.

Please try to turn query cache off and test if it solves the problem: this can be duplicate of bug #43758

Thank for your feedback

I turn query cache off, and I'll test.

It's fine till now.

Thank you for the feedback. 

Closed as duplicate of bug #43758. Please upgrade to version 5.1.36 where bug #43758 is fixed.