Postgres BDR bdr_init_copy fails - Mailing list pgsql-general
| From | Nikhil |
|---|---|
| Subject | Postgres BDR bdr_init_copy fails |
| Date | |
| Msg-id | CALo-6YMRU+DVFSwUyub+3NwL9wGdab-WJ+BGBTaXsQv0S2EwSQ@mail.gmail.com Whole thread Raw |
| Responses |
Re: Postgres BDR bdr_init_copy fails
(Craig Ringer <craig@2ndquadrant.com>)
|
| List | 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
pgsql-general by date: