#77 pgxc_ctl failing even in BASH

[Brian C]

I am getting the same error from pgxc_ctl that a lot of other people have reported. I have seen the response about making sure it is running in BASH and have done that. Have even pointed /bin/sh -> /bin/bash and renamed /bin/csh, /bin/zcsh, and /bin/tcsh so they can not be called. Also verified in /etc/passwd that BASH is the default shell. So I am resonably confedent I am running it in the correct shell.

Using build postgres-xl-9.5r1.4 on CentOS release 6.7 on kernal 2.6.32-573.18.1.el6.x86_64.

Any thoughts about what i should look at to trouble shoot this?

pgxc_ctl init all
/bin/bash
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 reading configuration.
* PGXC_CTL START **

Current directory: /home/postgres/pgxc_ctl
Initialize GTM master
ERROR: could not open file (null)/STDIN_4705_0 for write, No such file or directory
Done.
Start GTM master
sh: -c: line 0: syntax error near unexpected token (' sh: -c: line 0:(ssh bcook@10.96.33.46 touch (null)/ndb400_STDOUT_4705_2) < /dev/null > /dev/null 2>&1'
sh: -c: line 0: syntax error near unexpected token null' sh: -c: line 0:(touch (null)/STDOUT_4705_1) < /dev/null > /dev/null'
sh: -c: line 0: syntax error near unexpected token (' sh: -c: line 0:(scp bcook@10.96.33.46:(null)/ndb400_STDOUT_4705_2 (null)/STDOUT_4705_1; ssh bcook@10.96.33.46 rm -rf (null)/ndb400_STDOUT_4705_2) < /dev/null > /dev/null'
ERROR: Cannot open "(null)/STDOUT_4705_1" for read, No such file or directory
sh: -c: line 0: syntax error near unexpected token ('** sh: -c: line 0:(rm -f (null)/STDOUT_4705_1) < /dev/null > /dev/null'
bash: -c: line 0: syntax error near unexpected token (' bash: -c: line 0:rm -f (null)/ndb400_STDOUT_4705_2 > /dev/null 2>&1'
Initialize all the coordinator masters.
Initialize coordinator master coord1.
ERROR: could not open file (null)/STDIN_4705_3 for write, No such file or directory
Initialize coordinator master coord2.
ERROR: could not open file (null)/STDIN_4705_4 for write, No such file or directoryDone.**

[Brian C]

I got an answer from pavanvd in another thread. In the newest version pgxc_ctl.conf
file needs to include the two attributes below.

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

https://sourceforge.net/p/postgres-xl/tickets/74/

This ticket can be closed. I apprently do not have permissions to do it.