BDR - Remove & Join

Started by Will McCormickover 10 years ago2 messagesgeneral
Jump to latest
#1Will McCormick
wmccormick@gmail.com

I have a script which is meant to remove a node from bdr replication. Two
nodes in replication node A and node B. The script does the following.

1. On node A - SELECT bdr.bdr_part_by_node_names(ARRAY['node B']);
2. On node A -Checks that the node_status is marked as 'k' in bdr.bdr_nodes
3. I then drop the database on node B
4. On node A I remove all nodes from bdr.bdr_nodes which have a status 'k'

I then run a script which I used to setup replication before removal. The
problem I encounter is node B after join in bdr.bdr_nodes is stuck in
status 'c'.

Any advice here would be appricated. I'm not sure if I need to drop all
databases and reinstall postgres instead of step 3. Or f this should be
enough?

We are using the following version of bdr bdr | 16385 |
11 | f | 0.9.2.0 |
{18080,18095,18108,18143,18173,18183,18192,18199,18212,18281} |
{"","","","","","","","","",""} according to pg_extension.

Please let me know if there is further information I can provide to
troubleshoot or if this is a known issue.

Regards and thank you.

#2Craig Ringer
craig@2ndquadrant.com
In reply to: Will McCormick (#1)
Re: BDR - Remove & Join

On 10 November 2015 at 05:10, Will McCormick <wmccormick@gmail.com> wrote:

I then run a script which I used to setup replication before removal. The
problem I encounter is node B after join in bdr.bdr_nodes is stuck in status
'c'.

[snip]

We are using the following version of bdr: 0.9.2.0

Please update to 0.9.3, which fixes this issue, per
https://github.com/2ndQuadrant/bdr/issues/126

--
Craig Ringer http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general