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

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi Masataka,

yeah i have manually edited pgxc_ct.conf file and just added one more
gtm_poxy, coordinator and datanode. then

deploy node5

init gtm_proxy gtm_pxy3
init coordinator master coord3
init datanode master datanode3

start gtm_proxy gtm_pxy3
start coordinator master coord3
start datanode master datanode3

then

add datanode master datanode3 node5 20008
/home/postgres/pgxc/nodes/dn_master

isn't it the correct way to add new datanode ?

On my real server i have to add number of new nodes later on,
so i don't want to get stuck at that time.

Please suggest.

Regards

Juned Khan

On Mon, Mar 10, 2014 at 3:50 PM, Masataka Saito <pg...@gm...> wrote:

> I wonder you manually edited your pgxc_ctl.conf and issued "pgxc_ctl
> init", right?
>
> I think you're recommended to use "pgxc_ctl add" for that purpose.
> "pgxc_ctl add" appends your pgxc_ctl.conf and setup component's
> configuration files and coordinators' settings.
>
> If you want to do it in your way, you must issue "CREATE NODE" SQL
> commands at your all coordinators after you start coordinators and
> datanodes. Please notice I'm not sure it is all you have to do.
>
> Regards.
>
> On 10 March 2014 18:26, Juned Khan <jkh...@gm...> wrote:
> > Hi Sir,
> >
> > As here we are adding datanode3, should i try to add gtm_procy3 and
> > coordinator3 same way?
> >
> > If i am trying to add it without starting, then it complains
> >>
> >> Some of the coordinator masters are not running. Cannot add new one.
> >
> >
> > and if i try to add it after initialization and start then it complains
> >>
> >> Node name datanode3 duplicate.
> >
> >
> > So in this case i think it being added when its initialized but the only
> > problem is data distribution
> >
> > when i am executing query directly on datanode3 it giving me
> >
> >> koichi=# execute direct on (datanode3) 'select * from t1';
> >> ERROR:  PGXC Node datanode3: object not defined
> >
> >
> > Is there any other alternative to solve this problem.
> >
> > Please advice
> >
> > Regards
> > Juned Khan
> >
> >
> >
> >
> >
> > On Sun, Mar 9, 2014 at 3:17 PM, Juned Khan <jkh...@gm...> wrote:
> >>
> >> 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
> >
> >
> >
> >
> > --
> > Thanks,
> > Juned Khan
> > iNextrix Technologies Pvt Ltd.
> > www.inextrix.com
> >
> >
> ------------------------------------------------------------------------------
> > Learn Graph Databases - Download FREE O'Reilly Book
> > "Graph Databases" is the definitive new guide to graph databases and
> their
> > applications. Written by three acclaimed leaders in the field,
> > this first edition is now available. Download your free book today!
> > http://p.sf.net/sfu/13534_NeoTech
> > _______________________________________________
> > 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