<div dir="rtl"><div dir="ltr">I can see now that this design is no good, going to throw away the ping stuff, instead going to implement: recover_false_primary,</div><div dir="ltr">That is, if detach_false_primary is true, And if we detect and mark false primary, we might as well initiate start_recovery on it (making it valid standby)<br></div></div><br><div class="gmail_quote"><div dir="rtl">בתאריך יום ה׳, 3 בינו׳ 2019 ב-23:59 מאת Asaf Ohayon <<a href="mailto:asaf@sysbind.co.il">asaf@sysbind.co.il</a>>:<br></div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);padding-left:1ex"><div dir="rtl"><div dir="rtl"><div dir="rtl"><div dir="rtl"><div dir="rtl"><div dir="ltr">Hello</div><div dir="ltr"><br></div><div dir="ltr">I've started to implement auto-recovery here:</div><div dir="ltr"><a href="https://github.com/SysBind/pgpool2/commit/bc5c1b4029c569470917b72386623146fdf19415" target="_blank">https://github.com/SysBind/pgpool2/commit/bc5c1b4029c569470917b72386623146fdf19415</a></div><div dir="ltr"></div><div dir="ltr"><br></div><div dir="ltr">Seeking for a little advice, done so far:</div><div dir="ltr"><br></div><div dir="ltr">In health_check main loop, if the node is in degenerated state,</div><div dir="ltr">try to ping it, when it repsonses, (like coming up after reboot),</div><div dir="ltr">execute online-recovery on it.</div><div dir="ltr"><br></div><div dir="ltr">Issues:</div><div dir="ltr">1. Altough degenerated backend seems down (e.g: in pcp_node_info),</div><div dir="ltr">in recovery() I get:</div><div dir="ltr">node recovery failed, node id: %d is alive,</div><div dir="ltr"><br></div><div dir="ltr">2. Still need some code to mark the node as candidate for auto-recovery, and not try to <br></div><div dir="ltr">establish_persistent_connection to it</div><div dir="ltr"><br></div><div dir="ltr">Any remarks are welcome</div><div dir="ltr"><br></div><div dir="ltr">Thanks<br></div><div><div dir="ltr"><br></div><div dir="rtl"><br></div><div dir="rtl"><br></div><div dir="rtl">-- <br><div dir="ltr" class="gmail-m_8808893514010111474gmail-m_-4579688348021252368gmail_signature"><br>Asaf Ohayon<br>SRE | SysBind<br>M: +972 547920828<br>P: + 972 3 5096219<br>E: <a href="mailto:asaf@sysbind.co.il" target="_blank">asaf@sysbind.co.il</a><br>Rothschild 60, Bat Yam<br><a href="http://www.sysbind.co.il" target="_blank">www.sysbind.co.il</a><br></div></div></div></div></div></div></div></div>
</blockquote></div><br clear="all"><br>-- <br><div dir="ltr" class="gmail_signature"><br>Asaf Ohayon<br>SRE | SysBind<br>M: +972 547920828<br>P: + 972 3 5096219<br>E: <a href="mailto:asaf@sysbind.co.il" target="_blank">asaf@sysbind.co.il</a><br>Rothschild 60, Bat Yam<br><a href="http://www.sysbind.co.il" target="_blank">www.sysbind.co.il</a><br></div>