[pgpool-general: 6246] Re: FATAL: Add to watchdog cluster request is rejected by node "redshirt2018090300:9000"

Pierre Timmermans ptim007 at yahoo.com
Tue Oct 9 03:30:04 JST 2018


Not sure if it is important but when I look at my configuration I have some extra variables: other_pgpool_port and other_wd_port. Since it complains about the config, maybe it is relevant ?
Also make sure that firewall ports 9694 and 9000 are open on both servers
Here is my config (3 servers)
heartbeat_destination0 = 'pgpool01'heartbeat_destination_port0 = 9694

heartbeat_destination1 = 'pgpool02'heartbeat_destination_port1 = 9694

heartbeat_destination2 = 'pgpool03'heartbeat_destination_port2 = 9694

other_pgpool_hostname0 = 'pgpool02'other_pgpool_port0 = 9999other_wd_port0 = 9000

other_pgpool_hostname1 = 'pgpool03'other_pgpool_port1 = 9999other_wd_port1 = 9000
Rgds, 
Pierre 

    On Monday, October 8, 2018, 4:59:15 PM GMT+2, Sebastian Stellingwerff <sebas at bakkerspees.nl> wrote:  
 
 I've setup a cluster with two nodes, but I run into this problem, one of them dies with the error:

FATAL:  Add to watchdog cluster request is rejected by node "redshirt2018090300:9000"
HINT:  check the watchdog configurations.

Now I've checked the configurations, and run a diff on the two, but the only thing that differs is the hostnames.

125c125
< wd_hostname = 'redshirt2018090300'
---
> wd_hostname = 'redshirt2018091100'
157c157
< heartbeat_destination0 = 'redshirt2018091100'
---
> heartbeat_destination0 = 'redshirt2018090300'
160c160
< other_pgpool_hostname0 = 'redshirt2018091100'
---
> other_pgpool_hostname0 = 'redshirt2018090300'


Is there another way of seeing what else this could be? I already set loglevel to 3 and on verbose.

Thanks!

sebastian
_______________________________________________
pgpool-general mailing list
pgpool-general at pgpool.net
http://www.pgpool.net/mailman/listinfo/pgpool-general
  
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20181008/49f0b756/attachment.html>


More information about the pgpool-general mailing list