<div dir="ltr"><br><div class="gmail_extra"><br clear="all"><div><div class="gmail_signature">Dave Cramer</div></div>
<br><div class="gmail_quote">On 24 August 2015 at 17:42, 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:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 08/24/2015 05:40 PM, Dave Cramer wrote:<br>
</span><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
<br>
On 24 August 2015 at 17:35, Steve Singer <<a href="mailto:ssinger@ca.afilias.info" target="_blank">ssinger@ca.afilias.info</a><br></span><span class="">
<mailto:<a href="mailto:ssinger@ca.afilias.info" target="_blank">ssinger@ca.afilias.info</a>>> wrote:<br>
<br>
On 08/24/2015 05:29 PM, Dave Cramer wrote:<br>
<br>
<br>
<br>
<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>><br></span>
<tel:<a href="tel:5003478340" value="+15003478340" target="_blank">5003478340</a> <tel:<a href="tel:5003478340" value="+15003478340" target="_blank">5003478340</a>>>) number is<div><div class="h5"><br>
staying the same and it isn't going up. IF it is then you<br>
actually<br>
have progress being made but I find that unlikely if node 2<br>
isn't<br>
the origin of any sets to node 1(you would be caught up<br>
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<br>
anything.<br>
<br>
<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>
<br>
<br>
It is still there. FWIW, this is 2.2.2-1 was there a fix for this<br>
recently?<br>
<br>
</div></div></blockquote>
<br>
Sounds similar to bug 342<br>
<a href="http://www.slony.info/bugzilla/show_bug.cgi?id=342" rel="noreferrer" target="_blank">http://www.slony.info/bugzilla/show_bug.cgi?id=342</a><br>
<br>
That was fixed in 2.2.3<br>
<br></blockquote><div>Sounds like it. I really didn't want to have to upgrade this mess to fix another mess.....</div><div><br></div><div>Thanks for your help, Sorry for not brining up the version earlier.</div><div><br></div><div>Dave </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">
<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>
<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<br>
which evokes a<br>
different error message<br>
<br>
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>><br></span>
<tel:<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>> <tel:<a href="tel:5003478340" value="+15003478340" target="_blank">5003478340</a><br>
<tel:<a href="tel:5003478340" value="+15003478340" target="_blank">5003478340</a>>>),<br>
(4,<a href="tel:5002587214" value="+15002587214" target="_blank">5002587214</a> <tel:<a href="tel:5002587214" value="+15002587214" target="_blank">5002587214</a>> <tel:<a href="tel:5002587214" value="+15002587214" target="_blank">5002587214</a><span class=""><br>
<tel:<a href="tel:5002587214" value="+15002587214" target="_blank">5002587214</a>>>) only at (4,<a href="tel:5002579907" value="+15002579907" target="_blank">5002579907</a> <tel:<a href="tel:5002579907" value="+15002579907" target="_blank">5002579907</a>><br></span>
<tel:<a href="tel:5002579907" value="+15002579907" target="_blank">5002579907</a> <tel:<a href="tel:5002579907" value="+15002579907" target="_blank">5002579907</a>>>) to be confirmed on<div><div class="h5"><br>
node 1<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
<br>
Dave Cramer<br>
<br>
On 24 August 2015 at 15:38,<br>
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>><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> <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>
<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>
<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>>>>>>>> wrote:<br>
<br>
Note that the node will<br>
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>
<br>
<br>
<br>
</div></div></blockquote>
<br>
</blockquote></div><br></div></div>