Skip site navigation (1) Skip section navigation (2)

Re: server crash with "process 22821 releasing ProcSignal slot 32, but it contains 0"

From: Merlin Moncure <mmoncure(at)gmail(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: server crash with "process 22821 releasing ProcSignal slot 32, but it contains 0"
Date: 2012-06-25 15:03:54
Message-ID: CAHyXU0xiFbmA9GNk-DkALADbAphf5f8FCs2K5VqZ8c9KnXP98g@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-bugs
On Mon, Jun 25, 2012 at 9:57 AM, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Merlin Moncure <mmoncure(at)gmail(dot)com> writes:
>> 2012-06-25 09:08:08 CDT [postgres(at)ysanalysis_hes]: LOG:  could not
>> send data to client: Broken pipe
>> 2012-06-25 09:08:10 CDT [postgres(at)ysanalysis_hes]: LOG:  unexpected
>> EOF on client connection
>> 2012-06-25 09:08:10 CDT [postgres(at)ysanalysis_hes]: LOG:  process 22821
>> releasing ProcSignal slot 32, but it contains 0
>> 2012-06-25 09:08:10 CDT [postgres(at)ysanalysis_hes]: LOG:  failed to
>> find proc 0x7f48617e2ab0 in ProcArray
>> [and a bit later]
>> 2012-06-25 09:08:24 CDT [postgres(at)ysanalysis_hes]: FATAL:  latch already owned
>
> I think what we're looking at here is a screw-up in the process shutdown
> sequence.  Perhaps caused by bad recovery from an attempt to send an
> error message to the already-disconnected client; but that's just
> speculation, and it's hard to see how to get more info without a core
> dump.
>
> I wonder whether we shouldn't promote some or all of these three error
> cases to PANIC, as they certainly suggest shared-memory corruption.
> And if it did panic, we could hope to get a core dump for debugging
> purposes.

Ok, I'll look into reproducing the crash conditions.  Unfortunately
this is a critical server and it crashed during a time sensitive
process. I can schedule a maintenance window though but it will have
to wait a bit.

merlin

In response to

Responses

pgsql-bugs by date

Next:From: Dave PageDate: 2012-06-25 15:10:22
Subject: Re: BUG #6705: 32 bit
Previous:From: Tom LaneDate: 2012-06-25 14:57:40
Subject: Re: server crash with "process 22821 releasing ProcSignal slot 32, but it contains 0"

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group