Re: Postgresql 9.4 BDR configuration error

Greetings Francesco,

I'd suggest sending this to pgsql-general instead of pgus-general,
you're more likely to get responses there.

Thanks!

Stephen

* Francesco Andrisani (francesco(dot)andrisani(at)acotel(dot)com) wrote:
> 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