Re: Weird postmaster crashes - Mailing list pgsql-general

From Tom Lane
Subject Re: Weird postmaster crashes
Date
Msg-id 4602.1055277397@sss.pgh.pa.us
Whole thread Raw
In response to Re: Weird postmaster crashes  (Dmitry Tkach <dmitry@openratings.com>)
Responses Re: Weird postmaster crashes  (Dmitry Tkach <dmitry@openratings.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Dmitry Tkach
Date:
Subject: Re: Weird postmaster crashes
Next
From: Josh Berkus
Date:
Subject: Re: [pgsql-advocacy] MySQL gets $19.5 MM