From: | "Fujii Masao" <fujii(dot)masao(at)oss(dot)ntt(dot)co(dot)jp> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2576: tcp_keepalive doesn't work |
Date: | 2006-08-15 08:12:33 |
Message-ID: | 200608150812.k7F8CXTq048890@wwwmaster.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2576
Logged by: Fujii Masao
Email address: fujii(dot)masao(at)oss(dot)ntt(dot)co(dot)jp
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 doesn't work.
The sequence of steps to reproduce the problem is as follow.
----------
[terminal 1]
$ postmaster -p xxxx
NOTE:
- postgresql.conf that I changed from the default is as follow.
listen_addresses = '*'
tcp_keepalives_idle = 10
tcp_keepalives_interval = 5
tcp_keepalives_count = 2
- I add the Client Authentication Record to pg_hba.conf.
host all all xx.xx.xx.xx/xx trust
[terminal 2]
$ pgbench testdb -c 50 -t 100 -h xx.xx.xx.xx -p xxxx
[terminal 3]
# /sbin/ifdown eth0 #ifdown while running pgbench
Then, 50 postgres processes keep alive though tcp_keepalive
should kill them within 30 seconds at latest.
[terminal 4]
$ sleep 30
$ ps -ef | grep postgres
...
postgres 16815 16782 0 17:06 pts/1 00:00:00 postgres: postgres sampledb
xx.xx.xx.xx(38738) idle in transaction
postgres 16816 16782 0 17:06 pts/1 00:00:00 postgres: postgres sampledb
xx.xx.xx.xx(38739) UPDATE waiting
postgres 16817 16782 0 17:06 pts/1 00:00:00 postgres: postgres sampledb
xx.xx.xx.xx(38740) UPDATE waiting
postgres 16818 16782 0 17:06 pts/1 00:00:00 postgres: postgres sampledb
xx.xx.xx.xx(38741) UPDATE waiting
postgres 16819 16782 0 17:06 pts/1 00:00:00 postgres: postgres sampledb
xx.xx.xx.xx(38742) UPDATE waiting
postgres 16820 16782 0 17:06 pts/1 00:00:00 postgres: postgres sampledb
xx.xx.xx.xx(38743) idle in transaction
postgres 16821 16782 0 17:06 pts/1 00:00:00 postgres: postgres sampledb
xx.xx.xx.xx(38744) UPDATE waiting
postgres 16822 16782 0 17:06 pts/1 00:00:00 postgres: postgres sampledb
xx.xx.xx.xx(38745) UPDATE waiting
postgres 16823 16782 0 17:06 pts/1 00:00:00 postgres: postgres sampledb
xx.xx.xx.xx(38746) idle
...
----------
I'll be pleased if you cope with the problem.
Thanks in advance.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-08-15 13:30:16 | Re: BUG #2576: tcp_keepalive doesn't work |
Previous Message | Reece Hart | 2006-08-14 22:11:49 | Re: text datum VARDATA and strings |