Message-ID: <5562FEAB.1040903@nixsolutions.com>
Date: Mon, 25 May 2015 13:51:23 +0300
From: Mikhail Levandovskiy <mikhail.levandovskiy@nixsolutions.com>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
 rv:31.0) Gecko/20100101 Thunderbird/31.7.0
MIME-Version: 1.0
To: pgsql-admin@postgresql.org
Subject: postgresql-9.4-BDR replication issue
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 7bit
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org

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@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin