From: | Craig Ringer <craig(at)2ndquadrant(dot)com> |
---|---|
To: | Amit Bondwal <bondwal(dot)amit(at)gmail(dot)com> |
Cc: | PostgreSQL mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: BDR error while adding 3rd node to cluster |
Date: | 2015-12-22 04:35:54 |
Message-ID: | CAMsr+YEy_WPMX0q9VQcEdhp7f7pGVCBNgZnT6ddJNbUsdH2Z_g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 21 December 2015 at 22:57, Amit Bondwal <bondwal(dot)amit(at)gmail(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Amit Bondwal | 2015-12-22 05:28:33 | Re: BDR error while adding 3rd node to cluster |
Previous Message | John McKown | 2015-12-21 19:07:01 | Re: Unique index problem |