Re: backend exit mystery

From: Ed Loehr <ed(at)LoehrTech(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: backend exit mystery
Date: 2003-10-14 01:06:28
Message-ID: 200310131906.28420.ed@LoehrTech.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Friday October 10 2003 4:46, 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.

Still looking for clues as to the cause of this repeatable connection
failure. Passing an explicit connection timeout to PQconnectdb() escapes
from any long hangs, but the hanging is still an issue I'd like to
understand. Attached is a small C program that reliably reproduces this
problem on the setup above. I added an explicit timeout to PQconnectdb()
to wait only 30 seconds. I'm curious to know if anyone can easily repeat
the problem (careful, it will generate a bit of traffic, cpu load, and run
forever). My last example run showed 17 timeouts seemingly randomly
dispersed among 5000 consecutive connection attempts.

The server has plenty of available memory on a dual processor machine
running Linux 2.4.18-3smp. Tried to catch snapshot data from netstat on
Recv-Q and Send-Q sizes on the server during a hang... that's a little iffy
with the timing of grepping netstat output, but seems like the server's
Recv-Q's were always zero and the Send-Q's were occasional in the tens
(bytes?).

TIA for any help.

Attachment Content-Type Size
t.c text/x-csrc 2.1 KB

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-10-14 01:14:45 Re: Humor me: Postgresql vs. MySql (esp. licensing)
Previous Message Tom Lane 2003-10-14 00:50:48 Re: Does postgresql support HKSCS ?