Menu
▾
▴
Re: [Postgres-xc-general] Problem with adding new datanode (ERROR: Node name datanode3 duplicate )
|
From: Juned K. <jkh...@gm...> - 2014-03-14 04:51:49
|
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 |
