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

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

No, as much as pgxc_ctl.conf is consistent with current configuration,
it's okay.

Thanks.
---
Koichi Suzuki


2014-03-10 14:25 GMT+00:00 Masataka Saito <pg...@gm...>:
> pgxc_ctl knows new gtm-proxy because he edit pgxc_ctl.conf manually
> and of course it has entry for gtm-proxy. Do you mean pgxc_ctl has
> another file to memory  about gtm-proxy?
>
> On 10 March 2014 23:00, Koichi Suzuki <koi...@gm...> wrote:
>> It's not a good idea to have gym-proxy not known to pgxc_ctl.   You
>> should configure gym-proxy using pgxc_ctl.
>> ---
>> Koichi Suzuki
>>
>>
>> 2014-03-10 10:37 GMT+00:00 Juned Khan <jkh...@gm...>:
>>> 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