Menu
▾
▴
Re: [Postgres-xc-general] Problem with adding new datanode (ERROR: Node name datanode3 duplicate )
|
From: Koichi S. <koi...@gm...> - 2014-03-14 22:26:59
|
pgxc_ctl command "add datanode master" should run all the necessary clean_connection calls. Try to run clean_connection SQL command (specific to XC) as seen in http://postgres-xc.sourceforge.net/docs/1_1/sql-cleanconnection.html I found a document bug in the example CLEAN CONNECTION TO COORDINATOR coord1,coord2 FOR DATABASEname; You should enclose set of node names with (). Regards; --- Koichi Suzuki 2014-03-14 5:59 GMT+00:00 Juned Khan <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 > > ------------------------------------------------------------------------------ > 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 > |
