Re: Postmaster crashes - Mailing list pgsql-general

From Tom Lane
Subject Re: Postmaster crashes
Date
Msg-id 28391.982193804@sss.pgh.pa.us
Whole thread Raw
In response to Postmaster crashes  ("Mark Alliban" <MarkA@idnltd.com>)
List pgsql-general
"Mark Alliban" <MarkA@idnltd.com> writes:
> pq_recvbuf: unexpected EOF on client connection
> Server process (pid 2087) exited with status 139 at Tue Feb 13 15:38:08 2001
> Terminating any active server processes...
> Server processes were terminated at Tue Feb 13 15:38:08 2001
> Reinitializing shared memory and semaphores

> The first line appears many times (once every few minutes) but doesn't cause
> a problem. However the server then exits and the database is down.

The unexpected-EOF messages are probably unrelated to the crash.  What
Postgres version are you running?  There should be a corefile left from
the crashed backend --- can you get a stack trace from it?  How about
running the postmaster with -d2 to log queries, so that you can see what
queries were being executed at the time of the crash?

            regards, tom lane

pgsql-general by date:

Previous
From: Jan Wieck
Date:
Subject: Re: transaction safety
Next
From: Alfonso Peniche
Date:
Subject: temp table creation