[pgpool-general: 1766] Re: Persistent "Idle in transaction" connections

[Tatsuo Ishii]

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