Re: Weird postmaster crashes

Dmitry Tkach <dmitry@openratings.com> 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