<div dir="ltr"><div class="gmail_extra"><br><div class="gmail_quote">On 24 August 2015 at 17:35, Steve Singer <span dir="ltr"><<a href="mailto:ssinger@ca.afilias.info" target="_blank">ssinger@ca.afilias.info</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">On 08/24/2015 05:29 PM, Dave Cramer wrote:<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<br>
</blockquote>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<br>
<br>
<br>
Now I assume the "only at (2,<a href="tel:5003478340" value="+15003478340" target="_blank">5003478340</a> <tel:<a href="tel:5003478340" value="+15003478340" target="_blank">5003478340</a>>) number is<span class=""><br>
staying the same and it isn't going up. IF it is then you actually<br>
have progress being made but I find that unlikely if node 2 isn't<br>
the origin of any sets to node 1(you would be caught up quickly).<br>
<br>
<br>
Another option would be<br>
<br>
cluster name=mycluster;<br>
node 1 admin conninfo='...'<br>
node 2 admin conninfo='..<br>
node 3 admin conninfo='..<br>
node 4 admin conninfo='..<br>
failover(id=3, backup node = 2);<br>
<br>
<br>
Per the failover documentation<br>
<br>
Nodes that are forwarding providers can also be passed to the<br>
failover command as a failed node. The failover process will<br>
redirect the subscriptions from these nodes to the backup node.<br>
<br>
<br>
failover provided no feedback and doesn't appear to have done anything.<br>
</span></blockquote>
<br>
Most slonik commands don't produce feedback when they work.<br>
<br>
select * FROM _mycluster.sl_subscribe<br>
on your origin;<br>
<br>
Does it show node 3 as a provider?<br></blockquote><div><br></div><div>It is still there. FWIW, this is 2.2.2-1 was there a fix for this recently? </div><blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex">
<br>
If not you can then drop node 3.<br>
<br>
--<br>
cluster name=mycluster;<br>
node 1 admin conninfo=''<br>
node 2 admin conninfo=''<br>
node 4 admin conninfo=''<br>
drop node (id=3, event node=1);<br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left-width:1px;border-left-color:rgb(204,204,204);border-left-style:solid;padding-left:1ex"><span class="">
<br>
<br>
<br>
<br>
<br>
are there paths between node 2 and 4?<br>
<br>
There are but I thought I would try your suggestion which evokes a<br>
different error message<br>
<br></span>
waiting for events (2,<a href="tel:5003485579" value="+15003485579" target="_blank">5003485579</a> <tel:<a href="tel:5003485579" value="+15003485579" target="_blank">5003485579</a>>) only at<br>
(2,<a href="tel:5003478340" value="+15003478340" target="_blank">5003478340</a> <tel:<a href="tel:5003478340" value="+15003478340" target="_blank">5003478340</a>>),<span class=""><br>
(4,<a href="tel:5002587214" value="+15002587214" target="_blank">5002587214</a> <tel:<a href="tel:5002587214" value="+15002587214" target="_blank">5002587214</a>>) only at (4,<a href="tel:5002579907" value="+15002579907" target="_blank">5002579907</a><br></span>
<tel:<a href="tel:5002579907" value="+15002579907" target="_blank">5002579907</a>>) to be confirmed on node 1<div><div class="h5"><br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Dave Cramer<br>
<br>
On 24 August 2015 at 15:38, Scott Marlowe<br>
<<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>>>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>> <mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>>>>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>>>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a><br>
<mailto:<a href="mailto:scott.marlowe@gmail.com" target="_blank">scott.marlowe@gmail.com</a>>>>>>> wrote:<br>
<br>
Note that the node will still<br>
show up in<br>
sl_nodes and<br>
sl_status for a<br>
while, until slony does a<br>
cleanup event / log<br>
switch (can't<br>
remember<br>
which right now). This is<br>
normal. Don't<br>
freak out.<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
</div></div></blockquote>
<br>
<br>
</blockquote></div><br></div></div>