Re: Core dump - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Core dump
Date
Msg-id 28973.971388873@sss.pgh.pa.us
Whole thread Raw
In response to Re: Core dump  (Dan Moschuk <dan@freebsd.org>)
Responses Re: Core dump  (Dan Moschuk <dan@freebsd.org>)
List pgsql-hackers
Dan Moschuk <dan@freebsd.org> writes:
> It would appear from that very rough test program that solaris doesn't mind
> system calls from within a signal handler.

Still, it's a mighty peculiar backtrace.

After looking at postmaster.c, I see that the postmaster will issue
SIGUSR1 to all remaining backends *each* time it sees a child exit
with nonzero status.  And it just so happens that quickdie() chooses
to exit with exit(1) not exit(0).  So a new theory is

1. Some backend crashes.

2. Postmaster issues SIGUSR1 to all remaining backends.

3. As each backend gives up the ghost, postmaster gets another wait()  response and issues another SIGUSR1 to the ones
thatare left.
 

4. Last remaining backend has been SIGUSR1'd enough times to overrun  stack memory, leading to coredump.

I'm not too enamored of this theory because it doesn't explain the
perfect repeatability shown in your backtrace.  It seems unlikely that
each recursive quickdie() call would get just as far as elog's write()
and no farther before the postmaster is able to issue another signal.
Still, it's a possibility.

We should probably tweak the postmaster to be less enthusiastic about
signaling its children repeatedly.

Meanwhile, have you tried looking in the postmaster log?  The postmaster
should have logged at least the exit status for the first backend to
fail.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Marko Kreen
Date:
Subject: Re: Precedence of '|' operator (was Re: [patch,rfc] binary operators on integers)
Next
From: Dan Moschuk
Date:
Subject: Re: Core dump