Postgres Pro
Downloads
Home   >   mailing lists

Thread: trouble adding a node to BDR

trouble adding a node to BDR

From
Steve Boyle
Date:

I have two servers/nodes setup with BDR and that is working.  I’m trying to add a third node.  When the third node tries to sync, I get an error:

pg_restore: [archiver (db)] Error while PROCESSING TOC:

pg_restore: [archiver (db)] Error from TOC entry 600; 1255 17054 FUNCTION cast_txt_to_int(text, integer) postgres

pg_restore: [archiver (db)] could not execute query: ERROR:  function "cast_txt_to_int" already exists with same argument types

 

The thing is, that function does not actually exist on the destination side.  How can I get past this error and get the third node online?

 

Thanks!

Re: trouble adding a node to BDR

From
Craig Ringer
Date:


On 30 January 2015 at 07:21, Steve Boyle <sboyle@connexity.com> wrote:

I have two servers/nodes setup with BDR and that is working.  I’m trying to add a third node.  When the third node tries to sync, I get an error:

pg_restore: [archiver (db)] Error while PROCESSING TOC:

pg_restore: [archiver (db)] Error from TOC entry 600; 1255 17054 FUNCTION cast_txt_to_int(text, integer) postgres

pg_restore: [archiver (db)] could not execute query: ERROR:  function "cast_txt_to_int" already exists with same argument types

 

The thing is, that function does not actually exist on the destination side.  How can I get past this error and get the third node online?

Are you certain your 3rd node's configuration is correct, with all the right connection strings?

My first guess would be that it's trying to restore the dump to the second node, as you would've copied the config and changed one dsn but not the other.

Please show your configuration for each node.

Also, what BDR version are you using? If you built from git, please show "git rev-parse --short HEAD" from the extension's git tree. If you built from packages, the package version is sufficient.

BTW, the version after 0.8.0 will include a lot of sanity checks for connection configurations, making sure everything points at the right nodes before it does anything.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Re: trouble adding a node to BDR

From
Steve Boyle
Date:

Thanks for the hint.  I found a config error, I had added the host= param with the bdr.nodename_local_replica_dsn entry.  Sorting out the bdr.nodename_local_replica_dsn entry solved my issue.

 

Thanks!

 

From: Craig Ringer [mailto:craig@2ndquadrant.com]
Sent: Thursday, January 29, 2015 5:00 PM
To: Steve Boyle
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] trouble adding a node to BDR

 

 

 

On 30 January 2015 at 07:21, Steve Boyle <sboyle@connexity.com> wrote:

I have two servers/nodes setup with BDR and that is working.  I’m trying to add a third node.  When the third node tries to sync, I get an error:

pg_restore: [archiver (db)] Error while PROCESSING TOC:

pg_restore: [archiver (db)] Error from TOC entry 600; 1255 17054 FUNCTION cast_txt_to_int(text, integer) postgres

pg_restore: [archiver (db)] could not execute query: ERROR:  function "cast_txt_to_int" already exists with same argument types

 

The thing is, that function does not actually exist on the destination side.  How can I get past this error and get the third node online?

Are you certain your 3rd node's configuration is correct, with all the right connection strings?

My first guess would be that it's trying to restore the dump to the second node, as you would've copied the config and changed one dsn but not the other.

Please show your configuration for each node.

Also, what BDR version are you using? If you built from git, please show "git rev-parse --short HEAD" from the extension's git tree. If you built from packages, the package version is sufficient.

BTW, the version after 0.8.0 will include a lot of sanity checks for connection configurations, making sure everything points at the right nodes before it does anything.


--

 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services

Re: trouble adding a node to BDR

From
Craig Ringer
Date:


On 31 January 2015 at 06:42, Steve Boyle <sboyle@connexity.com> wrote:

Thanks for the hint.  I found a config error, I had added the host= param with the bdr.nodename_local_replica_dsn entry.  Sorting out the bdr.nodename_local_replica_dsn entry solved my issue.


Glad to hear it.

--
 Craig Ringer                   http://www.2ndQuadrant.com/
 PostgreSQL Development, 24x7 Support, Training & Services