I am locking some rows using select for update(nowait=true) inside a transaction.If server in which code exists crashes,locks will be on rows.Those should be removed manually.I donot want that.I want to keep a timeout for that transaction.Could you please helpme out with a solution for this issue.i did not get a proper solution from internet.
On Tue, Apr 8, 2014 at 8:58 PM, Hannes Erven <hannes@erven.at> wrote:
Hi,
On 2014-04-08 15:27, Vick Khera wrote: [...]
Problem 2: you cannot have a second process skip over locked rows.
In fact, you can: use "FOR UPDATE NOWAIT" and catch any errors.
e.g. SELECT * FROM jobqueue WHERE id=? FOR UPDATE NOWAIT
