Re: PGconn gets frozen ocassionally after select() timeout - Mailing list pgsql-general

From Tom Lane
Subject Re: PGconn gets frozen ocassionally after select() timeout
Date
Msg-id 4578.1258132357@sss.pgh.pa.us
Whole thread Raw
In response to Re: PGconn gets frozen ocassionally after select() timeout  (Marek Peca <marek@duch.cz>)
Responses Re: PGconn gets frozen ocassionally after select() timeout  (Marek Peca <marek@duch.cz>)
List pgsql-general
Marek Peca <marek@duch.cz> writes:
> However: I can not get the point, why does the PQexec() (or PQstatus() at
> least) hang, instead of returning some error? I know, that situation with
> broken TCP connection may involve long timeouts, but it could return at
> least after several minutes, couldn't it?

"Several hours" might be more like it.  How long have you waited?
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.

            regards, tom lane

pgsql-general by date:

Previous
From: Marek Peca
Date:
Subject: Re: PGconn gets frozen ocassionally after select() timeout
Next
From: Marek Peca
Date:
Subject: Re: PGconn gets frozen ocassionally after select() timeout