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

[Karthick Thanigaimani]

Hi,
These are run the the same servers and we checked the _otherhostname_ it looks fine only.


________________________________
 From: Yugo Nagata <nagata at sraoss.co.jp>
To: Karthick Thanigaimani <kargold100 at yahoo.com> 
Cc: "pgpool-general at pgpool.net" <pgpool-general at pgpool.net> 
Sent: Friday, 14 November 2014 7:08 PM
Subject: Re: [pgpool-general: 3284] Strange behaviour of pcp_watchdog_info
 

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20141114/16d35c0a/attachment.htm>