[pgpool-general: 1766] Re: Persistent "Idle in transaction" connections
Tatsuo Ishii
ishii at postgresql.org
Wed May 22 19:40:00 JST 2013
No, connection_life_time is for between pgpool and PostgreSQL, not
client and pgpool. So client_idle_limit is the right choice. However
we recently found a problem which might be related to Juan's problem.
http://git.postgresql.org/gitweb/?p=pgpool2.git;a=commit;h=c63a92ef6dc4e0bc7bda7eaeb170e1b61c1ffa52
If there's an activity found in pg_stat_activity as descrived in the
commit message, you might want to try the patch.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp
> Hi Juan,
>
> If I understand correctly I think you want pgpools "connection_life_time" parameter, and if you're still having problems with dropped connections look at your kernels tcp_keepalive parameters.
>
>
> Glyn
>
>
> ----- Original Message -----
>> From: Juan Jose Perez <jperez at oteara.com>
>> To: pgpool-general at pgpool.net
>> Cc:
>> Sent: Wednesday, 22 May 2013, 10:42
>> Subject: [pgpool-general: 1764] Persistent "Idle in transaction" connections
>>
>>
>> Hi all,
>>
>> Sorry if this question is answered somewhere but I couldn't find it.
>>
>> We have a client application using pgpool 3.1.2 and postgres 9.1 in
>> master-slave with streaming replication.
>> This application is unreliable so it can be shutdown at any time.
>> When this happens, its connection with pgpool remains in "idle in
>> transaction" state forever. To avoid this I changed client_idle_limit
>> parameter to 600 (this value should be enough to free broken connections
>> before pgpool collapses), but it isn't closing those connections.
>> Is client_idle_limit the appropriate parameter to control
>> connections in this situation or there is another way to protect pgpool
>> from this client behavior?
>>
>> Many thanks,
>>
>> --
>> Juanjo Pérez
>>
>> www.oteara.com
>>
>> _______________________________________________
>> pgpool-general mailing list
>> pgpool-general at pgpool.net
>> http://www.pgpool.net/mailman/listinfo/pgpool-general
>>
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general
More information about the pgpool-general
mailing list