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