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

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

Koichi=# alter table t1 add node (datanode3);
ERROR:  Failed to get pooled connections
CONTEXT:  SQL statement "EXECUTE DIRECT ON (coord3) 'SELECT
pg_catalog.pg_try_advisory_xact_lock_shared(65535, 0)'"



On Fri, Mar 14, 2014 at 11:20 AM, Juned Khan <jkh...@gm...> wrote:

> Hi Masataka, Koichi,
>
> New datanode is successfully added and all components are running.i have
> small doubt.
>
> As i just added new datanode so , will existing database automatically
> copied
> on this datanode or i have to create and import it manually from another
> datanode ?
>
> As per that video, we need to just fire alter query just like :
> *alter table t1 add node (datanode3);*
> is that so ?
>
> and yeah as of now i am getting Failed to get pooled connections error.
>
> koichi=# execute direct on (datanode3) 'select * from t1';
> ERROR:  Failed to get pooled connections
>
> Please advice.
>
>
>
> On Fri, Mar 14, 2014 at 11:03 AM, Juned Khan <jkh...@gm...> wrote:
>
>> Hi Masataka
>>
>> Thanks you very much, commands are working now.
>> I thought that element doesn't affect because at initial level
>> it was not showing any error.
>>
>> But thanks a lot, just fixed another same kind of problems. ;)
>>
>>
>>
>> On Fri, Mar 14, 2014 at 10:40 AM, Masataka Saito <pg...@gm...>wrote:
>>
>>> coordMasterServers defines 2 nodes, but coordSpecificExtraConfig and
>>> coordSpecificExtraPgHba have 4 elements.
>>>
>>> On 14 March 2014 13:51, Juned Khan <jkh...@gm...> wrote:
>>> > Hi Masataka,
>>> >
>>> > Please find the attachment. i have attached my pgxc_ctl.conf
>>> >
>>> > see my pastebin link : http://pastebin.com/n35QkmpK
>>> >
>>> >
>>> > On Fri, Mar 14, 2014 at 10:18 AM, Juned Khan <jkh...@gm...>
>>> wrote:
>>> >>
>>> >> Hi Masataka,
>>> >>
>>> >> Please find the attachment. i have attached my pgxc_ctl.conf
>>> >>
>>> >>
>>> >> On Thu, Mar 13, 2014 at 11:39 PM, Masataka Saito <pg...@gm...>
>>> wrote:
>>> >>>
>>> >>> 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
>>> >>
>>> >>
>>> >>
>>> >>
>>> >> --
>>> >> 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