Re: backend exit mystery

From: Jeff <threshar(at)torgo(dot)978(dot)org>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: backend exit mystery
Date: 2003-10-11 15:00:16
Message-ID: Pine.BSF.4.44.0310111059290.85559-100000@torgo.978.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)jefftrout(dot)com>
http://www.jefftrout.com/
http://www.stuarthamm.net/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-10-11 15:22:36 Re: log_duration and \timing times repeatably much higher
Previous Message Nick Barr 2003-10-11 14:55:43 Re: go for a script! / ex: PostgreSQL vs. MySQL