Bug #41335 | queries to MySQL 5.1.x block in state "opening tables" and "closing tables" | ||
---|---|---|---|
Submitted: | 9 Dec 2008 18:33 | Modified: | 8 Dec 2009 19:41 |
Reporter: | Hristo Erinin | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: Locking | Severity: | S1 (Critical) |
Version: | 5.1.25 and 5.1.29 | OS: | Linux |
Assigned to: | CPU Architecture: | Any | |
Tags: | closing tables, innodb, lock-up, lockup, myisam, opening tables |
[9 Dec 2008 18:33]
Hristo Erinin
[10 Dec 2008 7:24]
Sveta Smirnova
Thank you for the report. But there is not any attachment. Please attach.
[15 Dec 2008 19:21]
Hristo Erinin
The server locked up again today. During the lock-up no queries that involve any table operation can complete. Even select * from information_schema.tables; locks up indefinitely. SHOW * queries work without problem. I've uploaded another set of files on the ftp server. bug-data-20081215-41335.zip is the filename on ftp.mysql.com. Also, attached to this bug report you can find the output of SHOW ENGINE INNODB STATUS command. Thanks, Hristo
[8 Nov 2009 19:41]
Valeriy Kravchuk
Please, try to repeat with a newer version, 5.1.40. In case of the same problem, please, send the results of SHOW FULL PROCESSLIST and your my.cnf file content.
[9 Dec 2009 0: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".