Deadlock removal
Started by Albrecht Stephen (LWE)over 21 years ago2 messagesgeneral
Hi,
I have somehow managed to lock a row in one of my database tables, and I am now unable to unlock that row.
I have tried using the ROLLBACK command, but get a notice: NO TRANSACTION IN PROGRESS. However, when I try to update or delete the record, the query never executes, and I have to cancel it manually, at which point I get the error: QUERY CANCEL REQUESTED WHILE WAITING LOCK.
Anybody know how I can simply get rid of this lock?
Thanks,
Stephen.
Re: Deadlock removal
Albrecht Stephen (LWE) wrote:
Anybody know how I can simply get rid of this lock?
A lock can only be held by a running transaction. Therefore, to release
the lock for sure, terminate all other running transactions.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/