[pgpool-general: 5654] Re: Connections stuck in CLOSE_WAIT in pgpool
Ziyun Audrey Wang
ziyun.wang at ericsson.com
Fri Jul 28 22:01:33 JST 2017
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.
SRA OSS, Inc. Japan
> 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?
> -----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
> 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
>> 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
>> 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
More information about the pgpool-general