[pgpool-general: 3285] Re: Strange behaviour of pcp_watchdog_info

[Yugo Nagata]

Hi,

On Fri, 14 Nov 2014 08:40:20 +0800
Karthick Thanigaimani <kargold100 at yahoo.com> wrote:

> 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

Are these tow results run in deffernt servers? If so, please
check other_pgpool_hostnameX of pgpool.conf in the both servers.
One of them may not have specification of ohter_pgopol_hostname2.

> 
> 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
> 


-- 
Yugo Nagata <nagata at sraoss.co.jp>