Fujii Masao <[EMAIL PROTECTED]> writes:
> Because 'idle in transaction' backends that don't terminate by tcp_keepalive
> keep holding the lock.
If a backend has gotten to the point of being 'idle in transaction',
then it's certainly exchanged data with the client, so TCP keepalive
should work. I
Tom Lane wrote:
> According to that, Linux keepalive starts working once you have either
> sent or received at least one byte over the connection. Therefore it's
> not possible to get past the authentication stage without keepalive
> being ready to go. And we do have a pretty short timeout on the
Fujii Masao <[EMAIL PROTECTED]> writes:
> Linux-Kernel Archive: Re: 2.6.12.5 bug? per-socket TCP keepalive settings
> http://www.ussg.iu.edu/hypermail/linux/kernel/0508.2/0757.html
> I'm confused whether tcp_keepalive problem should be solved
> at the DB level.
According to that, Linux keepalive
Hi.
I found the cause of the error that tcp_keepalive doesn't work.
The cause is a specification of linux kernel.
In the specification of linux kernel, tcp_keepalive doesn't work
if the network outage occurs before receiving ACK for send() system-call.
This behavior of tcp_keepalive is reported e
Hi.
> You seem to have a misunderstanding of what tcp_keepalive is for. It
> does not kill a backend that is in the midst of a query. A backend will
> terminate when it is waiting for a client command and it sees that the
> connection has been lost --- which is what a TCP timeout will cause to
>
"Fujii Masao" <[EMAIL PROTECTED]> writes:
> I found an error that tcp_keepalive doesn't work.
You seem to have a misunderstanding of what tcp_keepalive is for. It
does not kill a backend that is in the midst of a query. A backend will
terminate when it is waiting for a client command and it sees
The following bug has been logged online:
Bug reference: 2576
Logged by: Fujii Masao
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.4
Operating system: Fedora Core 5
Description:tcp_keepalive doesn't work
Details:
Hi.
I found an error that tcp_keepalive d
