Search Postgresql Archives

Postgres BDR bdr_init_copy fails

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux