[pgpool-general: 5228] Failed to check replication time lag - infinitely occurring error

[Bhattacharyya, Subhro]

Hi,

We have a 2 node postgresql cluster along with 3 pgpool-II nodes.
The version of pgpool-II that we are using is 3.5.2

We keep getting the following logs infinitely in the logs of all the pgpool-II nodes

2017-01-12 07:09:55: pid 2534: ERROR:  Failed to check replication time lag
2017-01-12 07:09:55: pid 2534: DETAIL:  Query to node (1) returned no data
2017-01-12 07:09:55: pid 2534: CONTEXT:  while checking replication time lag

Following is the watchdog cluster/node information:

Watchdog Cluster Information
Total Nodes          : 3
Remote Nodes         : 2
Quorum state         : QUORUM EXIST
Alive Remote Nodes   : 2
VIP up on local node : NO
Master Node Name     : Linux_270f905f-37ef-46a2-9f7b-9b92b96a6ea9_9999
Master Host Name     : 10.11.61.50

Watchdog Node Information
Node Name      : Linux_26acb17c-dadc-49ca-bb14-44820ab6a78a_9999
Host Name      : 10.11.61.52
Delegate IP    : Not_Set
Pgpool port    : 9999
Watchdog port  : 9000
Node priority  : 1
Status         : 7
Status Name    : STANDBY

Node Name      : Linux_2ae9f3fd-31fc-4921-aeb7-8e320cf347c4_9999
Host Name      : 10.11.61.51
Delegate IP    : Not_Set
Pgpool port    : 9999
Watchdog port  : 9000
Node priority  : 1
Status         : 7
Status Name    : STANDBY

Node Name      : Linux_270f905f-37ef-46a2-9f7b-9b92b96a6ea9_9999
Host Name      : 10.11.61.50
Delegate IP    : Not_Set
Pgpool port    : 9999
Watchdog port  : 9000
Node priority  : 1
Status         : 4
Status Name    : MASTER

Please let us know how to rectify this issue.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20170112/7c25640e/attachment.html>