From: Jeff Davis <pgsql@j-davis.com>
To: Frank Bax <fbax@sympatico.ca>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: DBD-pg - server closed the connection unexpectedly
Date: Fri, 09 Mar 2007 16:56:40 -0800
Message-ID: <1173488200.23455.18.camel@dogma.v10.wvs> (raw)
In-Reply-To: <5.2.1.1.0.20070309083841.03938e00@pop6.sympatico.ca>
References: <5.2.1.1.0.20070307105703.009ff740@pop6.sympatico.ca>
<5.2.1.1.0.20070307105703.009ff740@pop6.sympatico.ca>
<5.2.1.1.0.20070309083841.03938e00@pop6.sympatico.ca>
On Fri, 2007-03-09 at 08:44 -0500, Frank Bax wrote:
> At 03:20 PM 3/7/07, Tom Lane wrote:
>
> >Frank Bax <fbax@sympatico.ca> writes:
> > > Here is a portion of my script. The system() call executes successfully
> > > once, then script crashes. Any ideas why this would happen.
> >
> >What shows up in the postmaster log? Can you get a stack trace from the
> >(presumably) crashing backend?
>
>
> Backend is not crashing. When I looked at log on this busy system, I found
> out this version is producing numerous warnings about escape sequences in
> other scripts. I will attempt to clean that up; so I can isolate
> messages. I see a few messages about "unexpected EOF on client
> connection"; but I am not certain that they are from my problem script.
I had a problem with similar symptoms on FreeBSD where a kernel bug
caused a protocol violation. I am using SSL, and messages like "Host is
down" appeared in the server logs. I'm not sure what exactly happens
when not using SSL.
The problem is described here:
http://www.freebsd.org/cgi/query-pr.cgi?pr=100172
Thanks to AndrewSN for tracking it down originally.
However, you need to post more information to determine the real cause.
Regards,
Jeff Davis
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: pgsql@j-davis.com, fbax@sympatico.ca
Subject: Re: DBD-pg - server closed the connection unexpectedly
In-Reply-To: <1173488200.23455.18.camel@dogma.v10.wvs>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox