[Postgres-xl-general] pgxc_ctl : add slave datanode failed

Florian Iragne florian at iragne.fr
Tue Apr 19 11:58:57 PDT 2016


Hi Nikhil,

On 19/04/2016 10:02, Nikhil Sontakke wrote:
> >I try to add slave datanodes to my setup to test >failover. However, 
> it fails with the following error:
>
> Does this directory already exist on the slave node?

no, it is completely clean up before the command

> Also, can you please store the below in .pgxc_ctl in your $HOME and 
> re-run the "add datanode slave" command and share the logs please?
>

here you can find the log content: http://pastebin.com/dMJbPJRr

after the failed command, the pg_hba.conf file on the master datanode 
gets corrupted:
# Additional entry by adding the slave, 20160419_20:43:34
host replication postgres 172.16.3.0/24 trust
host replication postgres PJ�^A/32 trust
# End of addition ===============================

Bedides the log file, the on screen log shows that it can't ping (don't 
know which host), but it's normal since postgres user has no this 
permission on my system.

do_shell.c:doImmediate(221) Actual Command: ssh postgres at 172.16.3.15 "( 
rm -rf /home/postgres/pgxc/xlogdir; mkdir -p 
/home/postgres/pgxc/xlogdir;chmod 0700 /home/postgres/pgxc/xlogdir ) > 
/tmp/postgresxl_gtm_master_STDOUT_12921_4 2>&1" < /dev/null > /dev/null 2>&1
do_shell.c:doImmediate(226) Bring remote stdout: scp 
postgres at 172.16.3.15:/tmp/postgresxl_gtm_master_STDOUT_12921_4 
/tmp/STDOUT_12921_5 > /dev/null 2>&1
ping: icmp open socket: Operation not permitted
do_shell.c:doImmediate(221) Actual Command: ssh postgres at 172.16.3.34 "( 
pg_ctl stop -w -Z datanode -D /home/postgres/pgxc/nodes/dn_master -m 
fast ) > /tmp/postgresxl_gtm_master_STDOUT_12921_6 2>&1" < /dev/null > 
/dev/null 2>&1

thanks for your help

Florian
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20160419/704226c1/attachment.htm>


More information about the postgres-xl-general mailing list