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

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

Hi koichi,

PFA
I have changed the log level as you said.


On Mon, Mar 24, 2014 at 10:43 AM, 鈴木 幸市 <ko...@in...> wrote:

>  Hmmm.. it’s quite strange.    Another way to collect info is to set the
> following in postgresql.conf for the coordinator in question.
>
>  log_min_messages = debug5
> log_error_verbosity = vervose
>
>  It could be too novice but please do this at the coordinator your psql
> is connecting.   Also, it will be safer to restart your coordinator to make
> these changes effective.
>
>  Could share the result?
>
>  Best;
> ---
> Koichi Suzuki
>
>  2014/03/20 18:57、Juned Khan <jkh...@gm...> のメール：
>
>  Hi Koichi,
>
>  it doesn't work with newly added datanode but with existing datanode it
> does
>
> koichi=# execute direct on (datanode3) 'select * from t1';
> ERROR:  Failed to get pooled connections
>
>
>
>
>
> On Thu, Mar 20, 2014 at 3:20 PM, Koichi Suzuki <koi...@gm...>wrote:
>
>> Does "EXECUTE DIRECT" work?
>> ---
>> Koichi Suzuki
>>
>>
>> 2014-03-20 18:00 GMT+09:00 Juned Khan <jkh...@gm...>:
>>  > Hi koichi,
>> >
>> > All components just stops and starts without any problem.
>> >
>> > But still i am not able to execute that query, same issue.
>> >
>> >
>> > On Thu, Mar 20, 2014 at 1:49 PM, Koichi Suzuki <koi...@gm...>
>> > wrote:
>> >>
>> >> What happens if you restart all the components?
>> >> ---
>> >> Koichi Suzuki
>> >>
>> >>
>> >> 2014-03-20 14:07 GMT+09:00 Juned Khan <jkh...@gm...>:
>> >> > Hi koichi,
>> >> >
>> >> > I have already tried to reload but still its giving me same error.
>> >> >
>> >> > postgres=# SELECT pgxc_pool_reload();
>> >> >  pgxc_pool_reload
>> >> > ------------------
>> >> >  t
>> >> > (1 row)
>> >> >
>> >> >
>> >> > koichi=# alter table t1 add node (datanode3);
>> >> > ERROR:  Failed to get pooled connections
>> >> >
>> >> >
>> >> > Although i am able to connect directly on datanode3.
>> >> >
>> >> > Please suggest.
>> >> >
>> >> >
>> >> >
>> >> > On Thu, Mar 20, 2014 at 6:26 AM, Koichi Suzuki <
>> koi...@gm...>
>> >> > wrote:
>> >> >>
>> >> >> Sorry, made a silly reply.
>> >> >>
>> >> >> Please try SELECT pgxc_pool_reload().   Documentation will be found
>> at
>> >> >>
>> >> >>
>> >> >>
>> http://postgres-xc.sourceforge.net/docs/1_1/functions-admin.html#FUNCTIONS-ADMIN-SET
>> >> >>
>> >> >> Good luck.
>> >> >> ---
>> >> >> Koichi Suzuki
>> >> >>
>> >> >>
>> >> >> 2014-03-19 20:56 GMT+09:00 Juned Khan <jkh...@gm...>:
>> >> >> > Hi koichi,
>> >> >> >
>> >> >> > Having little bit issue.
>> >> >> > New datanode is added successfully and even database structure is
>> >> >> > copied
>> >> >> > on new datanode(i have added datanode3).
>> >> >> >
>> >> >> > But as tables are empty, i am just trying to add new datanode
>> using
>> >> >> > below
>> >> >> > command
>> >> >> >
>> >> >> >
>> >> >> > koichi=# alter table t1 add node (datanode3);
>> >> >> > ERROR:  Failed to get pooled connections
>> >> >> >
>> >> >> > But as you suggested i tried to clean the connection.
>> >> >> >
>> >> >> > postgres=# CLEAN CONNECTION TO COORDINATOR (coord1,coord2) FOR
>> >> >> > koichi;
>> >> >> > CLEAN CONNECTION
>> >> >> >
>> >> >> > postgres=# CLEAN CONNECTION TO NODE
>> (datanode1,datanode2,datanode3)
>> >> >> > for
>> >> >> > database koichi;
>> >> >> > CLEAN CONNECTION
>> >> >> >
>> >> >> > But still its giving me same error, is there any other solution
>> for
>> >> >> > this
>> >> >> > problem?
>> >> >> >
>> >> >> > Regards,
>> >> >> > Juned khan
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > On Sat, Mar 15, 2014 at 11:59 AM, Juned Khan <jkh...@gm...
>> >
>> >> >> > wrote:
>> >> >> >>
>> >> >> >> Hi Koichi,
>> >> >> >>
>> >> >> >> Thanks for your information,
>> >> >> >> i just tried with stop and start components and it worked.
>> >> >> >>
>> >> >> >> This link will help me to fix future issues. And i ll keep in
>> mind
>> >> >> >> about that documentation bug.
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> On Sat, Mar 15, 2014 at 3:56 AM, Koichi Suzuki
>> >> >> >> <koi...@gm...>
>> >> >> >> wrote:
>> >> >> >>>
>> >> >> >>> 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
>> >> >> >>> >
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >> >> --
>> >> >> >> 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
>
>
>


-- 
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com