On node1: apimgtdb=# SELECT * FROM bdr.bdr_nodes apimgtdb-# ; node_sysid | node_timeline | node_dboid | node_status | node_name | node_local_dsn | node_init_from_dsn ---------------------+---------------+------------+-------------+-----------+---------------------------------------------------------------------------- --+-------------------- 6145502501690488441 | 2 | 16424 | r | node1 | port=5432 dbname=apimgtdb user=postgres password=XXXX host=10.0.0.101 | (1 row) apimgtdb=# SELECT * FROM bdr.bdr_connections apimgtdb-# ; conn_sysid | conn_timeline | conn_dboid | conn_origin_sysid | conn_origin_timeline | conn_origin_dboid | conn_is_unidirectional | conn_dsn | conn_apply_delay | conn_replication_sets ---------------------+---------------+------------+-------------------+----------------------+-------------------+------------------------+-------------- ----------------------------------------------------------------+------------------+------------------------ 6145502501690488441 | 2 | 16424 | 0 | 0 | 0 | f | port=5432 dbn ame=apimgtdb user=postgres password=XXXXX host=10.0.0.101 | | {test_rep_set} (1 row) < 2015-05-15 05:47:47.070 PDT >ERROR: No peer nodes or peer node count unknown, cannot acquire DDL lock < 2015-05-15 05:47:47.070 PDT >HINT: BDR is probably still starting up, wait a while < 2015-05-15 05:47:47.070 PDT >CONTEXT: SQL statement "SECURITY LABEL FOR bdr ON TABLE idn_oauth2_access_token IS '{ "sets" : [“test_rep_set"] }'" PL/pgSQL function bdr.table_set_replication_sets(regclass,text[]) line 30 at EXECUTE statement < 2015-05-15 05:47:47.070 PDT >STATEMENT: select bdr.table_set_replication_sets(’table1', ARRAY[’test_rep_set']); On node2: apimgtdb=# SELECT * FROM bdr.bdr_nodes; node_sysid | node_timeline | node_dboid | node_status | node_name | node_local_dsn | node_init_from_dsn ---------------------+---------------+------------+-------------+-----------+------------------------------------------------------------------------- ----+------------------------------------------------------------------------------ 6148366974419236867 | 1 | 16386 | i | node2 | port=5432 dbname=apimgtdb user=postgres password=XXXX host=10.0.0.102 | port=5432 dbname=apimgtdb user=postgres password=XXXX host=10.0.0.101 (1 row) apimgtdb=# SELECT * FROM bdr.bdr_connections; conn_sysid | conn_timeline | conn_dboid | conn_origin_sysid | conn_origin_timeline | conn_origin_dboid | conn_is_unidirectional | conn_dsn | conn_apply_delay | conn_replication_sets ---------------------+---------------+------------+-------------------+----------------------+-------------------+------------------------+----------- ------------------------------------------------------------------+------------------+------------------------ 6148366974419236867 | 1 | 16386 | 0 | 0 | 0 | f | port=5432 dbname=apimgtdb user=postgres password=XXXX host=10.0.0.102 | | {test_rep_set} (1 row) The following lines repeat in the logs on node2: < 2015-05-15 09:04:25.874 EDT >LOG: worker process: bdr db: apimgtdb (PID 16330) exited with exit code 1 < 2015-05-15 09:04:30.880 EDT >LOG: starting background worker process "bdr db: apimgtdb" < 2015-05-15 09:04:30.915 EDT >ERROR: previous init failed, manual cleanup is required < 2015-05-15 09:04:30.915 EDT >DETAIL: Found bdr.bdr_nodes entry for bdr (6148366974419236867,1,16386,) with state=i in remote bdr.bdr_nodes < 2015-05-15 09:04:30.915 EDT >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-15 09:04:30.916 EDT >LOG: worker process: bdr db: apimgtdb (PID 16338) exited with exit code 1
|
