Postgres Pro
Downloads
Home   >   mailing lists

Re: BDR error while adding 3rd node to cluster - Mailing list pgsql-general

From Craig Ringer
Subject Re: BDR error while adding 3rd node to cluster
Date
Msg-id CAMsr+YEy_WPMX0q9VQcEdhp7f7pGVCBNgZnT6ddJNbUsdH2Z_g@mail.gmail.com
Whole thread Raw
In response to BDR error while adding 3rd node to cluster  (Amit Bondwal <bondwal.amit@gmail.com>)
Responses Re: BDR error while adding 3rd node to cluster  (Amit Bondwal <bondwal.amit@gmail.com>)
List pgsql-general
Tree view
On 21 December 2015 at 22:57, Amit Bondwal <bondwal.amit@gmail.com> wrote:
Hi Everyone,

I am trying to setup three node bdr cluster, I am following the quick start guide,
It is working well between first and 2nd node, but When I try to add 3rd node, it give the below error.

hakuna=# SELECT bdr.bdr_group_join(
      local_node_name := 'node3',
      node_external_dsn := 'host=pg3 port=5432 dbname=hakuna',
      join_using_dsn := 'host=pg1 port=5432 dbname=hakuna'
);
ERROR:  node identity for node_external_dsn does not match current node when connecting back via remote
DETAIL:  The dsn '' connects to a node with identity (6229651217067355961,1,17161) but the local node is (6229649404569370556,1,19247)

Huh. That's interesting. The dsn '<empty string>'.

How'd we get there?

Can you show the output of

select * from bdr.bdr_nodes;

select * from bdr.bdr_connections;


on the new node you're trying to join?



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

pgsql-general by date:

Previous
From: John McKown
Date:
Subject: Re: Unique index problem
Next
From: Amit Bondwal
Date:
Subject: Re: BDR error while adding 3rd node to cluster