Menu
▾
▴
Re: [Postgres-xc-general] Problem with adding new datanode (ERROR: Node name datanode3 duplicate )
|
From: Koichi S. <koi...@gm...> - 2014-03-13 17:59:32
|
Yes, it should work. It may avoid any other problem if you invoke this command within pgxc_ctl, not command parameter. pgxc_ctl PGXC add coordinator master coord3 node5 20004 20010 /home/postgres/pgxc/nodes/coord Regards; --- Koichi Suzuki 2014-03-13 14:05 GMT+00:00 Juned Khan <jkh...@gm...>: > 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 > > ------------------------------------------------------------------------------ > 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 > |
