Re: postmaster dies (was Re: Very disappointing performance)

Tom Lane wrote:

> secret <secret@kearneydev.com> writes:
> >>>> PostgreSQL is also crashing 1-2 times a day on me, although I have a
> >>>> handy perl script to keep it alive now <grin>...
>
> > basically the server randomly dies with a:
> > ERROR:  postmaster: StreamConnection: accept: Invalid argument
> > pmdie 3
> > (then signals all children to drop dead)
>
> Hmm.  That shouldn't happen, especially not randomly; if the accept
> works the first time then it should work forever after, since the
> arguments being passed in never change.
>
> The error is coming from StreamConnection() in
> pgsql/src/backend/libpq/pqcomm.c.  Could you maybe add some debugging
> code to the routine to see what the server_fd and port arguments are
> when accept() fails?  I think just changing the first elog() to
>
> elog(ERROR,
>      "postmaster: StreamConnection: accept: %m\nserver_fd = %d, port = %p",
>      server_fd, port);
>
> would do for starters.  This would let us eliminate the possibility that
> the routine is getting passed bad arguments.
>
> An alternative possibility is to run the postmaster under truss so you
> can see what arguments are passed to the kernel on every kernel call,
> but that'd generate a pretty verbose logfile.
>
>                         regards, tom lane
   Done.  I'll install the new binaries at the end of the day when no one is
using the database and give you a copy of the logs when it dies again.  Thank
you for the help on this, it's very much appreciated.

David Secret
MIS Director
Kearney Development Co., Inc.