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

[Masataka S. <pg...@gm...>]

Can you provide your pgxc_ctl.conf?

On 14 March 2014 00:31, Juned Khan <jkh...@gm...> wrote:
> Hi Masataka,
>
> Thanks for confirmation.
> is there any alternative for me to get this working?
>
> This can be very problematic with live servers.
>
>
> On Thu, Mar 13, 2014 at 8:56 PM, Masataka Saito <pg...@gm...> wrote:
>>
>> I think there's no problem in your command line.
>>
>>
>> On 13 March 2014 23:05, Juned Khan <jkh...@gm...> wrote:
>> > Hi Masataka,
>> >
>> > Its fine but i think i have specified only one element for each
>> > parameter.
>> > please check my command if it needs any correction
>> >
>> >
>> > pgxc_ctl add coordinator master coord3 node5 20004 20010
>> > /home/postgres/pgxc/nodes/coord
>> >
>> >
>> >
>> > On Thu, Mar 13, 2014 at 7:07 PM, Masataka Saito <pg...@gm...>
>> > wrote:
>> >>
>> >> Sorry. I lead your misunderstanding.
>> >> I meant about array style parameters and number of elements in each
>> >> array.
>> >>
>> >> For example, you have one coordNames, almost of array style parameters
>> >> for coordinators except for coordPgHbaEntries -- coordPorts,
>> >> poolerPorts, coordMasterServers, coordMasterDirs, coordMaxWALSenders,
>> >> coordSpecificExtraConfig, coordSpecificExtraPgHba -- must have only
>> >> one element.
>> >>
>> >> That's all I can guess by your description.
>> >>
>> >> Regards.
>> >>
>> >> On 13 March 2014 18:07, Juned Khan <jkh...@gm...> wrote:
>> >> > 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
>> >
>> >
>> >
>> >
>> > --
>> > Thanks,
>> > Juned Khan
>> > iNextrix Technologies Pvt Ltd.
>> > www.inextrix.com
>
>
>
>
> --
> Thanks,
> Juned Khan
> iNextrix Technologies Pvt Ltd.
> www.inextrix.com