Hi all,
We are having a tough time tracking down a problem with my MySQL
database.
The version is 3.23.58 running as the backend for Request Tracker (rt2)
by Best Practical.
Occasionally (once every 3-4 days) all running queries on the table
will be "locked". We use MySQL for a number of different purposes, and
I can normally nail the problem down to a specific slow query, but that
is not the case here. I cannot find any running queries at all. All
connections are either in "Sleep" or "Locked".
Has anyone else ever seen this? Is there a way I can determine which
query is locking the others? Based on the time field from "SHOW FULL
PROCESSLIST" I can tell which query has been locked the longest, and
attampts to kill it never succeed.
I am hesitant to upgrade to the 4.0 series until I have exhausted all
other possibilities. We have had difficulty in the past with migrating
internal apps to 4.0, so I am not sure I want to dig upgrade for an app
we aren't familiar with (rt2).
For completeness, you should know all tables are MyISAM and when I view
the processlist, I am logged in to MySQL as root.
Chris Back
System Administrator
Bitpipe, Inc.