Thread: postgresql-9.4-BDR replication issue

postgresql-9.4-BDR replication issue

From
Mikhail Levandovskiy
Date:
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.


Re: postgresql-9.4-BDR replication issue

From
Mikhail Levandovskiy
Date:
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@shreeyansh.com
> www.shreeyansh.com
>
> May 25 2015 3:51 AM, "Mikhail Levandovskiy" <mikhail.levandovskiy@nixsolutions.com> 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@postgresql.org)
>> To make changes to your subscription:
>> http://www.postgresql.org/mailpref/pgsql-admin

--
------------------------
Best regards,
System Administration Dept.
NIX Solutions Ltd.



Re: postgresql-9.4-BDR replication issue

From
Shreeyansh Dba
Date:
if you are trying to create new database the follow the steps

Exeute On both servers(nodes)
-create database new_bdrdemo;
-\c new_bdrdemo
-create extension btree_gist;
-create extension bdr;

_______________
On node1
-SELECT bdr.bdr_group_create(local_node_name := 'node1',
node_external_dsn := 'host=10.10.1.39 dbname=new_bdrdemo');

-SELECT bdr.bdr_node_join_wait_for_ready();

_____________________
On node2
-SELECT bdr.bdr_group_join(local_node_name := 'node2',
 node_external_dsn := 'host=10.10.5.107 port=5432 dbname=new_bdrdemo',
 join_using_dsn := 'host=10.10.1.39 port=5432 dbname=new_bdrdemo');
 
-SELECT bdr.bdr_node_join_wait_for_ready();


Thanks and Regards,
Sagar R. Jadhav

Re: postgresql-9.4-BDR replication issue

From
Mikhail Levandovskiy
Date:
BDR replication link on new databases wokring properly.
Looks like something wrong with existing DBs...

On 25/05/15 15:16, Shreeyansh Dba wrote:
if you are trying to create new database the follow the steps

Exeute On both servers(nodes)
-create database new_bdrdemo;
-\c new_bdrdemo
-create extension btree_gist;
-create extension bdr;

_______________
On node1
-SELECT bdr.bdr_group_create(local_node_name := 'node1',
node_external_dsn := 'host=10.10.1.39 dbname=new_bdrdemo');

-SELECT bdr.bdr_node_join_wait_for_ready();

_____________________
On node2
-SELECT bdr.bdr_group_join(local_node_name := 'node2',
 node_external_dsn := 'host=10.10.5.107 port=5432 dbname=new_bdrdemo',
 join_using_dsn := 'host=10.10.1.39 port=5432 dbname=new_bdrdemo');
 
-SELECT bdr.bdr_node_join_wait_for_ready();


Thanks and Regards,
Sagar R. Jadhav

-- 
------------------------
Best regards,
System Administration Dept.
NIX Solutions Ltd.