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
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 |