Mon Aug 24 14:44:47 PDT 2015
- Previous message: [Slony1-general] Dropping a node when the node is gone ?
- Next message: [Slony1-general] Dropping a node when the node is gone ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Dave Cramer On 24 August 2015 at 17:42, Steve Singer <ssinger at ca.afilias.info> wrote: > On 08/24/2015 05:40 PM, Dave Cramer wrote: > >> >> On 24 August 2015 at 17:35, Steve Singer <ssinger at ca.afilias.info >> <mailto:ssinger at ca.afilias.info>> wrote: >> >> On 08/24/2015 05:29 PM, Dave Cramer wrote: >> >> >> >> >> >> >> Now I assume the "only at (2,5003478340 <tel:5003478340> >> <tel:5003478340 <tel:5003478340>>) number is >> >> staying the same and it isn't going up. IF it is then you >> actually >> have progress being made but I find that unlikely if node 2 >> isn't >> the origin of any sets to node 1(you would be caught up >> quickly). >> >> >> Another option would be >> >> cluster name=mycluster; >> node 1 admin conninfo='...' >> node 2 admin conninfo='.. >> node 3 admin conninfo='.. >> node 4 admin conninfo='.. >> failover(id=3, backup node = 2); >> >> >> Per the failover documentation >> >> Nodes that are forwarding providers can also be passed to the >> failover command as a failed node. The failover process will >> redirect the subscriptions from these nodes to the backup >> node. >> >> >> failover provided no feedback and doesn't appear to have done >> anything. >> >> >> Most slonik commands don't produce feedback when they work. >> >> select * FROM _mycluster.sl_subscribe >> on your origin; >> >> Does it show node 3 as a provider? >> >> >> It is still there. FWIW, this is 2.2.2-1 was there a fix for this >> recently? >> >> > Sounds similar to bug 342 > http://www.slony.info/bugzilla/show_bug.cgi?id=342 > > That was fixed in 2.2.3 > > Sounds like it. I really didn't want to have to upgrade this mess to fix another mess..... Thanks for your help, Sorry for not brining up the version earlier. Dave > > >> If not you can then drop node 3. >> >> -- >> cluster name=mycluster; >> node 1 admin conninfo='' >> node 2 admin conninfo='' >> node 4 admin conninfo='' >> drop node (id=3, event node=1); >> >> >> >> >> >> >> >> are there paths between node 2 and 4? >> >> There are but I thought I would try your suggestion >> which evokes a >> different error message >> >> waiting for events (2,5003485579 <tel:5003485579> >> <tel:5003485579 <tel:5003485579>>) only at >> (2,5003478340 <tel:5003478340> <tel:5003478340 >> <tel:5003478340>>), >> (4,5002587214 <tel:5002587214> <tel:5002587214 >> <tel:5002587214>>) only at (4,5002579907 <tel:5002579907> >> <tel:5002579907 <tel:5002579907>>) to be confirmed on >> >> node 1 >> >> >> >> >> >> >> >> >> >> >> Dave Cramer >> >> On 24 August 2015 at 15:38, >> Scott Marlowe >> <scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>>> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>>>> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>> >> <mailto:scott.marlowe at gmail.com <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>>> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>>>>> >> >> <mailto:scott.marlowe at gmail.com <mailto:scott.marlowe at gmail.com >> > >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>>> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>>>> >> >> <mailto:scott.marlowe at gmail.com <mailto:scott.marlowe at gmail.com >> > >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>>> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com> >> <mailto:scott.marlowe at gmail.com >> <mailto:scott.marlowe at gmail.com>>>>>>> wrote: >> >> Note that the node will >> still >> show up in >> sl_nodes and >> sl_status for a >> while, until slony does a >> cleanup event / log >> switch (can't >> remember >> which right now). This is >> normal. Don't >> freak out. >> >> >> >> >> >> >> >> >> >> >> >> >> >> > -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.slony.info/pipermail/slony1-general/attachments/20150824/ceb52eb5/attachment.htm
- Previous message: [Slony1-general] Dropping a node when the node is gone ?
- Next message: [Slony1-general] Dropping a node when the node is gone ?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list