Orphaned Lock

[ajdavis]

I've tried searching for this answer in the posts, but I must not be using the right keywords to find it if it is out there.

I am using INNODB tables in MySQL. One thread dies while having a lock on a row. That row is now locked permanently as far as the application is concerned. No other thread can update the values in that row. Is there a command I can issue (either internal to the application or external) that will free that row up to allow updates to occur again?

Thanks in advance for any and all help.

 

[KarveR]

something here methinks:

http://dev.mysql.com/doc/refman/5.0/en/innodb-deadlock-detection.html

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.