From: | Amit Bondwal <bondwal(dot)amit(at)gmail(dot)com> |
---|---|
To: | Craig Ringer <craig(at)2ndquadrant(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 09:00:31 |
Message-ID: | CAJ=k2iHM63DwqrXGWxZW90JGAsWhe7aV_bN809QbbHuGd1EWGQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hi Craig,
I remove all the bdr packages and reinstall it and setup again the BDR
cluster, still facing the same issue on 3rd node.
On Tue, Dec 22, 2015 at 10:58 AM, Amit Bondwal <bondwal(dot)amit(at)gmail(dot)com>
wrote:
>
> On Tue, Dec 22, 2015 at 10:05 AM, Craig Ringer <craig(at)2ndquadrant(dot)com>
> wrote:
>
>> select * from bdr.bdr_connections;
>>
>
>
> Hi Craig, Thanks for your reply, These commands shows nothing on 3rd node.
>
>
>
> *on node3:-*hakuna=# select * from bdr.bdr_nodes;
> node_sysid | node_timeline | node_dboid | node_status | node_name |
> node_local_dsn | node_init_from_dsn
>
> ------------+---------------+------------+-------------+-----------+----------------+--------------------
> (0 rows)
>
> conn_sysid | conn_timeline | conn_dboid | conn_origin_sysid |
> conn_origin_timeline | conn_origin_dboid | conn_is_unidirectional |
> conn_dsn | conn_apply_delay | conn_replication_sets
>
> ------------+---------------+------------+-------------------+----------------------+-------------------+------------------------+----------+------------------+-----------------------
> (0 rows)
>
>
>
> *on node1:-*
>
> hakuna=# select * from bdr.bdr_nodes;
> node_sysid | node_timeline | node_dboid | node_status |
> node_name | node_local_dsn |
> node_init_from_dsn
>
> ---------------------+---------------+------------+-------------+-----------+----------------------------------+----------------------------------
> 6229651184159874988 | 1 | 18719 | r |
> node1 | host=pg1 port=5432 dbname=hakuna |
> 6229651217067355961 | 1 | 17161 | r |
> node2 | host=pg2 port=5432 dbname=hakuna | host=pg1 port=5432
> dbname=hakuna
> (2 rows)
>
> It is conflicting with ID of node 2 as it shows output of above command on
> node 1.
>
> My OS is debian Jessie and I installed it from bdr repo. Current version
> of bdr is 0.9.3
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Aleksander Łukasz | 2015-12-22 09:03:21 | Table with seemingly duplicated primary key values |
Previous Message | Amit Bondwal | 2015-12-22 05:28:33 | Re: BDR error while adding 3rd node to cluster |