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

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

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