<html><head></head><body><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>Hi,</div><div><br></div><div>Did you open the firewall ports for watchdog ?</div><div><br></div><div>I believe you need to open 9000/tcp and 9694/upd</div><div class="ydp82f51f1esignature"><br></div><div class="ydp82f51f1esignature">I don't see something wrong in your config</div><div class="ydp82f51f1esignature"><br></div><div class="ydp82f51f1esignature">Pierre</div></div>
<div><br></div><div><br></div>
</div><div id="ydp60440ec5yahoo_quoted_5233647167" class="ydp60440ec5yahoo_quoted">
<div style="font-family:'Helvetica Neue', Helvetica, Arial, sans-serif;font-size:13px;color:#26282a;">
<div>
On Thursday, August 23, 2018, 8:04:19 PM GMT+2, Sebastian Lefke <mentatpiter@live.de> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="ydp60440ec5yiv4615385289">
<div dir="ltr">
<font size="2"><span style="font-size:11pt;">
<div class="ydp60440ec5yiv4615385289PlainText"><br>
Hi,<br>
<br>
i have the following setup<br>
Server1D = primary database server<br>
Server2D = hot-standby (straming repl.) database server<br>
Server3P = pgpool2 v. 3.7.5<br>
Server4P = pgpool2 v. 3.7.5<br>
<br>
When I start pgpool2 on Server3P or Server4P it starts fine and it takes the virtual ip.<br>
But when I want to start another pgpool server it can not connect to the master node and exits.<br>
So I can only have one active pgpool Server, other nodes get rejected.<br>
<br>
I checked the configuration files a dozen times, but I can't find any wrong settings. Notice that some<br>
configuration parameter are at the end of the file.<br>
<br>
When i start pgpool2 on Server4P first:<br>
Log on Server 3P:<br>
Aug 23 16:51:11 SERVER3P pgpool[19864]: [184-2] 2018-08-23 16:51:11: pid 19864:LOCATION: watchdog.c:2802<br>
Aug 23 16:51:11 SERVER3P pgpool[19864]: [185-1] 2018-08-23 16:51:11: pid 19864:DEBUG: STATE MACHINE INVOKED WITH EVENT = PACKET RECEIVED Current State = LOADING<br>
Aug 23 16:51:11 SERVER3P pgpool[19864]: [185-2] 2018-08-23 16:51:11: pid 19864:LOCATION: watchdog.c:4640<br>
Aug 23 16:51:11 SERVER3P pgpool[19864]: [186-1] 2018-08-23 16:51:11: pid 19864:DEBUG: received packet, watchdog node:[] command id:[4] type:[REJECT] state:[LOADING]<br>
Aug 23 16:51:11 SERVER3P pgpool[19864]: [186-2] 2018-08-23 16:51:11: pid 19864:LOCATION: watchdog.c:6673<br>
Aug 23 16:51:11 SERVER3P pgpool[19864]: [187-1] 2018-08-23 16:51:11: pid 19864:FATAL: Add to watchdog cluster request is rejected by node "SERVER4P:9000"<br>
Aug 23 16:51:11 SERVER3P pgpool[19864]: [187-2] 2018-08-23 16:51:11: pid 19864:HINT: check the watchdog configurations.<br>
Aug 23 16:51:11 SERVER3P pgpool[19864]: [187-3] 2018-08-23 16:51:11: pid 19864:LOCATION: watchdog.c:4879<br>
Aug 23 16:51:11 SERVER3P pgpool[19864]: [188-1] 2018-08-23 16:51:11: pid 19864:LOG: Watchdog is shutting down<br>
Aug 23 16:51:11 SERVER3P pgpool[19864]: [188-2] 2018-08-23 16:51:11: pid 19864:LOCATION: watchdog.c:2894<br>
Log on Server 4P:<br>
Aug 23 16:25:43 SERVER4P pgpool[7982]: [1-1] 2018-08-23 16:25:43: pid 7982:LOG: waiting for watchdog to initialize<br>
Aug 23 16:25:43 SERVER4P pgpool[7990]: [1-1] 2018-08-23 16:25:43: pid 7990:LOG: setting the local watchdog node name to "SERVER4P:5433 Linux SERVER4P"<br>
Aug 23 16:25:43 SERVER4P pgpool[7990]: [2-1] 2018-08-23 16:25:43: pid 7990:LOG: watchdog cluster is configured with 1 remote nodes<br>
Aug 23 16:25:43 SERVER4P pgpool[7990]: [3-1] 2018-08-23 16:25:43: pid 7990:LOG: watchdog remote node:0 on SERVER3P:9000<br>
Aug 23 16:25:43 SERVER4P pgpool[7990]: [4-1] 2018-08-23 16:25:43: pid 7990:LOG: interface monitoring is disabled in watchdog<br>
Aug 23 16:25:43 SERVER4P pgpool[7990]: [5-1] 2018-08-23 16:25:43: pid 7990:LOG: watchdog node state changed from [DEAD] to [LOADING]<br>
Aug 23 16:25:48 SERVER4P pgpool[7990]: [6-1] 2018-08-23 16:25:48: pid 7990:LOG: watchdog node state changed from [LOADING] to [JOINING]<br>
Aug 23 16:25:52 SERVER4P pgpool[7990]: [7-1] 2018-08-23 16:25:52: pid 7990:LOG: watchdog node state changed from [JOINING] to [INITIALIZING]<br>
Aug 23 16:25:53 SERVER4P pgpool[7990]: [8-1] 2018-08-23 16:25:53: pid 7990:LOG: I am the only alive node in the watchdog cluster<br>
Aug 23 16:25:53 SERVER4P pgpool[7990]: [8-2] 2018-08-23 16:25:53: pid 7990:HINT: skipping stand for coordinator state<br>
Aug 23 16:25:53 SERVER4P pgpool[7990]: [9-1] 2018-08-23 16:25:53: pid 7990:LOG: watchdog node state changed from [INITIALIZING] to [MASTER]<br>
Aug 23 16:25:53 SERVER4P pgpool[7990]: [10-1] 2018-08-23 16:25:53: pid 7990:LOG: I am announcing my self as master/coordinator watchdog node<br>
Aug 23 16:25:57 SERVER4P pgpool[7990]: [11-1] 2018-08-23 16:25:57: pid 7990:LOG: I am the cluster leader node<br>
Aug 23 16:25:57 SERVER4P pgpool[7990]: [11-2] 2018-08-23 16:25:57: pid 7990:DETAIL: our declare coordinator message is accepted by all nodes<br>
Aug 23 16:25:57 SERVER4P pgpool[7990]: [12-1] 2018-08-23 16:25:57: pid 7990:LOG: setting the local node "SERVER4P:5433 Linux SERVER4P" as watchdog cluster master<br>
Aug 23 16:25:57 SERVER4P pgpool[7990]: [13-1] 2018-08-23 16:25:57: pid 7990:LOG: I am the cluster leader node. Starting escalation process<br>
Aug 23 16:25:57 SERVER4P pgpool[7982]: [2-1] 2018-08-23 16:25:57: pid 7982:LOG: watchdog process is initialized<br>
Aug 23 16:25:57 SERVER4P pgpool[7990]: [14-1] 2018-08-23 16:25:57: pid 7990:LOG: escalation process started with PID:8104<br>
Aug 23 16:25:57 SERVER4P pgpool[7990]: [15-1] 2018-08-23 16:25:57: pid 7990:LOG: new IPC connection received<br>
Aug 23 16:25:57 SERVER4P pgpool[8104]: [14-1] 2018-08-23 16:25:57: pid 8104:LOG: watchdog: escalation started<br>
Aug 23 16:25:57 SERVER4P pgpool[7990]: [16-1] 2018-08-23 16:25:57: pid 7990:LOG: new IPC connection received<br>
Aug 23 16:25:57 SERVER4P pgpool[7982]: [3-1] 2018-08-23 16:25:57: pid 7982:LOG: Setting up socket for 0.0.0.0:5433<br>
Aug 23 16:25:57 SERVER4P pgpool[7982]: [4-1] 2018-08-23 16:25:57: pid 7982:LOG: Setting up socket for :::5433<br>
Aug 23 16:25:57 SERVER4P pgpool[8103]: [3-1] 2018-08-23 16:25:57: pid 8103:LOG: 2 watchdog nodes are configured for lifecheck<br>
Aug 23 16:25:57 SERVER4P pgpool[8103]: [4-1] 2018-08-23 16:25:57: pid 8103:LOG: watchdog nodes ID:0 Name:"SERVER4P:5433 Linux SERVER4P"<br>
Aug 23 16:25:57 SERVER4P pgpool[8103]: [4-2] 2018-08-23 16:25:57: pid 8103:DETAIL: Host:"SERVER4P" WD Port:9000 pgpool-II port:5433<br>
Aug 23 16:25:57 SERVER4P pgpool[8103]: [5-1] 2018-08-23 16:25:57: pid 8103:LOG: watchdog nodes ID:1 Name:"Not_Set"<br>
Aug 23 16:25:57 SERVER4P pgpool[8103]: [5-2] 2018-08-23 16:25:57: pid 8103:DETAIL: Host:"SERVER3P" WD Port:9000 pgpool-II port:9999<br>
Aug 23 16:25:57 SERVER4P pgpool[7982]: [5-1] 2018-08-23 16:25:57: pid 7982:LOG: find_primary_node_repeatedly: waiting for finding a primary node<br>
Aug 23 16:25:57 SERVER4P pgpool[7982]: [6-1] 2018-08-23 16:25:57: pid 7982:LOG: find_primary_node: checking backend no 0<br>
Aug 23 16:25:57 SERVER4P pgpool[7982]: [7-1] 2018-08-23 16:25:57: pid 7982:LOG: find_primary_node: primary node id is 0<br>
Aug 23 16:25:57 SERVER4P pgpool[7982]: [8-1] 2018-08-23 16:25:57: pid 7982:LOG: pgpool-II successfully started. version 3.7.5 (amefuriboshi)<br>
Aug 23 16:25:58 SERVER4P pgpool[8108]: [6-1] 2018-08-23 16:25:58: pid 8108:LOG: set SO_REUSEPORT option to the socket<br>
Aug 23 16:25:58 SERVER4P pgpool[8106]: [6-1] 2018-08-23 16:25:58: pid 8106:LOG: set SO_REUSEPORT option to the socket<br>
Aug 23 16:25:58 SERVER4P pgpool[8108]: [7-1] 2018-08-23 16:25:58: pid 8108:LOG: creating socket for sending heartbeat<br>
Aug 23 16:25:58 SERVER4P pgpool[8108]: [7-2] 2018-08-23 16:25:58: pid 8108:DETAIL: set SO_REUSEPORT<br>
Aug 23 16:25:58 SERVER4P pgpool[8106]: [7-1] 2018-08-23 16:25:58: pid 8106:LOG: creating watchdog heartbeat receive socket.<br>
Aug 23 16:25:58 SERVER4P pgpool[8106]: [7-2] 2018-08-23 16:25:58: pid 8106:DETAIL: set SO_REUSEPORT<br>
Aug 23 16:26:01 SERVER4P pgpool[8104]: [15-1] 2018-08-23 16:26:01: pid 8104:LOG: successfully acquired the delegate IP:"10.2.65.88"<br>
Aug 23 16:26:01 SERVER4P pgpool[8104]: [15-2] 2018-08-23 16:26:01: pid 8104:DETAIL: 'if_up_cmd' returned with success<br>
Aug 23 16:26:01 SERVER4P pgpool[7990]: [17-1] 2018-08-23 16:26:01: pid 7990:LOG: watchdog escalation process with pid: 8104 exit with SUCCESS.<br>
Aug 23 16:51:11 SERVER4P pgpool[7990]: [18-1] 2018-08-23 16:51:11: pid 7990:LOG: new watchdog node connection is received from "10.2.65.86:65199"<br>
Aug 23 16:51:11 SERVER4P pgpool[7990]: [19-1] 2018-08-23 16:51:11: pid 7990:LOG: new watchdog node connection is received from "10.2.65.86:176"<br>
<br>
</div>
</span></font>
</div>
</div>_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br><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></body></html>