Re: PGconn gets frozen ocassionally after select() timeout

From: Marek Peca <marek(at)duch(dot)cz>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PGconn gets frozen ocassionally after select() timeout
Date: 2009-11-13 17:19:49
Message-ID: Pine.LNX.4.64.0911131816430.3778@tesla
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> "Several hours" might be more like it.

Better than infinity, of course.

> How long have you waited?

Two days, for example.

> In any case, that complaint should be directed to your kernel vendor
> not us. We do not control how long the TCP stack waits before declaring
> the connection dead.

Well, this is what I wanted to hear. So if I call PQstatus() or PQexec(),
the libpq sends some data to the TCP pipe, and you expect, that my broken
underlying TCP/IP subsystem pretends, that the connection is OK and the
data have been sent. Right?

Thank you very much for your explanation.
Marek

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2009-11-13 17:45:10 Re: PGconn gets frozen ocassionally after select() timeout
Previous Message Joao Ferreira gmail 2009-11-13 17:15:40 safelly erasing dirs/files