postgres-xc-general

[Postgres-xc-general] pgxc_ctl init command problem

[Hector M. J. <hec...@et...>]

--- 
This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu
Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>

Re: [Postgres-xc-general] pgxc_ctl init command problem

[Nikhil S. <ni...@st...>]

Hi Hector,

Try adding the path to your pgxc binaries in your .bashrc on all the nodes
that are involved in the cluster.

HTH,
Nikhils

On Thu, Sep 26, 2013 at 1:49 AM, Hector M. Jacas <hec...@et...>wrote:

> Dear SEGNOR ,
>
> In recent months I install and successfully try 1.1 beta version of
> postgres-xc .
>
> Now the official version 1.1 is out.
>
> One of the components included in the contrib folder, pgxc_ctl, is where
> my focus is right now and I'm confronting some problems.
>
> The scenario I have is as follows:
>
> Component | Component Name   | Component Server
> gtm (no slave)   | gtm       | gtm
> -
> gtp proxy (3)    | gtmprx1   | dn01
>                  | gtmprx2   | dn02
>                  | gtmprx3   | dn03
> -
> coordinators (3) | coord1    | dn01
>                              | coord2 | dn02
>                              | coord3 | dn03
> -
> DataNodes (3)    | dnode1    | dn01
>                  | dnode2    | dn02
>                  | dnode3    | dn03
> -
>
> I can perform the deployment ( deploy gtm) and when I try to initialize
> the GTM components, for example :
>
> [ postgres @ rhelclient ~ ] $ pgxc_ctl
> Installing pgxc_ctl_bash script as / home / postgres / pgxc_ctl /
> pgxc_ctl_bash .
> Installing pgxc_ctl_bash script as / home / postgres / pgxc_ctl /
> pgxc_ctl_bash .
> Reading configuration using / home / postgres / pgxc_ctl / pgxc_ctl_bash -
> home / home / postgres / pgxc_ctl - configuration / home / postgres /
> pgxc_ctl / pgxc_ctl.conf
> Finished to read configuration .
>    PGXC_CTL ******** START ***************
>
> Current directory : / home / postgres / pgxc_ctl
> PGXC deploy gtm
> Postgres -XC Deploying materials.
> Prepare tarball to deploy ...
> Deploying to the server gtm .
> Deployment done.
> Init PGXC gtm
> Initialize master GTM
> GTM : no process killed
> bash: initgtm : command not found
> bash: gtm : command not found
> bash: gtm_ctl : command not found
> Done.
>
> Can not understand this message because users (postgres in this case) they
> have PATH correctly pointing to /usr/local/pgsql/bin and which gtm_ctl
> command (for example) properly returns the path of the command
> /usr/local/pgsql/bin/gtm_ctl.
>
> In ~/pgxc_ctl/pgxc_log/ directory the last log file contents:
>
> pgxc_ctl(30849):1309251435_25 PGXC deploy gtm
> pgxc_ctl(30849):1309251435_25 Deploying Postgres-XC materials.
> pgxc_ctl(30849):1309251435_25 Deploying Postgres-XC materials.
> pgxc_ctl(30849):1309251435_25 Prepare tarball to deploy ...
> pgxc_ctl(30849):1309251435_25 Actual command: ( tar czCf
> /home/postgres/pgsql /tmp/30849.tgz bin include lib share ) < /dev/null >
> /tmp/STDOUT_30849_0 2>&1
> pgxc_ctl(30849):1309251435_27 Deploying to the server gtm.
> pgxc_ctl(30849):1309251435_27 *** cmdList Dump
> *********************************
> allocated = 2, used = 1
> pgxc_ctl(30849):1309251435_27 === CMD: 0 ===
> pgxc_ctl(30849):1309251435_27 === CMD: 0 ===
> pgxc_ctl(30849):1309251435_27    --- CMD-EL: 0:host="gtm", command="rm -rf
> /home/postgres/pgsql/bin /home/postgres/pgsql/include
> /home/postgres/pgsql/lib /home/postgres/pgsql/share; mkdir -p
> /home/postgres/pgsql", localStdin="NULL", localStdout="NULL"
> pgxc_ctl(30849):1309251435_27    --- CMD-EL: 1:host="NULL", command="scp
> /tmp/30849.tgz postgres@gtm:/tmp", localStdin="NULL", localStdout="NULL"
> pgxc_ctl(30849):1309251435_27    --- CMD-EL: 2:host="gtm", command="tar
> xzCf /home/postgres/pgsql /tmp/30849.tgz; rm /tmp/30849.tgz",
> localStdin="NULL", localStdout="NULL"
> pgxc_ctl(30866):1309251435_27 Remote command: "rm -rf
> /home/postgres/pgsql/bin /home/postgres/pgsql/include
> /home/postgres/pgsql/lib /home/postgres/pgsql/share; mkdir -p
> /home/postgres/pgsql", actual: "ssh postgres@gtm "( rm -rf
> /home/postgres/pgsql/bin /home/postgres/pgsql/include
> /home/postgres/pgsql/lib /home/postgres/pgsql/share; mkdir -p
> /home/postgres/pgsql ) > /tmp/rhelclient_STDOUT_30849_2 2>&1" < /dev/null >
> /dev/null 2>&1"
> pgxc_ctl(30866):1309251435_28 Local command: "scp /tmp/30849.tgz
> postgres@gtm:/tmp", actual: "( scp /tmp/30849.tgz postgres@gtm:/tmp ) >
> /tmp/STDOUT_30849_3 2>&1 < /dev/null"
> pgxc_ctl(30866):1309251435_29 Remote command: "tar xzCf
> /home/postgres/pgsql /tmp/30849.tgz; rm /tmp/30849.tgz", actual: "ssh
> postgres@gtm "( tar xzCf /home/postgres/pgsql /tmp/30849.tgz; rm
> /tmp/30849.tgz ) > /tmp/rhelclient_STDOUT_30849_5 2>&1" < /dev/null >
> /dev/null 2>&1"
> pgxc_ctl(30849):1309251435_30 Actual command: ( rm -f /tmp/30849.tgz ) <
> /dev/null > /tmp/STDOUT_30849_6 2>&1
> pgxc_ctl(30849):1309251435_30 Deployment done.
> pgxc_ctl(30849):1309251511_35 PGXC init gtm
> pgxc_ctl(30849):1309251511_35 Initialize GTM master
> pgxc_ctl(30849):1309251511_35 *** cmdList Dump
> *********************************
> allocated = 2, used = 1
> pgxc_ctl(30849):1309251511_35 === CMD: 0 ===
> pgxc_ctl(30849):1309251511_35 === CMD: 0 ===
> pgxc_ctl(30849):1309251511_35    --- CMD-EL: 0:host="gtm",
> command="killall -u postgres -9 gtm; rm -rf /home/postgres/pgxc/nodes/gtm;
> mkdir -p /home/postgres/pgxc/nodes/gtm;**initgtm -Z gtm -D
> /home/postgres/pgxc/nodes/gtm"**, localStdin="NULL", localStdout="NULL"
> pgxc_ctl(30849):1309251511_35    --- CMD-EL: 1:host="gtm", command="cat >>
> /home/postgres/pgxc/nodes/gtm/**gtm.conf", localStdin="/tmp/STDIN_30849_**21",
> localStdout="NULL"
> pgxc_ctl(30849):1309251511_35    --- CMD-EL: 1:host="gtm", command="cat >>
> /home/postgres/pgxc/nodes/gtm/**gtm.conf", localStdin="/tmp/STDIN_30849_**21",
> localStdout="NULL"
> pgxc_ctl(30849):1309251511_35 #=============================**
> ==================
> pgxc_ctl(30849):1309251511_35 # Added at initialization, 20130925_15:11:35
> pgxc_ctl(30849):1309251511_35 listen_addresses = '*'
> pgxc_ctl(30849):1309251511_35 port = 20001
> pgxc_ctl(30849):1309251511_35 port = 20001
> pgxc_ctl(30849):1309251511_35 nodename = 'gtm'
> pgxc_ctl(30849):1309251511_35 startup = ACT
> pgxc_ctl(30849):1309251511_35 # End of addition
> pgxc_ctl(30849):1309251511_35    ----------
> pgxc_ctl(30849):1309251511_35    --- CMD-EL: 2:host="gtm", command="(gtm
> -x 2000 -D /home/postgres/pgxc/nodes/gtm &); sleep 1; gtm_ctl stop -Z gtm
> -D /home/postgres/pgxc/nodes/gtm"**, localStdin="NULL", localStdout="NULL"
> pgxc_ctl(31553):1309251511_35 Remote command: "killall -u postgres -9 gtm;
> rm -rf /home/postgres/pgxc/nodes/gtm; mkdir -p
> /home/postgres/pgxc/nodes/gtm;**initgtm -Z gtm -D
> /home/postgres/pgxc/nodes/gtm"**, actual: "ssh postgres@gtm "( killall -u
> postgres -9 gtm; rm -rf /home/postgres/pgxc/nodes/gtm; mkdir -p
> /home/postgres/pgxc/nodes/gtm;**initgtm -Z gtm -D
> /home/postgres/pgxc/nodes/gtm ) > /tmp/rhelclient_STDOUT_30849_**23 2>&1"
> < /dev/null > /dev/null 2>&1"
> pgxc_ctl(31553):1309251511_36 Remote command: "cat >>
> /home/postgres/pgxc/nodes/gtm/**gtm.conf", actual: "ssh postgres@gtm "(
> cat >> /home/postgres/pgxc/nodes/gtm/**gtm.conf ) >
> /tmp/rhelclient_STDOUT_30849_**25 2>&1" < /tmp/STDIN_30849_21 > /dev/null
> 2>&1"
> pgxc_ctl(31553):1309251511_37 Remote command: "(gtm -x 2000 -D
> /home/postgres/pgxc/nodes/gtm &); sleep 1; gtm_ctl stop -Z gtm -D
> /home/postgres/pgxc/nodes/gtm"**, actual: "ssh postgres@gtm "( (gtm -x
> 2000 -D /home/postgres/pgxc/nodes/gtm &); sleep 1; gtm_ctl stop -Z gtm -D
> /home/postgres/pgxc/nodes/gtm ) > /tmp/rhelclient_STDOUT_30849_**27 2>&1"
> < /dev/null > /dev/null 2>&1"
> pgxc_ctl(30849):1309251511_38 gtm: no process killed
> pgxc_ctl(30849):1309251511_38 bash: initgtm: command not found
> pgxc_ctl(30849):1309251511_38 bash: initgtm: command not found
> pgxc_ctl(30849):1309251511_38 bash: gtm: command not found
> pgxc_ctl(30849):1309251511_38 bash: gtm_ctl: command not found
> pgxc_ctl(30849):1309251511_38 Done.
>
>
> What could be happening ?
>
> Could you help me?
>
> Thanks a lot,
>
> Hector M Jacas
>
> ---
> This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE
> running at host imx3.etecsa.cu
> Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-general mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general
>
>


-- 
StormDB - http://www.stormdb.com
The Database Cloud