Re: 7.3.2 closing connections, sometimes - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.3.2 closing connections, sometimes
Date
Msg-id 29527.1120677040@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.3.2 closing connections, sometimes  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: 7.3.2 closing connections, sometimes
List pgsql-general
> felix@crowfix.com wrote:
>> This is a SOAP server, Apache with mod_perl, connecting to Postgres
>> via DBI/DBD::Pg.  Sometimes it gets in a mood, for want of a better
>> term, where a specific SQL statement fails with the good ole message
>> "server closed the connection unexpectedly".  It will fail like this

The specific statement being what exactly?

Bruce Momjian <pgman@candle.pha.pa.us> writes:
> This message is from the backend exiting abruptly.  Is isn't an "ERROR"
> as we define it for logging purposes.  That's why there is nothing in
> the logs.

Nonetheless I'd expect there to be at least a postmaster complaint about
a crashed backend --- assuming that that's what's going on.  Do the
other active connections get forcibly closed when this happens?

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Transaction id wraparound questions
Next
From: Tino Wildenhain
Date:
Subject: Re: Scripting Functions to Separate Files