No, i've already runned SELECT bdr.bdr_node_join_wait_for_ready(); on first and second nodes, and on first node it shows: SELECT bdr.bdr_node_join_wait_for_ready(); bdr_node_join_wait_for_ready ------------------------------ (1 row) but on second it hung. On 25/05/15 14:04, Sagar R. Jadhav wrote:
This error may cause because of on node1 you did not execute the function bdr.bdr_node_join_wait_for_ready(); try to execute it and also execute it on second node after executing bdr.bdr_group_join(....). -- Thanks & Regards, Sagar R. Jadhav Ph: +91-9552688400 / 7400 Skype ID: sagarjdhv24 Email ID: sagar.jadhav@xxxxxxxxxxxxxx www.shreeyansh.com May 25 2015 3:51 AM, "Mikhail Levandovskiy" <mikhail.levandovskiy@xxxxxxxxxxxxxxxx> wrote:Hi all. I've installed postgresql-9.4 with BDR from its official repository, and trying to create replication group with database on two nodes: on first node runned: CREATE EXTENSION btree_gist; CREATE EXTENSION bdr; SELECT bdr.bdr_group_create(local_node_name := 'node1', node_external_dsn := 'host=10.10.1.39 dbname=bdrdemo2'); on second node runned: CREATE EXTENSION btree_gist; CREATE EXTENSION bdr; SELECT bdr.bdr_group_join(local_node_name := 'node2', node_external_dsn := 'host=10.10.5.107 dbname=bdrdemo2', join_using_dsn := 'host=10.10.1.39 dbname=bdrdemo2' ); And then getting this error on second node: < 2015-05-25 03:38:37.714 PDT >LOG: starting background worker process "bdr db: bdrdemo" < 2015-05-25 03:38:37.731 PDT >ERROR: previous init failed, manual cleanup is required < 2015-05-25 03:38:37.731 PDT >DETAIL: Found bdr.bdr_nodes entry for bdr (6152755282451262703,1,16407,) with state=i in remote bdr.bdr_nodes < 2015-05-25 03:38:37.731 PDT >HINT: Remove all replication identifiers and slots corresponding to this node from the init target node then drop and recreate this database and try again < 2015-05-25 03:38:37.732 PDT >LOG: worker process: bdr db: bdrdemo (PID 25402) exited with exit code 1 I've tried to remove all replication slots on both nodes: select * from pg_replication_slots; select pg_drop_replication_slot('replication_slot_name'); tried to clean bdr.bdr_nodes, bdr.bdr_node_slots and bdr.bdr_connections, tried to drop database and create it again - all was useless. What's missed? Thanks. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
-- ------------------------ Best regards, System Administration Dept. NIX Solutions Ltd. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
