Bug #26414 MyISAM table repeatedly locks
Submitted: 15 Feb 2007 16:55 Modified: 16 Mar 2007 11:56
Reporter: [ name withheld ] Email Updates:
Status: No Feedback Impact on me:
Category:MySQL Server: MyISAM storage engine Severity:S2 (Serious)
Version:5.0.22-0ubuntu6.06.2 OS:
Assigned to: CPU Architecture:Any

[15 Feb 2007 16:55] [ name withheld ]
I have a user running a MyISAM database that is repeatedly hanging their tables while doing inserts.  MySQL quickly hits the user limit (30) and stops answering connections until threads are killed.  Running the SMP kernel.  No errors are produced in the syslog until the threads are killed, at which point the tables are reported needing repair.

The below debug output is taken during the latest hung database.  At the time, three tables in the processlist were in the "update" state.  One inserting into "packages" one inserting into "packages_installed" one inserting into "hosts"

How to repeat:
I haven't discovered a specific method of repeating this issue, however it recurs for this user with random insert traffic on the order of every few hours to every few days.
[16 Feb 2007 11:56] Valeriy Kravchuk
Thank you for a problem report. Please, send SHOW PROCESSLIST results next time this will happen. Is it 64-bit AMD you are running on? What version of glibc do you have?

Please, try to use newer version, 5.0.27, also, and inform about the results.
[17 Mar 2007 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".