One more thing to clarify - when you said it was fixed in .3 and .4 did you mean 7.3 or 7.2.3?
Thanks!
Dima
Tom Lane wrote:
Dmitry Tkach <[EMAIL PROTECTED]> writes:
2003-06-10 13:53:32 [14551] FATAL 1: LWLockAcquire: can't wait without a PROC structure
Could you give me some idea on what circumstances cause this to happen?
IIRC, it's an order-of-operations mistake during backend shutdown: the proc structure is deallocated while it's still possible to receive an interrupt from another backend --- and if you get such an interrupt, you need the proc. So from the user's point of view it's pretty unpredictable.
Short answer: upgrade. This is not the only nasty bug in 7.2.1.
regards, tom lane
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org