[pgpool-general: 5721] Re: Connections stuck in CLOSE_WAIT in pgpool

[Ziyun Audrey Wang]

Thank you so much Tatsuo!

We will pick it up and try it out.

Best Regards
Audrey

-----Original Message-----
From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp] 
Sent: Monday, September 11, 2017 3:40 AM
To: Ziyun Audrey Wang <ziyun.wang at ericsson.com>
Cc: pgpool-general at pgpool.net
Subject: Re: [pgpool-general: 5643] Connections stuck in CLOSE_WAIT in pgpool

Audrey,

I just want to make sure that Pgpool-II 3.6.6 was out last Tuesday.

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

From: Ziyun Audrey Wang <ziyun.wang at ericsson.com>
Subject: RE: [pgpool-general: 5643] Connections stuck in CLOSE_WAIT in pgpool
Date: Fri, 28 Jul 2017 13:01:33 +0000
Message-ID: <AM2PR07MB0548DEB10175B19DEAC90911E9BF0 at AM2PR07MB0548.eurprd07.prod.outlook.com>

> Thank you!
> 
> /Audrey
> 
> -----Original Message-----
> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp]
> Sent: Thursday, July 27, 2017 6:48 PM
> To: Ziyun Audrey Wang <ziyun.wang at ericsson.com>
> Cc: pgpool-general at pgpool.net
> Subject: Re: [pgpool-general: 5643] Connections stuck in CLOSE_WAIT in 
> pgpool
> 
> Wait... I have identified bug which could Pgpool-II stuck and just pushed the fix. We are going to release minor release (3.6.6) or newer RPM. We will announce the date soon.
> 
> Best regards,
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese:http://www.sraoss.co.jp
> 
>> The reason we use the 3.6.2 was that was the latest version that time, we have been trying many versions after 3.5.3 release, we all hit the problem.
>> 
>> We can try the 3.6.5, will it help? 
>> 
>> Thanks!
>> Audrey
>> 
>> 
>> -----Original Message-----
>> From: Tatsuo Ishii [mailto:ishii at sraoss.co.jp]
>> Sent: Thursday, July 27, 2017 2:18 AM
>> To: Ziyun Audrey Wang <ziyun.wang at ericsson.com>
>> Cc: pgpool-general at pgpool.net
>> Subject: Re: [pgpool-general: 5643] Connections stuck in CLOSE_WAIT 
>> in pgpool
>> 
>> Why do you want to upgrade to 3.6.2? The latest one is 3.6.5.
>> 
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>> 
>>> Hello
>>> 
>>> We had pgpool pgpool-II-pg94-3.5.3-1pgdg.rhel6.x86_64.rpm<http://www.pgpool.net/yum/rpms/3.5/redhat/rhel-6-x86_64/pgpool-II-pg94-3.5.3-1pgdg.rhel6.x86_64.rpm>, it worked fine, no problem.
>>> 
>>> Recently, we upgrade our pgpool and postgresql to 96 With pgpool 
>>> pgpool-II-pg96-3.6.2-1pgdg.rhel6.x86_64.rpm<http://www.pgpool.net/yu
>>> m
>>> /
>>> rpms/3.6/redhat/rhel-6-x86_64/pgpool-II-pg96-3.6.2-1pgdg.rhel6.x86_64.rpm>, we got Connections stuck in CLOSE_WAIT in pgpool And the pgpool was hung, not accept any connection.
>>> Restart the pgpool will resolve the problem but then the it will be stuck again after a while, as soon as we rollback to version pg94-3.5.3, all worked fine.
>>> 
>>> 
>>> We need to move forward with the latest release of postgresql and pgpool, but as soon as we change the version newer than pg94-3.5.3, we got the CLOSE_WAIT issue.
>>> We are wondering what's the difference between this two version,, is there anything we misconfigured?
>>> 
>>> Thanks a lot for the help!
>>> 
>>> Best Regards
>>> Audrey
>>> 
>>> 
>>> 
>>> 
>>>