Postgresql 9.4 BDR configuration error

Next Topic
 
classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

Postgresql 9.4 BDR configuration error

Francesco Andrisani
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:[hidden email]
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

Reply | Threaded
Open this post in threaded view
|

Re: Postgresql 9.4 BDR configuration error

Stephen Frost
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 ([hidden email]) 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:[hidden email]
> *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

signature.asc (819 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql 9.4 BDR configuration error

Francesco Andrisani
Hi Stephen,
I tried to subscribe to pgsql-general, but on pg subscribe page https://www.postgresql.org/community/lists/subscribe/, I'm not able (on select field to find pgsql-general...only country specific mailing lists.

Thanks

On Thu, Dec 7, 2017 at 5:02 PM, Stephen Frost <[hidden email]> wrote:
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 ([hidden email]) 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:[hidden email]
> *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



--
____________________________________________________
Francesco Andrisani
mailto:[hidden email]
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

Reply | Threaded
Open this post in threaded view
|

Re: Postgresql 9.4 BDR configuration error

Stephen Frost
Francesco,

To subscribe to the regular lists, you need to follow the 'new system'
link on that page which will take you here:

https://lists.postgresql.org/manage/

You'll need a community account if you don't have one already, and you
can get one by going here:

https://www.postgresql.org/account/

Thanks!

Stephen

* Francesco Andrisani ([hidden email]) wrote:

> Hi Stephen,
> I tried to subscribe to pgsql-general, but on pg subscribe page
> https://www.postgresql.org/community/lists/subscribe/, I'm not able (on
> select field to find pgsql-general...only country specific mailing lists.
>
> Thanks
>
> On Thu, Dec 7, 2017 at 5:02 PM, Stephen Frost <[hidden email]> wrote:
>
> > 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 ([hidden email]) 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:[hidden email]
> > > *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
> >
>
>
>
> --
> ____________________________________________________
> *Francesco Andrisani*
> mailto:[hidden email]
> *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

signature.asc (819 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Postgresql 9.4 BDR configuration error

Francesco Andrisani
Great!
Thank a lot
Regards

On Thu, Dec 7, 2017 at 5:10 PM, Stephen Frost <[hidden email]> wrote:
Francesco,

To subscribe to the regular lists, you need to follow the 'new system'
link on that page which will take you here:

https://lists.postgresql.org/manage/

You'll need a community account if you don't have one already, and you
can get one by going here:

https://www.postgresql.org/account/

Thanks!

Stephen

* Francesco Andrisani ([hidden email]) wrote:
> Hi Stephen,
> I tried to subscribe to pgsql-general, but on pg subscribe page
> https://www.postgresql.org/community/lists/subscribe/, I'm not able (on
> select field to find pgsql-general...only country specific mailing lists.
>
> Thanks
>
> On Thu, Dec 7, 2017 at 5:02 PM, Stephen Frost <[hidden email]> wrote:
>
> > 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 ([hidden email]) 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:[hidden email]
> > > *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
> >
>
>
>
> --
> ____________________________________________________
> *Francesco Andrisani*
> mailto:[hidden email]
> *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



--
____________________________________________________
Francesco Andrisani
mailto:[hidden email]
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