[pgpool-general: 5721] Re: Connections stuck in CLOSE_WAIT in pgpool
Ziyun Audrey Wang
ziyun.wang at ericsson.com
Mon Sep 11 22:11:02 JST 2017
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
>>>
>>>
>>>
>>>
>>>
More information about the pgpool-general
mailing list