<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<font size="2"><span style="font-size:11pt;">
<div class="PlainText"><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>
</body>
</html>