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

Ziyun Audrey Wang ziyun.wang at ericsson.com
Thu Jul 27 22:04:46 JST 2017

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

> 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

More information about the pgpool-general mailing list