Re: PostgreSQL crashes with Qmail-SQL - Mailing list pgsql-hackers

From Tom Lane
Subject Re: PostgreSQL crashes with Qmail-SQL
Date
Msg-id 16241.1011895899@sss.pgh.pa.us
Whole thread Raw
In response to Re: PostgreSQL crashes with Qmail-SQL  (Michael Devogelaere <michael@digibel.be>)
Responses Re: PostgreSQL crashes with Qmail-SQL  (Michael Devogelaere <michael@digibel.be>)
List pgsql-hackers
Michael Devogelaere <michael@digibel.be> writes:
> Ok: the client reported something like: 
> "Unexpected EOF from PostgreSQL-backend".

What showed up in the postmaster log when this happened?  I would like
*exact* error message texts, not approximations.

> When looking with ps aux, i noted
> that all postmaster-childs where <defunct>. I couldn't connect anymore with
> psql

What happened when you tried to connect with psql?  Again, exact, not
approximate.

It sounds like the postmaster got into a state where it was not
responding to SIGCHLD signals.  We fixed one possible cause of that
between 7.1 and 7.2, but without a more concrete report I have no way to
know if you saw the same problem or a different one.  I'd have expected
connection attempts to unwedge the postmaster in any case.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Re: Add OR REPLACE clauses to non-FUNCTION object creation in PostgreSQL 7.3
Next
From: Michael Devogelaere
Date:
Subject: Re: PostgreSQL crashes with Qmail-SQL