Re: [Postgres-xc-general] Problem with adding new datanode (ERROR: Node name datanode3 duplicate )

[Koichi S. <koi...@gm...>]

Something seems went wrong in the first step you added.   It says that
some coordinator master was not running when you added datanode3.   It
was half done.

To recover this, please try the following.

1) Visit each coordinator and issue "select * from pgxc_ndoe".   If
you find "datanode3", issue "drop node datanode3" in each coordinator.

2) Make sure that all the coordinators are running.

3) Again, try "add datanode master" command from pgxc_ctl.

Please note that you should have all the coordinator running properly
when you add datanodes or coordinators.

Regards;
---
Koichi Suzuki


2014-03-09 7:14 GMT+00:00 Juned Khan <jkh...@gm...>:
> Hi All,
>
> I have pgxc running with 1 master 1 slave , 2 GTM Proxy, 2 Datanode and 2
> Coordinator.
>
> Now i want to add third component with GTM proxy, datanode and cordinator
> I have configure third server and deployed binaries (deploy node5)
>
> then i have initialized each
>
> But when i tried to add third datanode i got below error
> ERROR: Some of the coordinator masters are not running. Cannot add new one.
>
> so i started each component
>
> start gtm_proxy gtm_pxy3
> start coordinator master coord3
> start datanode master datanode3
>
> Now everything is running but i getting below error while executing a query.
>
>> koichi=# execute direct on (datanode3) 'select * from t1';
>> ERROR:  PGXC Node datanode3: object not defined
>
>
> and now if i am trying to add datanode while everything is running , its
> throws below error:
>
>> PGXC add datanode master datanode3 node5 20008
>> /home/postgres/pgxc/nodes/dn_master
>> ERROR: Node name datanode3 duplicate.
>
>
> Is that flow is correct or i am missing something
> what steps i should do to make it working ?
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com
>
> ------------------------------------------------------------------------------
> Subversion Kills Productivity. Get off Subversion & Make the Move to
> Perforce.
> With Perforce, you get hassle-free workflows. Merge that actually works.
> Faster operations. Version large binaries.  Built-in WAN optimization and
> the
> freedom to use Git, Perforce or both. Make the move to Perforce.
> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>