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

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

Hi Masataka,

As per that documentation i have provided all those parameters
what else i should add or remove to make that command working ?

I want to add datanode and coordinator with below configuration
and i think i specified all values as per that documentation.


Coordinator Master:
>     Nodename: 'coord3', port: 20004, pooler port: 20010
>     MaxWalSenders: (null), Dir: '/home/postgres/pgxc/nodes/coord'
>     ExtraConfig: 'coordExtraConfig', Specific Extra Config: 'none'
>     pg_hba entries ( '192.168.1.71/32' '192.168.1.72/32' '192.168.1.73/32'
> '192.168.1.43/32' '192.168.1.75/32' )
>     Extra pg_hba: 'none', Specific Extra pg_hba: 'none'
> Datanode Master:
>     Nodename: 'datanode3', port: 20008
>     MaxWALSenders: 3, Dir: '/home/postgres/pgxc/nodes/dn_master'
>     ExtraConfig: 'none', Specific Extra Config: 'none'
>     pg_hba entries ( '192.168.1.71/32' '192.168.1.72/32' '192.168.1.73/32'
> '192.168.1.43/32' '192.168.1.75/32' )
>     Extra pg_hba: 'none', Specific Extra pg_hba: 'none'
>


Please suggest.

Regards
Juned Khan



On Thu, Mar 13, 2014 at 1:06 PM, Masataka Saito <pg...@gm...> wrote:

> On 12 March 2014 22:43, Juned Khan <jkh...@gm...> wrote:
> > Hi Koichi,Masataka
> >
> > Successfully added gtm proxy but having issue with coordinator and
> datanode.
> >
> > Coordinator :
> > add coordinator master name host port pooler dir
> > here what value i should use in place of pooler ? pooler port ?
> >
>
> pooler port
>
> > pgxc_ctl add coordinator master coord3 node5 20004 20010
> > /home/postgres/pgxc/nodes/coord
> > ERROR: sorry found some inconflicts in coordinator master configuration.
> >
>
> It is due to misconfigure. In detail, numbers of element for same
> component are not same.
>
> > pgxc_ctl add coordinator master coord3 node5 20004
> > /home/postgres/pgxc/nodes/coord
> > ERROR: please specify the working director for the coordinator master
> >
> > Datanode :
> > add datanode master name host port dir
> > pgxc_ctl add datanode master new node5 20008
> > /home/postgres/pgxc/nodes/dn_master
> > ERROR: sorry found some inconflicts in datanode master configuration.
> >
> > Does earlier manual installation could be reason for this issue ?
> >
> > P.S:
> > gtm_prxy : Nodename: 'gtm_pxy3', port: 20001, dir:
> > '/home/postgres/pgxc/nodes/gtm_pxy'
> > Coordinator Master: Nodename: 'coord3', port: 20004, pooler port: 20010,
> > dir:' /home/postgres/pgxc/nodes/coord'
> > Datanode Master :   Nodename: 'datanode3', port: 20008, dir:'
> > /home/postgres/pgxc/nodes/dn_master'
> >
> > please look at my commands if its erroneous
> >
> > Please advice.
> >
> > Regards,
> > Juned Khan
> >
> >
> >
> > On Wed, Mar 12, 2014 at 11:45 AM, Juned Khan <jkh...@gm...>
> wrote:
> >>
> >> I tried to add coordinator and datanode manually
> >> and now it seems everything is messed up.
> >>
> >> Every component is just stopped working, if i kill all and
> >> start all again then again its shows everything is running
> >> but in that case it takes too long to connect dtabase(Psql -dkoichi)
> >>
> >> and at last it just fails to connect to the database
> >>
> >> PGXC Psql -dkoichi
> >> Selected coord1.
> >> psql: server closed the connection unexpectedly
> >>         This probably means the server terminated abnormally
> >>         before or while processing the request.
> >> PGXC
> >>
> >> Please advice.
> >>
> >>
> >>
> >> On Wed, Mar 12, 2014 at 4:34 AM, Michael Paquier
> >> <mic...@gm...> wrote:
> >>>
> >>> On Wed, Mar 12, 2014 at 4:10 AM, Masataka Saito <pg...@gm...>
> wrote:
> >>> > On 11 March 2014 16:42, Juned Khan <jkh...@gm...> wrote:
> >>> >> Hi Masataka,
> >>> >>
> >>> >> For testing i am tried to get this work added manual query for
> CREATE
> >>> >> NODE.
> >>> >>
> >>> >> Now its look like this:
> >>> >>
> >>> >> postgres=# \q
> >>> >> PGXC Psql -dpostgres -h node5 -p 20004
> >>> >> Selected coord3.
> >>> >>
> >>> >> postgres=# select * from pgxc_node;
> >>> >>  node_name | node_type | node_port | node_host | nodeis_primary |
> >>> >> nodeis_preferred |   node_id
> >>> >>
> >>> >>
> -----------+-----------+-----------+-----------+----------------+------------------+-------------
> >>> >>  coord3    | C         |      5432 | localhost | f              | f
> >>> >> |  1638403545
> >>> >>  coord1    | C         |     20004 | node3     | f              | f
> >>> >> |  1885696643
> >>> >>  coord2    | C         |     20005 | node4     | f              | f
> >>> >> | -1197102633
> >>> >>  datanode1 | D         |     20008 | node3     | f              | f
> >>> >> |   888802358
> >>> >>  datanode2 | D         |     20009 | node4     | f              | f
> >>> >> |  -905831925
> >>> >>  datanode3 | D         |     20008 | node5     | f              | f
> >>> >> | -1894792127
> >>> >> (6 rows)
> >>> >>
> >>> >> Here coord3 runs on 5432 which should 20004., it creates problem i
> >>> >> think
> >>> >> isn't it ?
> >>> >>
> >>> >
> >>> > As far as I know, the local node information is not important and it
> >>> > is not necessary to update.
> >>> > "pgxc_ctl add" corrects it by "ALTER NODE".
> >>> CREATE NODE and DROP NODE only run locally. Why not ALTER NODE for
> >>> consistency? Am I missing smth?
> >>> --
> >>> Michael
> >>
> >>
> >>
> >>
> >> --
> >> Thanks,
> >> Juned Khan
> >> iNextrix Technologies Pvt Ltd.
> >> www.inextrix.com
> >
> >
> >
> >
> > --
> > Thanks,
> > Juned Khan
> > iNextrix Technologies Pvt Ltd.
> > www.inextrix.com
>



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