By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,727 Members | 768 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,727 IT Pros & Developers. It's quick & easy.

All activity on database locked

P: n/a
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.

Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.