Re: server crash with "process 22821 releasing ProcSignal slot 32, but it contains 0" - Mailing list pgsql-bugs

From Tom Lane
Subject Re: server crash with "process 22821 releasing ProcSignal slot 32, but it contains 0"
Date
Msg-id 8740.1340730155@sss.pgh.pa.us
Whole thread Raw
In response to Re: server crash with "process 22821 releasing ProcSignal slot 32, but it contains 0"  (Merlin Moncure <mmoncure@gmail.com>)
Responses Re: server crash with "process 22821 releasing ProcSignal slot 32, but it contains 0"
List pgsql-bugs
Merlin Moncure <mmoncure@gmail.com> writes:
> I suspect (but haven't had time to prove and may not for several days
> -- unfortunately going on vacation momentarily) that this might be
> caused by pl/sh.

Hm.  The reported symptoms might be explainable if something had caused
multiple threads to become active within the backend process --- then
it would be plausible for it to try to do proc_exit cleanup twice.
Which would explain the first two errors, though I'm not sure how that
leads to failing to disown the process latch, as the third error
suggests must have happened.  But I don't know enough about pl/sh to
know if it could cause threading activation.

> In particular, we have a routine that was
> inadvertently applied to the database in with windows cr/lf instead of
> the normal linux newline.

This doesn't seem real promising as an explanation ...

            regards, tom lane

pgsql-bugs by date:

Previous
From: lifeair@gmail.com
Date:
Subject: BUG #6707: ERROR: could not open relation with OID
Next
From: Merlin Moncure
Date:
Subject: Re: server crash with "process 22821 releasing ProcSignal slot 32, but it contains 0"