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

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

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Merlin Moncure <mmoncure(at)gmail(dot)com>
Cc: Peter Eisentraut <peter_e(at)gmx(dot)net>, 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-26 17:02:35
Message-ID: 8740.1340730155@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
Merlin Moncure <mmoncure(at)gmail(dot)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

In response to

Responses

pgsql-bugs by date

Next:From: Merlin MoncureDate: 2012-06-26 17:09:22
Subject: Re: server crash with "process 22821 releasing ProcSignal slot 32, but it contains 0"
Previous:From: Merlin MoncureDate: 2012-06-26 16:25:11
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