[pgpool-general: 5412] Re: pgpool connections in DISCARD status

[Tatsuo Ishii]

Dhanya,

> Thanks Tatsuo.
> As  we have to upgrade the version in production, can you verify if it has been tested with EDB 9.5?

Sorry, I'm not in a position to verify EDB products...

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> I raised a case with EDB support and they  are suggesting to upgrade to the latest version (3.4.5).
> 
> Regards,
> Dhanya
> 
> -----Original Message-----
> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp] 
> Sent: Friday, March 31, 2017 1:32 PM
> To: Madhusudan, Dhanya <dhanya.madhusudan at hpe.com>
> Cc: pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 5403] pgpool connections in DISCARD status
> 
> Pgpool-II 3.4.3 is pretty old (released on Apri 2015). I recommend you to obtain the latest one (3.4.10). I also I think you could ask support from EDB.
> 
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> 
>> Hi,
>> 
>> We are using EDB 9.5 and pgpool 3.4.3.
>> We see increasing number of pgpool connections in the DISCARD/ABORT status in spite of the configuring client_idle_limit.
>> ps -aef | grep pgpool | grep DISCARD | wc -l
>> 290
>> 
>> We are killing these processes manually now, to avoid a situation where there are no free connections available.
>> 
>> Please find attached our pgpool configuration and recommend any changes that would release these connections.
>> 
>> TIA,
>> Dhanya