[pgpool-general: 3284] Strange behaviour of pcp_watchdog_info

[Karthick Thanigaimani]

Hi,

We were facing a Backenderror when we try to check the status of the node using the pcp_watchdog_info command.
we have postgres 9.3.4 and pgpool 3.3.3 .

$ psql -p9999 -h node1 -c "show pool_nodes"
Password:
 node_id |  hostname  | port | status | lb_weight |  role
---------+------------+------+--------+-----------+---------
 0       | node1 | 5432 | 2      | 0.500000  | primary
 1       | node2 | 5432 | 2      | 0.500000  | standby
(2 rows)

$ pcp_watchdog_info 10 node1 9898 postgres test 1
BackendError

$ pcp_watchdog_info 10 node1 9898 postgres test 1
node2 9999 9000 2

the nodes are in sync and the DB / pgpool is online as well.

can you please advise if this is a bug or what could be the reason for this.

regards
Karthick
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20141114/f0697046/attachment.html>