<div dir="ltr">Hi Ishii-San<br><div class="gmail_extra"><br></div><div class="gmail_extra"><div>Sorry I was shifting my house and was away from an email so couldn't reply earlier.</div><div><br></div><div class="gmail_quote">On Tue, Oct 17, 2017 at 10:08 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:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex">Usama,<br>
<br>
Is this the fix for?<br>
<a href="https://www.pgpool.net/mantisbt/view.php?id=339" rel="noreferrer" target="_blank">https://www.pgpool.net/<wbr>mantisbt/view.php?id=339</a></blockquote><div><br></div><div>Actually there was another similar issue reported for Pgpool-II 3.6 but, The commit should also fix this problem (bug 339) for 3.5 and 3.6 branches, But as the this bug mentions the problem is also appearing in Pgpool-II 3.3, So older branches still need a fix and . because of completely different architecture of watchdog in versions prior to 3.5 we may need a completely different solution.<br></div><div><br></div><div>Thanks</div><div>Best Regards</div><div>Muhammad Usama</div><div><br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><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>
From: Muhammad Usama <<a href="mailto:m.usama@gmail.com">m.usama@gmail.com</a>><br>
Subject: [pgpool-committers: 4322] pgpool: Fix for bug in watchdog where sometime failover is not reliably<br>
Date: Mon, 16 Oct 2017 15:40:59 +0000<br>
Message-ID: <<a href="mailto:E1e47Vj-0007Zn-Dz@gothos.postgresql.org">E1e47Vj-0007Zn-Dz@gothos.<wbr>postgresql.org</a>><br>
<div class="gmail-HOEnZb"><div class="gmail-h5"><br>
> Fix for bug in watchdog where sometime failover is not reliably performed<br>
><br>
> Currently watchdog process only considers the node's watchdog state before<br>
> deciding if it can handle the failover and failover-locking requests. But the<br>
> problem with this technique is that, for the instance when the node has<br>
> announced itself as a master/coordinator of the cluster and is waiting for<br>
> the standby nodes to recognise it as a Master node. For that period of time<br>
> the watchdog state of the node is Master/coordinator, but it is yet not fully<br>
> capable of handling the failover and failover-locking requests.<br>
> So sometimes this leads to a situation where a failover is not reliably<br>
> performed in case when the failover request arrives while watchdog cluster<br>
> is in the process of electing a leader.<br>
><br>
> The fix for the above situation is to make sure that the node has fully acquired<br>
> the Master status before accepting the failover and failover-locking requests.<br>
><br>
> Branch<br>
> ------<br>
> V3_6_STABLE<br>
><br>
> Details<br>
> -------<br>
> <a href="https://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=f6ac53063da219bf3b916d6e5bbeec7a00283a77" rel="noreferrer" target="_blank">https://git.postgresql.org/<wbr>gitweb?p=pgpool2.git;a=<wbr>commitdiff;h=<wbr>f6ac53063da219bf3b916d6e5bbeec<wbr>7a00283a77</a><br>
><br>
> Modified Files<br>
> --------------<br>
> src/watchdog/watchdog.c | 12 +++++++++---<br>
> 1 file changed, 9 insertions(+), 3 deletions(-)<br>
><br>
</div></div></blockquote></div><br></div></div>