Postgresql 9.4 BDR configuration error

From: Francesco Andrisani <francesco(dot)andrisani(at)acotel(dot)com>
To: pgus-general(at)postgresql(dot)org
Subject: Postgresql 9.4 BDR configuration error
Date: 2017-12-07 15:52:49
Message-ID: CALceD1va2HHifiEgBa+74wvyDj++h39FNP8bTJ+JMBmc=5BTWQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgus-general

Hello all,
I tried to create an Master master Cluster using Postgres-9.4 BDR on two
nodes.

On the node1 the db is already exist and it is large (about 3Gb). When I
try to add node2 (I clone DB from node1 with pg_dumpall), after configuring
all (first and second node) following official BDR guide (
http://bdr-project.org/docs/stable/quickstart.html) on last step (
http://bdr-project.org/docs/stable/quickstart-enabling.html) on node2, it
blocks on "SELECT bdr.bdr_node_join_wait_for_ready();" and node2 log print
this:

< 2017-12-07 09:33:15.781 EST >LOG: starting background worker process
"bdr db: zabbix"
< 2017-12-07 09:33:15.793 EST >ERROR: previous init failed, manual cleanup
is required
< 2017-12-07 09:33:15.793 EST >DETAIL: Found bdr.bdr_nodes entry for bdr
(6496055908800323183,1,16386,) with state=i in remote bdr.bdr_nodes
< 2017-12-07 09:33:15.793 EST >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
< 2017-12-07 09:33:15.795 EST >LOG: worker process: bdr db: zabbix (PID
26818) exited with exit code 1

I'm unable to continua confiiguration.
On node1 if I execute this command :
zabbix=# select * from bdr.bdr_nodes;
node_sysid | node_timeline | node_dboid | node_status | node_name
| node_local_dsn
| node_init_from_dsn | node_read_only | node_seq_id
---------------------+---------------+------------+-------------+-----------+-------------------------------------------------------------------------------+--------------------+----------------+-------------
6494544977234587558 | 1 | 16386 | r | zabbix01
| user=postgres password=xxxxxxxx host=10.200.x.xx port=5432 dbname=zabbix
| | f |
(1 row)"

I'm able to see only node1...not node2.
Can someone help me to know?
Thanks all.

--
____________________________________________________
*Francesco Andrisani*
mailto:francesco(dot)andrisani(at)acotel(dot)com
*Acotel Spa*
http://www.acotel.com
Via della Valle dei Fontanili, 29
00168 Roma
Tel +390661141200
Fax +39066149936
____________________________________________________

Le informazioni contenute nella comunicazione che precede possono essere
riservate e sono, comunque, destinate esclusivamente alla persona o
all’ente sopraindicati. La diffusione, distribuzione e/o copiatura non
autorizzata del documento trasmesso da parte di qualsiasi soggetto è
proibita. La sicurezza e la correttezza dei messaggi di posta elettronica
non possono essere garantite. Se avete ricevuto questo messaggio per
errore, Vi preghiamo di contattarci immediatamente. Grazie.

This message is for the named person's use only. It may contain
confidential, proprietary or legally privileged information. No
confidentiality or privilege is waived or lost by any transmission. If you
receive this message in error, please immediately delete it and all copies
of it from your system, destroy any hard copies of it and notify the
sender. You must not, directly or indirectly, use, disclose, distribute,
print, or copy any part of this message if you are not the intended
recipient. Thanks

Responses

Browse pgus-general by date

  From Date Subject
Next Message Stephen Frost 2017-12-07 16:02:01 Re: Postgresql 9.4 BDR configuration error
Previous Message Stephen Frost 2017-11-28 18:46:13 Re: pg_replication_slots