<html><body><div style="font-family: arial, helvetica, sans-serif; font-size: 12pt; color: #000000"><div>Should perhaps have gone to the list:<br></div><div><br data-mce-bogus="1"></div><div><div>>It's the -other- node that is rejecting the node due to the configuration. When I start the rejected one first, the other one is rejected by that one. This leads me to believe there is a problem with differences in the configuration, if there was a configuration problem in itself, I would expect it's own process to complain.<br></div><div>>As this is an isolated test setup, there is no firewall on the machines.<br></div><div>>The past in the previous mail was the -diff- of the two configurations, as other_pgpool_port and other_wd_port are the same on both hosts, they are not shown.<br></div></div><div><br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>I started looking at the source code, and this seems to the relevant check:<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div> if ((wdNode->wd_port == tempNode->wd_port && wdNode->pgpool_port == tempNode->pgpool_port) &&<br> ((strcmp(wdNode->hostname, conn->addr) == 0) || (strcmp(wdNode->hostname, tempNode->hostname) == 0)))<br></div><div><br data-mce-bogus="1"></div><div>This led me to notice 'wdNode->pgpool_port == tempNode->pgpool_port'.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>other_pgpool_port0=5433 on both sides, so both the configurations where right. but the port field was set to 5432 on both sides.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>So this bit matches 'other_pgpool_port0' on one side with 'port' on the other side, which makes sense.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>I would like to kindly request that the error states which fields are unmatched. This one 'if' has a lot of (at least 13) cases how it could fail, counting only when a field is unmatched, not which. Some matches like 'strcmp(wdNode->hostname, conn->addr)' might come from unexpected angles. <br data-mce-bogus="1"></div><div>A simple 'verify the other watchdog node configurations' doesn't really cut it I think.<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Thanks!<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><div>Sebastian<br data-mce-bogus="1"></div><div><br data-mce-bogus="1"></div><hr id="zwchr" data-marker="__DIVIDER__"><div data-marker="__HEADERS__"><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><b>From: </b>"Pierre Timmermans" <ptim007@yahoo.com><br><b>To: </b>"pgpool-general" <pgpool-general@pgpool.net>, "Sebastian Stellingwerff" <sebas@bakkerspees.nl><br><b>Sent: </b>Monday, October 8, 2018 8:30:04 PM<br><b>Subject: </b>Re: [pgpool-general: 6245] FATAL: Add to watchdog cluster request is rejected by node "redshirt2018090300:9000"<br></blockquote></div><div data-marker="__QUOTED_TEXT__"><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div style="font-family:Helvetica Neue, Helvetica, Arial, sans-serif;font-size:16px;"><div><div>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 ?</div><br><div>Also make sure that firewall ports 9694 and 9000 are open on both servers</div><br><div>Here is my config (3 servers)</div><br><div><span><div>heartbeat_destination0 = 'pgpool01'</div><div>heartbeat_destination_port0 = 9694</div><br><br><div>heartbeat_destination1 = 'pgpool02'</div><div>heartbeat_destination_port1 = 9694</div><br><br><div>heartbeat_destination2 = 'pgpool03'</div><div>heartbeat_destination_port2 = 9694</div><br><br><div>other_pgpool_hostname0 = 'pgpool02'</div><div>other_pgpool_port0 = 9999</div><div>other_wd_port0 = 9000</div><br><br><div>other_pgpool_hostname1 = 'pgpool03'</div><div>other_pgpool_port1 = 9999</div><div>other_wd_port1 = 9000</div><br></span>Rgds, </div><br><div class="ydpc58d9dcbsignature">Pierre</div></div>
<br><br>
</div><div id="ydpe42ae9b0yahoo_quoted_9355246652" class="ydpe42ae9b0yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Monday, October 8, 2018, 4:59:15 PM GMT+2, Sebastian Stellingwerff <sebas@bakkerspees.nl> wrote:
</div>
<br>
<br>
<div><div dir="ltr">I've setup a cluster with two nodes, but I run into this problem, one of them dies with the error:<br></div><div dir="ltr"><br></div><div dir="ltr">FATAL: Add to watchdog cluster request is rejected by node "redshirt2018090300:9000"<br></div><div dir="ltr">HINT: check the watchdog configurations.<br></div><div dir="ltr"><br></div><div dir="ltr">Now I've checked the configurations, and run a diff on the two, but the only thing that differs is the hostnames.<br></div><div dir="ltr"><br></div><div dir="ltr">125c125<br></div><div dir="ltr">< wd_hostname = 'redshirt2018090300'<br></div><div dir="ltr">---<br></div><div dir="ltr">> wd_hostname = 'redshirt2018091100'<br></div><div dir="ltr">157c157<br></div><div dir="ltr">< heartbeat_destination0 = 'redshirt2018091100'<br></div><div dir="ltr">---<br></div><div dir="ltr">> heartbeat_destination0 = 'redshirt2018090300'<br></div><div dir="ltr">160c160<br></div><div dir="ltr">< other_pgpool_hostname0 = 'redshirt2018091100'<br></div><div dir="ltr">---<br></div><div dir="ltr">> other_pgpool_hostname0 = 'redshirt2018090300'<br></div><div dir="ltr"><br></div><div dir="ltr"><br></div><div dir="ltr">Is there another way of seeing what else this could be? I already set loglevel to 3 and on verbose.<br></div><div dir="ltr"><br></div><div dir="ltr">Thanks!<br></div><div dir="ltr"><br></div><div dir="ltr">sebastian<br></div><div dir="ltr">_______________________________________________<br></div><div dir="ltr">pgpool-general mailing list<br></div><div dir="ltr"><a href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br></div><div dir="ltr"><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="nofollow" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></div></div>
</div>
</div></div><br></blockquote></div></div></body></html>