#74 Postgres-xl cannot add new datanode to existing cluster

[Karen]

Hi

I have installed postgres-xl 9.5 with GTM one coordinator and 4 datanodes. When I want to add datanode I get the following
PGXC add datanode master db3 localhost 40003 40013 $dataDirRoot/db3 none none none
Segmentation fault.

Also my pgxc_ctl does not work properly for example

PGXC stop datanode db1
Stopping datanode master db1.
sh: -c: line 0: syntax error near unexpected token (' sh: -c: line 0:(ssh postgres@10.0.0.4 touch (null)/pgxl1_STDOUT_8677_1) < /dev/null > /dev/null 2>&1'
sh: -c: line 0: syntax error near unexpected token null' sh: -c: line 0:(touch (null)/STDOUT_8677_0) < /dev/null > /dev/null'
sh: -c: line 0: syntax error near unexpected token (' sh: -c: line 0:(scp postgres@10.0.0.4:(null)/pgxl1_STDOUT_8677_1 (null)/STDOUT_8677_0; ssh postgres@10.0.0.4 rm -rf (null)/pgxl1_STDOUT_8677_1) < /dev/null > /dev/null'
ERROR: Cannot open "(null)/STDOUT_8677_0" for read, No such file or directory
sh: -c: line 0: syntax error near unexpected token (' sh: -c: line 0:(rm -f (null)/STDOUT_8677_0) < /dev/null > /dev/null'
bash: -c: line 0: syntax error near unexpected token (' bash: -c: line 0:rm -f (null)/pgxl1_STDOUT_8677_1 > /dev/null 2>&1'
Done.
PGX

Is there any solution for my problem

[Brian C]

Having the same problem. Thread below says the command is not running in BASH either locally or via SSH on other nodes. I have verified I am using BASH and BASH is the default shell for all the servers. I even renamed csh, zcsh, and tcsh to make sure they could not be called. Still getting the same error.

https://sourceforge.net/p/postgres-xl/mailman/message/35525995/

[Pavan Deolasee]

Can you check if the following variables are set correctly in pgxc_ctl.conf
file?

tmpDir=/tmp # temporary dir used in XC servers
localTmpDir=$tmpDir # temporary dir used here locally

If not, can you set them and try again?

Thanks,
Pavan

On Fri, Feb 10, 2017 at 10:06 PM, Brian C pronerd@users.sf.net wrote:

Having the same problem. Thread below says the command is not running in
BASH either locally or via SSH on other nodes. I have verified I am using
BASH and BASH is the default shell for all the servers. I even renamed csh,
zcsh, and tcsh to make sure they could not be called. Still getting the
same error.

https://sourceforge.net/p/postgres-xl/mailman/message/35525995/

• [tickets:#74] https://sourceforge.net/p/postgres-xl/tickets/74/
  Postgres-xl cannot add new datanode to existing cluster*

Status: open
Milestone: Undecided
Created: Thu Nov 17, 2016 03:43 PM UTC by Karen
Last Updated: Thu Nov 17, 2016 03:43 PM UTC
Owner: nobody

Hi

I have installed postgres-xl 9.5 with GTM one coordinator and 4 datanodes.
When I want to add datanode I get the following
PGXC add datanode master db3 localhost 40003 40013 $dataDirRoot/db3 none
none none
Segmentation fault.

Also my pgxc_ctl does not work properly for example

PGXC stop datanode db1
Stopping datanode master db1.
sh: -c: line 0: syntax error near unexpected token (' sh: -c: line 0:(ssh
postgres@10.0.0.4 touch (null)/pgxl1_STDOUT_8677_1) < /dev/null >
/dev/null 2>&1'
sh: -c: line 0: syntax error near unexpected token null' sh: -c: line 0:(touch
(null)/STDOUT_8677_0) < /dev/null > /dev/null'
sh: -c: line 0: syntax error near unexpected token (' sh: -c: line 0:(scp
postgres@10.0.0.4:(null)/pgxl1_STDOUT_8677_1 (null)/STDOUT_8677_0; ssh
postgres@10.0.0.4 rm -rf (null)/pgxl1_STDOUT_8677_1) < /dev/null >
/dev/null'
ERROR: Cannot open "(null)/STDOUT_8677_0" for read, No such file or
directory
sh: -c: line 0: syntax error near unexpected token (' sh: -c: line 0:(rm
-f (null)/STDOUT_8677_0) < /dev/null > /dev/null'
bash: -c: line 0: syntax error near unexpected token (' bash: -c: line 0:rm
-f (null)/pgxl1_STDOUT_8677_1 > /dev/null 2>&1'
Done.
PGX

Is there any solution for my problem

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/postgres-xl/tickets/74/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

--
Pavan Deolasee http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services

[Brian C]

BINGO! That fixed it! Looks like I was working from an out of date example page that did not include those!

THANK YOU!!