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.a...@gmail.com> wrote: > > On Tue, Dec 22, 2015 at 10:05 AM, Craig Ringer <cr...@2ndquadrant.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 > > >
