[pgpool-general: 1920] Basebackup failed

[Gilbert Soucy]

Hello

When I try to run a node recovery (ex: /usr/local/bin/pcp_recovery_node -d
100 192.168.0.109 9898 pgpool pgpool 1), I get an error.

In pgpool.log, I get:

2013-07-23 01:53:14 LOG:   pid 32698: starting recovering node 1
2013-07-23 01:53:14 LOG:   pid 32698: CHECKPOINT in the 1st stage done
2013-07-23 01:53:14 LOG:   pid 32698: starting recovery command: "SELECT
pgpool_recovery('basebackup.sh', '192.168.0.103', '/var/lib/pgsql')"
2013-07-23 01:53:14 ERROR: pid 32698: exec_recovery: basebackup.sh command
failed at 1st stage



If I run my script by hand with:

 ./basebackup.sh /var/lib/pgsql/data 192.168.0.103 /var/lib/pgsql


It works fine.

Here is the state of my two nodes:

 psql -p 5431 -h 192.168.0.109 -c "show pool_nodes;" -U postgres
 node_id |   hostname    | port | status | lb_weight |  role
---------+---------------+------+--------+-----------+--------
 0       | 192.168.0.102 | 5432 | 2      | 0.500000  | master
 1       | 192.168.0.103 | 5432 | 3      | 0.500000  | slave
(2 rows)


I have put added logging in my basebackup.sh script so I am pretty sure
that it does not even get called by pgpool during recovery. I suspect a
path/permissions issue.

Where should the basebackup.sh script be located on disk? How do I tell
which path pgpool is using to run it? The log does not mention where it is
trying to find it.

Thank you!

Gilbert
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130723/2eb43833/attachment.html>