Re: backend exit mystery - Mailing list pgsql-general

From Jeff
Subject Re: backend exit mystery
Date
Msg-id Pine.BSF.4.44.0310111059290.85559-100000@torgo.978.org
Whole thread Raw
In response to backend exit mystery  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: backend exit mystery  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
On Fri, 10 Oct 2003, Ed L. wrote:

> I have libpq client program that repeatedly connects to a DB, queries, and
> then disconnects.  After a seemingly random number of such successful
> sessions (sometimes 30, sometimes hundreds), the backend mysteriously exits
> after the client calls PQsetdbLogin(), and the client hangs.  Any clues?
> Details below...
>
> Client:  C program linked with 7.2.1 libpq on HP-UX B.11.00 E 9000/803.
> Server:  PostgreSQL 7.3.2 on i686-pc-linux-gnu, compiled by GCC 2.96.
>

How's the memory situation on the server box?
Don't forget linux has that GREAT feature that randomly kills processes
when memory is tight.... Perhaps there's something in syslog
--
Jeff Trout <jeff@jefftrout.com>
http://www.jefftrout.com/
http://www.stuarthamm.net/



pgsql-general by date:

Previous
From: Network Administrator
Date:
Subject: Re: Interfaces that support cursors
Next
From: Bruce Momjian
Date:
Subject: Re: log_duration and \timing times repeatably much higher