On 21 December 2015 at 22:57, Amit Bondwal <bondwal.amit@xxxxxxxxx> wrote:
It is working well between first and 2nd node, but When I try to add 3rd node, it give the below error.Hi Everyone,I am trying to setup three node bdr cluster, I am following the quick start guide,
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?