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

[Tatsuo Ishii]

Not sure about 3.4.6. The Pgpool-II development community always
recommend to upgrade to the latest stable version (3.4.10 for now).

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

> Hi Tatsuo,
> 
> EDB support suggests 3.4.6 version of pgpool, is this issue completely fixed in this version?
> You had earlier suggested 3.4.10.
> 
> Regards,
> Dhanya
> 
> -----Original Message-----
> From: pgpool-general-bounces at pgpool.net [mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Madhusudan, Dhanya
> Sent: Friday, March 31, 2017 8:43 PM
> To: Tatsuo Ishii <ishii at sraoss.co.jp>
> Cc: pgpool-general at pgpool.net
> Subject: [pgpool-general: 5408] Re: pgpool connections in DISCARD status
> 
> Thanks Tatsuo.
> As  we have to upgrade the version in production, can you verify if it has been tested with EDB 9.5?
> 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
> _______________________________________________
> pgpool-general mailing list
> pgpool-general at pgpool.net
> http://www.pgpool.net/mailman/listinfo/pgpool-general