Re: Weird postmaster crashes - Mailing list pgsql-general

From Dmitry Tkach
Subject Re: Weird postmaster crashes
Date
Msg-id 3EE653E2.9050806@openratings.com
Whole thread Raw
In response to Re: Weird postmaster crashes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Weird postmaster crashes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Makes sense. Thanks!

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 <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: Ernest E Vogelsinger
Date:
Subject: Re: Index not being used in MAX function (7.2.3)
Next
From: Tom Lane
Date:
Subject: Re: increment_by@