[pgpool-general: 5415] Re: pgpool connections in DISCARD status
Madhusudan, Dhanya
dhanya.madhusudan at hpe.com
Wed Apr 5 14:06:56 JST 2017
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
More information about the pgpool-general
mailing list