<div dir="ltr"><br><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Apr 27, 2017 at 4:03 AM, Tatsuo Ishii <span dir="ltr"><<a href="mailto:ishii@sraoss.co.jp" target="_blank">ishii@sraoss.co.jp</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">Usama,<br>
<br>
I have assigned bug 306 to you. It would be nice if you could fix and<br>
get it into 3.6.3.<br></blockquote><div><br></div><div>Yes, I am already working on this one since couple of days but unfortunately It require little more time to get to bottom of the issue and reliably fix it.</div><div><br></div><div>Thanks</div><div>Best Regards</div><div>Muhammad Usama</div><div><br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div class="HOEnZb"><div class="h5"><br>
Best regards,<br>
--<br>
Tatsuo Ishii<br>
SRA OSS, Inc. Japan<br>
English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
<br>
>> would it be possible to postpone the release 3.6.3? Recently I discovered a bug in watchdog and not reliable failover (<a href="http://www.pgpool.net/mantisbt/view.php?id=306" rel="noreferrer" target="_blank">http://www.pgpool.net/<wbr>mantisbt/view.php?id=306</a>).<br>
><br>
> Sorry, the announcement has been already in public and we can't change<br>
> it.<br>
><br>
> Best regards,<br>
> --<br>
> Tatsuo Ishii<br>
> SRA OSS, Inc. Japan<br>
> English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
> Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
><br>
>> The problem results in incorrect resolving of split brain if the Master Ppgool was disconnected from the majority of pgpool nodes. Later when it gets reconnected again after network connectivity is restored it steals back the Master status from the newly elected Master.<br>
>><br>
>><br>
>> The problem was detected in the current 3.6.2 version and rarely reproduced in the HEAD of V3_6_STABLE. Also I could detect that in V3_6_STABLE failover sometimes is not initiated.<br>
>><br>
>><br>
>> Sergey.<br>
>> ______________________________<wbr>__<br>
>> From: Sergey Kim<br>
>> Sent: Tuesday, April 25, 2017 6:05 PM<br>
>> To: Tatsuo Ishii<br>
>> Cc: <a href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a>; Alexander Andreev; Boris Voskanov; Sergey Onuchin<br>
>> Subject: Re: [pgpool-hackers: 2283] Re: pgpool-hackers Digest, Vol 66, Issue 43<br>
>><br>
>><br>
>> Tatsuo,<br>
>><br>
>><br>
>>>> ...and do you have any plans to include any code logic related changes into its current state?<br>
>>>I'm not sure what you mean by "related changes"... We will just wrap<br>
>>>the head of V3_6_STABLE branch to create 3.6.3.<br>
>><br>
>><br>
>> Ok, thank you for the answer, this is what I wanted to know. I was wondering about any possible changes that you probably would like to include into current state of V3_6_STABLE branch.<br>
>><br>
>><br>
>> Sergey<br>
>> ______________________________<wbr>__<br>
>> From: Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>><br>
>> Sent: Tuesday, April 25, 2017 5:20 PM<br>
>> To: Sergey Kim<br>
>> Cc: <a href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a>; Alexander Andreev; Boris Voskanov; Sergey Onuchin<br>
>> Subject: Re: [pgpool-hackers: 2283] Re: pgpool-hackers Digest, Vol 66, Issue 43<br>
>><br>
>>> Hi Pgpool Community,<br>
>>><br>
>>><br>
>>> Of what branch the V3.6.3 will be built from? => Will it be the current V3_6_STABLE branch?<br>
>><br>
>> Yes.<br>
>><br>
>>> ...and do you have any plans to include any code logic related changes into its current state?<br>
>><br>
>> I'm not sure what you mean by "related changes"... We will just wrap<br>
>> the head of V3_6_STABLE branch to create 3.6.3.<br>
>><br>
>> Best regards,<br>
>> --<br>
>> Tatsuo Ishii<br>
>> SRA OSS, Inc. Japan<br>
>> English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
>> Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
>><br>
>>>> The Pgpool-II developement group will make minor releases on Friday,<br>
>>>> April 28.<br>
>>>> Release versions are as follows:<br>
>>>> 3.6.3<br>
>>>> 3.5.7<br>
>>>> 3.4.11<br>
>>>> 3.3.15<br>
>>>> 3.2.20<br>
>>><br>
>>> Sergey.<br>
>>> ______________________________<wbr>__<br>
>>> From: <a href="mailto:pgpool-hackers-bounces@pgpool.net">pgpool-hackers-bounces@pgpool.<wbr>net</a> <<a href="mailto:pgpool-hackers-bounces@pgpool.net">pgpool-hackers-bounces@<wbr>pgpool.net</a>> on behalf of <a href="mailto:pgpool-hackers-request@pgpool.net">pgpool-hackers-request@pgpool.<wbr>net</a> <<a href="mailto:pgpool-hackers-request@pgpool.net">pgpool-hackers-request@<wbr>pgpool.net</a>><br>
>>> Sent: Tuesday, April 25, 2017 6:00 AM<br>
>>> To: <a href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a><br>
>>> Subject: pgpool-hackers Digest, Vol 66, Issue 43<br>
>>><br>
>>> Send pgpool-hackers mailing list submissions to<br>
>>> <a href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a><br>
>>><br>
>>> To subscribe or unsubscribe via the World Wide Web, visit<br>
>>> <a href="http://www.sraoss.jp/mailman/listinfo/pgpool-hackers" rel="noreferrer" target="_blank">http://www.sraoss.jp/mailman/<wbr>listinfo/pgpool-hackers</a><br>
>>> or, via email, send a message with subject or body 'help' to<br>
>>> <a href="mailto:pgpool-hackers-request@pgpool.net">pgpool-hackers-request@pgpool.<wbr>net</a><br>
>>><br>
>>> You can reach the person managing the list at<br>
>>> <a href="mailto:pgpool-hackers-owner@pgpool.net">pgpool-hackers-owner@pgpool.<wbr>net</a><br>
>>><br>
>>> When replying, please edit your Subject line so it is more specific<br>
>>> than "Re: Contents of pgpool-hackers digest..."<br>
>>><br>
>>><br>
>>> Today's Topics:<br>
>>><br>
>>> 1. [pgpool-hackers: 2279] Pgpool-II minor releases (Tatsuo Ishii)<br>
>>> 2. [pgpool-hackers: 2280] Inifinite retrying to connect to<br>
>>> backend (Tatsuo Ishii)<br>
>>><br>
>>><br>
>>> ------------------------------<wbr>------------------------------<wbr>----------<br>
>>><br>
>>> Message: 1<br>
>>> Date: Tue, 25 Apr 2017 10:13:50 +0900 (JST)<br>
>>> From: Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>><br>
>>> To: <a href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a>, <a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
>>> Subject: [pgpool-hackers: 2279] Pgpool-II minor releases<br>
>>> Message-ID: <<a href="mailto:20170425.101350.1214214673270602254.t-ishii@sraoss.co.jp">20170425.101350.<wbr>1214214673270602254.t-ishii@<wbr>sraoss.co.jp</a>><br>
>>> Content-Type: Text/Plain; charset=us-ascii<br>
>>><br>
>>> Hi all,<br>
>>><br>
>>> The Pgpool-II developement group will make minor releases on Friday,<br>
>>> April 28.<br>
>>><br>
>>> Release versions are as follows:<br>
>>><br>
>>> 3.6.3<br>
>>> 3.5.7<br>
>>> 3.4.11<br>
>>> 3.3.15<br>
>>> 3.2.20<br>
>>><br>
>>> Best regards,<br>
>>> --<br>
>>> Tatsuo Ishii<br>
>>> SRA OSS, Inc. Japan<br>
>>> English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
>> SRA OSS, Inc. Japan<<a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/<wbr>index_en.php</a>><br>
>> <a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">www.sraoss.co.jp</a><br>
>> We, SRA OSS, Inc., as a total solution supplier of open source software, provide consulting, software support and training services, as well as supply the PostgreSQL ...<br>
>><br>
>><br>
>><br>
>>> Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
>>><br>
>>><br>
>>> ------------------------------<br>
>>><br>
>>> Message: 2<br>
>>> Date: Tue, 25 Apr 2017 10:30:40 +0900 (JST)<br>
>>> From: Tatsuo Ishii <<a href="mailto:ishii@sraoss.co.jp">ishii@sraoss.co.jp</a>><br>
>>> To: <a href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a><br>
>>> Subject: [pgpool-hackers: 2280] Inifinite retrying to connect to<br>
>>> backend<br>
>>> Message-ID: <<a href="mailto:20170425.103040.2240088650450323667.t-ishii@sraoss.co.jp">20170425.103040.<wbr>2240088650450323667.t-ishii@<wbr>sraoss.co.jp</a>><br>
>>> Content-Type: Text/Plain; charset=us-ascii<br>
>>><br>
>>> Currently connect_with_timeout() performs infinite retry to connect to<br>
>>> backend if "retry" parameter of the function is true. This happens<br>
>>> when a client connects to Pgpool-II and there's no connection cache<br>
>>> for the request.<br>
>>><br>
>>> 2017-04-25 09:54:50: pid 9379: LOG: trying connecting to PostgreSQL server on "<a href="http://133.137.175.105:11003" rel="noreferrer" target="_blank">133.137.175.105:11003</a>" by INET socket<br>
>>> 2017-04-25 09:54:50: pid 9379: DETAIL: timed out. retrying...<br>
>>> 2017-04-25 09:54:50: pid 9379: LOCATION: pool_connection_pool.c:623<br>
>>> 2017-04-25 09:55:00: pid 9379: LOG: trying connecting to PostgreSQL server on "<a href="http://133.137.175.105:11003" rel="noreferrer" target="_blank">133.137.175.105:11003</a>" by INET socket<br>
>>> 2017-04-25 09:55:00: pid 9379: DETAIL: timed out. retrying...<br>
>>> 2017-04-25 09:55:00: pid 9379: LOCATION: pool_connection_pool.c:623<br>
>>> 2017-04-25 09:55:10: pid 9379: LOG: trying connecting to PostgreSQL server on "<a href="http://133.137.175.105:11003" rel="noreferrer" target="_blank">133.137.175.105:11003</a>" by INET socket<br>
>>> :<br>
>>> :<br>
>>><br>
>>> This continues until health check detects the unavailability of the<br>
>>> backend. Note that if health check is disabled, it continues<br>
>>> forever. Maybe we should have separate configuration parameter from<br>
>>> health check to prevent the infinite retrying?<br>
>>><br>
>>> Comments?<br>
>>> --<br>
>>> Tatsuo Ishii<br>
>>> SRA OSS, Inc. Japan<br>
>>> English: <a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/index_<wbr>en.php</a><br>
>> SRA OSS, Inc. Japan<<a href="http://www.sraoss.co.jp/index_en.php" rel="noreferrer" target="_blank">http://www.sraoss.co.jp/<wbr>index_en.php</a>><br>
>> <a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">www.sraoss.co.jp</a><br>
>> We, SRA OSS, Inc., as a total solution supplier of open source software, provide consulting, software support and training services, as well as supply the PostgreSQL ...<br>
>><br>
>><br>
>><br>
>>> Japanese:<a href="http://www.sraoss.co.jp" rel="noreferrer" target="_blank">http://www.sraoss.co.<wbr>jp</a><br>
>>><br>
>>><br>
>>> ------------------------------<br>
>>><br>
>>> ______________________________<wbr>_________________<br>
>>> pgpool-hackers mailing list<br>
>>> <a href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a><br>
>>> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-hackers</a><br>
>>> pgpool-hackers Info Page<<a href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers" rel="noreferrer" target="_blank">http://www.pgpool.net/<wbr>mailman/listinfo/pgpool-<wbr>hackers</a>><br>
>>> <a href="http://www.pgpool.net" rel="noreferrer" target="_blank">www.pgpool.net</a><<a href="http://www.pgpool.net" rel="noreferrer" target="_blank">http://www.<wbr>pgpool.net</a>><br>
>>> To see the collection of prior postings to the list, visit the pgpool-hackers Archives. Using pgpool-hackers: To post a message to all the list ...<br>
>>><br>
>>><br>
>>><br>
>>><br>
>>><br>
>>> End of pgpool-hackers Digest, Vol 66, Issue 43<br>
>>> ******************************<wbr>****************<br>
> ______________________________<wbr>_________________<br>
> pgpool-hackers mailing list<br>
> <a href="mailto:pgpool-hackers@pgpool.net">pgpool-hackers@pgpool.net</a><br>
> <a href="http://www.pgpool.net/mailman/listinfo/pgpool-hackers" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-hackers</a><br>
</div></div></blockquote></div><br></div></div>