MySQL Bugs: #70883: "hash index ref_count is not zero" MySQL to freeze

Bug #70883	"hash index ref_count is not zero" MySQL to freeze - impossible to shutdown
Submitted:	11 Nov 2013 19:31	Modified:	14 Dec 2013 17:50
Reporter:	daniel Urbah	Email Updates:
Status:	No Feedback	Impact on me:	None
Category:	MySQL Server: Errors	Severity:	S1 (Critical)
Version:	5.5.30-mariadb1~squeeze	OS:	Linux (debian squeeze)
Assigned to:		CPU Architecture:	Any
Tags:	hash index crash

Description:
The following 2 lines start appearing in mysql error log every 5 seconds :

InnoDB: Warning: hash index ref_count (37) is not zero after fil_discard_tablespace().
index: "PRIMARY" table: "[DB name]/[table name]"

Concurrently MySQL freezes and no query is treated anymore.

Then when trying to shutdown :
...
InnoDB: Error: Waited for 100 secs for hash index ref_count (37) to drop to 0.
InnoDB: Error: Waited for 105 secs for hash index ref_count (37) to drop to 0.
...
I have to kill -9 the mysqld process in order to shut MySQL.

How to repeat:
I do not know how
It occured 4 times in the last 10 days

Thank you for the report.

Which exact minor version of MySQL do you use?

hello,
I am running mysql version 5.5.30-mariadb1~squeeze

Thank you for the feedback.

But this is not Oracle version of MySQL. Please try with current Oracle version of MySQL: 5.5.34 and inform us if the issue still exists.

You can download official Oracle version from dev.mysql.com/downloads

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".