<html><body><div style="color:#000; background-color:#fff; font-family:Courier New, courier, monaco, monospace, sans-serif;font-size:10pt">Hi All,<br style="" class=""><br style="" class="">I'm testing the changes to failover in 2.2.2 and seem to be running into issues passing multiple nodes to failover. In the following scenario with 4 nodes, node 2 is the origin of all sets and node 3 is a forwarding provider to node 4, i.e.<br style="" class=""><br style="" class="">1 <---- 2 ----> 3 ----> 4<br style="" class=""><br style="" class="">I'm attempting to fail over in a scenario where both nodes 2 and 3 have failed, so postgres is stopped for both of those nodes. I'm running the following script:<br style="" class=""><br style="" class=""><span class="" style="color: rgb(76, 118, 162)">CLUSTER NAME = test_replication;<br style="" class="">NODE 1 ADMIN CONNINFO = 'dbname=TEST host=localhost port=5432 user=slony';<br style=""
class="">NODE 2 ADMIN CONNINFO = 'dbname=TEST host=localhost port=5433 user=slony';<br style="" class="">NODE 3 ADMIN CONNINFO = 'dbname=TEST host=localhost port=5434 user=slony';<br style="" class="">NODE 4 ADMIN CONNINFO = 'dbname=TEST host=localhost port=5435 user=slony';<br style="" class="">FAILOVER (<br style="" class=""> NODE = (ID = 2, BACKUP NODE = 1),<br style="" class=""> NODE = (ID = 3, BACKUP NODE = 1)<br style="" class="">);</span><br style="" class=""><br style="" class="">However it would appear that slonik will wait indefinitely for node 4 to catch up via failed node 3:<br style="" class=""><br style="" class=""><span class="" style="color: rgb(76, 118, 162)">$ slonik test.scr<br style="" class="">test.scr:3: could not connect to server: Connection refused<br style="" class=""> Is the server running on host "localhost" (127.0.0.1) and accepting<br style=""
class=""> TCP/IP connections on port 5433?<br style="" class="">test.scr:4: could not connect to server: Connection refused<br style="" class=""> Is the server running on host "localhost" (127.0.0.1) and accepting<br style="" class=""> TCP/IP connections on port 5434?<br style="" class="">executing preFailover(2,1) on 1<br style="" class="">NOTICE: executing "_test_replication".failedNode2 on node 1<br style="" class="">test.scr:6: NOTICE: calling restart node 2<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event
(1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157).
node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156<br style="" class="">test.scr:6: waiting for event (1,5000000157). node 4 only on event 5000000156</span><br style="" class=""><br style="" class=""><div style="" class="">It'll only complete if I bring node 3 back up, which of course I couldn't do if it was really dead:</div><div style="" class=""><br style="" class=""></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: Courier New,courier,monaco,monospace,sans-serif; background-color: transparent; font-style: normal" class=""><span style="color: rgb(76, 118, 162);">NOTICE: executing "_test_replication".failedNode3 on node 1</span></div><div style="color: rgb(76, 118, 162); font-size: 13.3333px; font-family: Courier New,courier,monaco,monospace,sans-serif; background-color: transparent; font-style: normal;" class=""><br></div><div
style="color: rgb(76, 118, 162); font-size: 13.3333px; font-family: Courier New,courier,monaco,monospace,sans-serif; background-color: transparent; font-style: normal;" class=""><span style="color: rgb(0, 0, 0);"><span>Have I totally got the wrong end of the stic<span></span></span>k here</span><span style="color: rgb(0, 0, 0);">?</span></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: Courier New,courier,monaco,monospace,sans-serif; background-color: transparent; font-style: normal;" class=""><br></div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: Courier New,courier,monaco,monospace,sans-serif; background-color: transparent; font-style: normal;" class="">Thanks</div><div style="color: rgb(0, 0, 0); font-size: 13.3333px; font-family: Courier New,courier,monaco,monospace,sans-serif; background-color: transparent; font-style: normal;" class="">Glyn<br class="" style=""></div></div></body></html>