Re: backend exit mystery

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Jeff <threshar(at)torgo(dot)978(dot)org>
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: backend exit mystery
Date: 2003-10-13 04:48:36
Message-ID: 200310122248.36896.pgsql@bluepolka.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Saturday October 11 2003 9:00, Jeff wrote:
> 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

Hmmm... it's quite repeatable, though not easy to predict after how many
sessions, so I don't think it's that. Happens whether memory is tight or
not.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message pginfo 2003-10-13 05:01:26 Re: go for a script! / ex: PostgreSQL vs. MySQL
Previous Message Zitan Broth 2003-10-13 04:08:20 Re: Upgrading to 7.4beta