Postgres BDR bdr_init_copy fails

From: Nikhil <nikhilsmenon(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Postgres BDR bdr_init_copy fails
Date: 2016-01-14 19:41:12
Message-ID: CALo-6YMRU+DVFSwUyub+3NwL9wGdab-WJ+BGBTaXsQv0S2EwSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello ,

I am trying to setup 2 -node bdr group. i have 5 databases in node 1. i
created groups for each db in node-1. then did pg_basebackup from node -2
and started bdr_init_copy. Its giving below error.

*bdr_init_copy*

bdr_init_copy: starting ...
Getting remote server identification ...
Detected 5 BDR database(s) on remote server
Updating BDR configuration on the remote node:
db1: creating replication slot ...
db2: creating node entry for local node ...
prime: creating replication slot ...
prime: creating node entry for local node ...
cloud: creating replication slot ...
cloud: creating node entry for local node ...
stack: creating replication slot ...
stack: creating node entry for local node ...
dstack: creating replication slot ...
dstack: creating node entry for local node ...
Creating restore point on remote node ...
Bringing local node to the restore point ...
pg_ctl: another server might be running; trying to start server anyway
Transaction log reset
Initializing BDR on the local node:
*...hangs after this...*

*node-1 pg log*

<752812016-01-14 19:46:17 GMT%ERROR: Failed to find expected
bdr.connections row (conn_sysid,conn_timeline,conn_dboid) =
(6239712043346226652,1,16386) in bdr.bdr_connections
<457142016-01-14 19:46:17 GMT%LOG: worker process: bdr
(6238458855251125696,1,16386,)->bdr (6239712043346226652,1, (PID 75281)
exited with exit code 1
<457142016-01-14 19:46:18 GMT%LOG: starting background worker process "bdr
(6238458855251125696,1,16396,)->bdr (6239712043346226652,1,"
<752822016-01-14 19:46:18 GMT%ERROR: Failed to find expected
bdr.connections row (conn_sysid,conn_timeline,conn_dboid) =
(6239712043346226652,1,16387) in bdr.bdr_connections
<457142016-01-14 19:46:18 GMT%LOG: worker process: bdr
(6238458855251125696,1,16396,)->bdr (6239712043346226652,1, (PID 75282)
exited with exit code 1

*node-2 pg log*

<10.102.31.228(57420)postgres714142016-01-14 19:41:00 GMTmpsdb%LOG:
duration: 1.092 ms
<10.102.31.228(26942)postgres714152016-01-14 19:41:00 GMTprime%LOG:
statement: DELETE FROM pg_catalog.pg_
shseclabel WHERE provider = 'bdr';
<10.102.31.228(26942)postgres714152016-01-14 19:41:00 GMTprime%LOG:
duration: 2.072 ms
<10.102.31.228(26942)postgres714152016-01-14 19:41:00 GMTprime%LOG:
statement: SELECT pg_catalog.pg_repli
cation_identifier_drop(riname) FROM pg_catalog.pg_replication_identifier;
<10.102.31.228(26942)postgres714152016-01-14 19:41:00 GMTprime%LOG:
duration: 0.693 ms
<10.102.31.228(45510)postgres714162016-01-14 19:41:00 GMTcloud%LOG:
statement: DELETE FROM pg_catalog.pg
_shseclabel WHERE provider = 'bdr';
<10.102.31.228(45510)postgres714162016-01-14 19:41:00 GMTcloud%LOG:
duration: 2.350 ms
<10.102.31.228(45510)postgres714162016-01-14 19:41:00 GMTcloud%LOG:
statement: SELECT pg_catalog.pg_repl
ication_identifier_drop(riname) FROM pg_catalog.pg_replication_identifier;
<10.102.31.228(45510)postgres714162016-01-14 19:41:00 GMTcloud%LOG:
duration: 0.672 ms
<10.102.31.228(43879)postgres714172016-01-14 19:41:00 GMTstack%LOG:
statement: DELETE FROM pg_catalog
.pg_shseclabel WHERE provider = 'bdr';
<10.102.31.228(43879)postgres714172016-01-14 19:41:00 GMTstack%LOG:
duration: 2.094 ms
<10.102.31.228(43879)postgres714172016-01-14 19:41:00 GMTstack%LOG:
statement: SELECT pg_catalog.pg_r
eplication_identifier_drop(riname) FROM
pg_catalog.pg_replication_identifier;
<10.102.31.228(43879)postgres714172016-01-14 19:41:00 GMTstack%LOG:
duration: 0.758 ms
<10.102.31.228(11976)postgres714182016-01-14 19:41:00 GMTdstack%LOG:
statement: DELETE FROM pg_catalo
g.pg_shseclabel WHERE provider = 'bdr';
<10.102.31.228(11976)postgres714182016-01-14 19:41:00 GMTdstack%LOG:
duration: 1.954 ms
<10.102.31.228(11976)postgres714182016-01-14 19:41:00 GMTdstack%LOG:
statement: SELECT pg_catalog.pg_
replication_identifier_drop(riname) FROM
pg_catalog.pg_replication_identifier;
<10.102.31.228(11976)postgres714182016-01-14 19:41:00 GMTdstack%LOG:
duration: 0.669 ms
<713942016-01-14 19:41:00 GMT%LOG: received smart shutdown request
<714012016-01-14 19:41:00 GMT%LOG: autovacuum launcher shutting down
<713942016-01-14 19:41:00 GMT%LOG: worker process: bdr supervisor (PID
71404) exited with exit code 0
<713942016-01-14 19:41:00 GMT%LOG: unregistering background worker "bdr
supervisor"
<713982016-01-14 19:41:00 GMT%LOG: shutting down
<713982016-01-14 19:41:00 GMT%LOG: database system is shut down

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2016-01-14 19:43:27 regexp_replace
Previous Message Chris Travers 2016-01-14 19:12:20 Re: WIP: CoC V5