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

[Ziyun Audrey Wang]

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/yum
>> / 
>> 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
>> 
>> 
>> 
>> 
>>