[pgpool-general: 3268] Execution of command failed

[Bill W]

Hello


I'm testing pgpool and it appears that pgpool never actually calls the
first stage script.

I've added logging to the first stage script and it never logs that it
has been called.

Any ideas?

pgpool-II-3.4.0
openSUSE 13.2 (x86_64)
postgresql-server-9.3-3.1.2.noarch


This is the error I get from pcp_reconvery_node:

DEBUG: send: tos="R", len=44
DEBUG: recv: tos="r", len=21, data=AuthenticationOK
DEBUG: send: tos="D", len=6
DEBUG: recv: tos="e", len=20, data=recovery failed
DEBUG: command failed. reason=recovery failed
BackendError
DEBUG: send: tos="X", len=4



And strace pgpool -nD returns this:

14-11-12 21:43:36: pid 21023: LOG:  starting recovering node 1
2014-11-12 21:43:36: pid 21023: LOG:  executing recovery
2014-11-12 21:43:36: pid 21023: DETAIL:  starting recovery command:
"SELECT pgpool_recovery('pgpool_basebackup', '10.0.51.62',
'/var/lib/pgsql/data', '5432')"
2014-11-12 21:43:36: pid 21023: LOG:  executing recovery
2014-11-12 21:43:36: pid 21023: DETAIL:  disabling statement_timeout
2014-11-12 21:43:36: pid 21023: ERROR:  executing recovery, execution of
command failed at "1st stage"
2014-11-12 21:43:36: pid 21023: DETAIL:  command:"pgpool_basebackup"
) = ? ERESTARTNOHAND (To be restarted if no handler)
--- SIGUSR2 {si_signo=SIGUSR2, si_code=SI_USER, si_pid=21023, si_uid=0} ---
rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN
RT_1], NULL, 8) = 0
write(8, "\0", 1)                       = 1
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
rt_sigreturn()                          = -1 EINTR (Interrupted system call)
rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN
RT_1], NULL, 8) = 0
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
gettimeofday({1415846616, 459894}, NULL) = 0
select(8, [7], NULL, NULL, {84, 116932}) = 1 (in [7], left {84, 116930})
read(7, "\0", 1)                        = 1
rt_sigprocmask(SIG_SETMASK, ~[ILL TRAP ABRT BUS FPE SEGV CONT SYS RTMIN
RT_1], NULL, 8) = 0
kill(20928, SIGUSR2)                    = 0
kill(20929, SIGUSR2)                    = 0
...
rt_sigprocmask(SIG_SETMASK, [], NULL, 8) = 0
gettimeofday({1415846616, 474081}, NULL) = 0
select(8, [7], NULL, NULL, {84, 102745}