Lock up, but not deadlock? - Mailing list pgsql-general

From Daniel Åkerud
Subject Lock up, but not deadlock?
Date
Msg-id 001401c1c60b$856dccb0$6400a8c0@studio
Whole thread Raw
Responses Re: Lock up, but not deadlock?
List pgsql-general
Is there a possibility that there will be a lock in a transaction, but it is not a deadlock?
I have N functions (about 20-25) interacting in a system. They are like: setUserOnline(...) setUserOffline(...) setServerOnline(...) and so forth. We have found out that there are sometimes deadlocks. We have solved this by trying again 5 times. Most oftenly it works after the first retry, and worst case has been 2 so far. Anyway, is there a possibility that these functions (we have NO manual lock obtaining in them) cause lockups that is not called deadlocks but has to be solved anyway? Like an UPDATE waiting for another statement in another function, but it's not a circular thingy (a.k.a deadlock). Thanks for any help!
 
Daniel Åkerud

pgsql-general by date:

Previous
From: Joel Burton
Date:
Subject: Re: Problem with Subquery
Next
From: Alaric B Snell
Date:
Subject: Re: What are functional indices good for?