<div dir="ltr"><div>Pgpool-II sends (<font face="monospace, monospace">SELECT pg_last_xlog_replay_location()</font>) query to standby backend nodes for calculating the replication time lag.</div><div>And the error "<font face="monospace, monospace">Query to node (1) returned no data</font>" indicates that the backend node 1 is not returning any results for the query.</div><div><br></div><div><span style="font-size:12.8px">Usually this happens when Pgpool-II thinks that the node is a standby while actually it is not. So you should check the backend node 1 if it is in the standby mode and </span><span style="font-size:12.8px">it is not <span id="gmail-f5038aa9-f6de-4672-9c97-6c7820dcf83d" class="gmail-GINGER_SOFTWARE_mark"><span id="gmail-ccd20777-745e-48c7-a89a-30033da1596e" class="gmail-GINGER_SOFTWARE_mark">accidentally</span></span> promoted</span><span style="font-size:12.8px"> </span><span class="gmail-il" style="font-size:12.8px">to</span><span style="font-size:12.8px"> primary.</span></div><div><span style="font-size:12.8px"><br></span></div><div><span style="font-size:12.8px">Thanks</span></div><div><span style="font-size:12.8px">Regards</span></div><div><span style="font-size:12.8px">Muhammad Usama</span></div></div><div class="gmail_extra"><br><div class="gmail_quote">On Thu, Jan 12, 2017 at 12:20 PM, Bhattacharyya, Subhro <span dir="ltr"><<a href="mailto:s.bhattacharyya@sap.com" target="_blank">s.bhattacharyya@sap.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div lang="EN-US" link="#0563C1" vlink="#954F72">
<div class="m_7594661479170046675WordSection1">
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Hi,<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">We have a 2 node postgresql cluster along with 3 pgpool-II nodes.<u></u><u></u></p>
<p class="MsoNormal">The version of pgpool-II that we are using is 3.5.2<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">We keep getting the following logs infinitely in the logs of all the pgpool-II nodes<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><b>2017-01-12 07:09:55: pid 2534: ERROR: Failed to check replication time lag<u></u><u></u></b></p>
<p class="MsoNormal"><b>2017-01-12 07:09:55: pid 2534: DETAIL: Query to node (1) returned no data<u></u><u></u></b></p>
<p class="MsoNormal"><b>2017-01-12 07:09:55: pid 2534: CONTEXT: while checking replication time lag<u></u><u></u></b></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Following is the watchdog cluster/node information:<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Watchdog Cluster Information<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Total Nodes : 3<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Remote Nodes : 2<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Quorum state : QUORUM EXIST<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Alive Remote Nodes : 2<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">VIP up on local node : NO<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Master Node Name : Linux_270f905f-37ef-46a2-9f7b-<wbr>9b92b96a6ea9_9999<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Master Host Name : 10.11.61.50<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Watchdog Node Information<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Node Name : Linux_26acb17c-dadc-49ca-bb14-<wbr>44820ab6a78a_9999<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Host Name : 10.11.61.52<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Delegate IP : Not_Set<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Pgpool port : 9999<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Watchdog port : 9000<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Node priority : 1<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Status : 7<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Status Name : STANDBY<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Node Name : Linux_2ae9f3fd-31fc-4921-aeb7-<wbr>8e320cf347c4_9999<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Host Name : 10.11.61.51<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Delegate IP : Not_Set<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Pgpool port : 9999<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Watchdog port : 9000<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Node priority : 1<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Status : 7<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Status Name : STANDBY<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Node Name : Linux_270f905f-37ef-46a2-9f7b-<wbr>9b92b96a6ea9_9999<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Host Name : 10.11.61.50<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Delegate IP : Not_Set<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Pgpool port : 9999<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Watchdog port : 9000<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Node priority : 1<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Status : 4<u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Status Name : MASTER <u></u><u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif"><u></u> <u></u></span></p>
<p class="MsoNormal" style="text-autospace:none"><span style="font-size:9.5pt;font-family:"Segoe UI",sans-serif">Please let us know how to rectify this issue.</span><u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
</div>
<br>______________________________<wbr>_________________<br>
pgpool-general mailing list<br>
<a href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br>
<a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="noreferrer" target="_blank">http://www.pgpool.net/mailman/<wbr>listinfo/pgpool-general</a><br>
<br></blockquote></div><br></div>