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

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