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

[Juned K. <jkh...@gm...>]

Hi Koichi,

I found datanode3 on node5 server. seems it been added there

PGXC Psql -dpostgres -h node5 -p 20008
Selected coord2.
psql (PGXC 1.1, based on PG 9.2.4)
Type "help" for help.

postgres=# select * from pgxc_node;
 node_name | node_type | node_port | node_host | nodeis_primary |
nodeis_preferred |   node_id
-----------+-----------+-----------+-----------+----------------+------------------+-------------
 datanode3 | C         |      5432 | localhost | f              |
f                | -1894792127
(1 row)


*But not able to drop it:*
postgres=# drop node datanode3;
ERROR:  PGXC Node datanode3: cannot drop local node


*pgxc status :*

> PGXC monitor all
> Running: gtm master
> Running: gtm slave
> Running: gtm proxy gtm_pxy1
> Running: gtm proxy gtm_pxy2
> Running: gtm proxy gtm_pxy3
> Running: coordinator master coord1
> Running: coordinator master coord2
> Running: coordinator master coord3
> Running: datanode master datanode1
> Running: datanode master datanode2
> Running: datanode master datanode3
>


all components are running properly.
please suggest.



On Sun, Mar 9, 2014 at 2:52 PM, Koichi Suzuki <koi...@gm...> wrote:

> 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
> >
>



-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com