<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10px"><div><span>Hi,</span></div><div style="color: rgb(0, 0, 0); font-size: 10px; font-family: arial, helvetica, sans-serif; font-style: normal; background-color: transparent;"><span>These are run the the same servers and we checked the _otherhostname_ it looks fine only.</span></div><div><br></div>  <div style="font-family: arial, helvetica, sans-serif; font-size: 10px;"> <div style="font-family: HelveticaNeue, 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px;"> <div dir="ltr"> <hr size="1">  <font size="2" face="Arial"> <b><span style="font-weight:bold;">From:</span></b> Yugo Nagata &lt;nagata@sraoss.co.jp&gt;<br> <b><span style="font-weight: bold;">To:</span></b> Karthick Thanigaimani &lt;kargold100@yahoo.com&gt; <br><b><span style="font-weight: bold;">Cc:</span></b> "pgpool-general@pgpool.net"
 &lt;pgpool-general@pgpool.net&gt; <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, 14 November 2014 7:08 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [pgpool-general: 3284] Strange behaviour of pcp_watchdog_info<br> </font> </div> <div class="y_msg_container"><br>Hi,<br clear="none"><br clear="none">On Fri, 14 Nov 2014 08:40:20 +0800<br clear="none">Karthick Thanigaimani &lt;<a shape="rect" ymailto="mailto:kargold100@yahoo.com" href="mailto:kargold100@yahoo.com">kargold100@yahoo.com</a>&gt; wrote:<br clear="none"><br clear="none">&gt; Hi,<br clear="none">&gt; <br clear="none">&gt; We were facing a Backenderror when we try to check the status of the node using the pcp_watchdog_info command.<br clear="none">&gt; we have postgres 9.3.4 and pgpool 3.3.3 .<br clear="none">&gt; <br clear="none">&gt; $ psql -p9999 -h node1 -c "show pool_nodes"<br clear="none">&gt; Password:<br clear="none">&gt;&nbsp; node_id |&nbsp;
 hostname&nbsp; | port | status | lb_weight |&nbsp; role<br clear="none">&gt; ---------+------------+------+--------+-----------+---------<br clear="none">&gt;&nbsp; 0&nbsp; &nbsp; &nbsp;  | node1 | 5432 | 2&nbsp; &nbsp; &nbsp; | 0.500000&nbsp; | primary<br clear="none">&gt;&nbsp; 1&nbsp; &nbsp; &nbsp;  | node2 | 5432 | 2&nbsp; &nbsp; &nbsp; | 0.500000&nbsp; | standby<br clear="none">&gt; (2 rows)<br clear="none">&gt; <br clear="none">&gt; $ pcp_watchdog_info 10 node1 9898 postgres test 1<br clear="none">&gt; BackendError<br clear="none">&gt; <br clear="none">&gt; $ pcp_watchdog_info 10 node1 9898 postgres test 1<br clear="none">&gt; node2 9999 9000 2<br clear="none"><br clear="none">Are these tow results run in deffernt servers? If so, please<br clear="none">check other_pgpool_hostnameX of pgpool.conf in the both servers.<br clear="none">One of them may not have specification of ohter_pgopol_hostname2.<div class="qtdSeparateBR"><br><br></div><div
 class="yqt7960589302" id="yqtfd81962"><br clear="none"><br clear="none">&gt; <br clear="none">&gt; the nodes are in sync and the DB / pgpool is online as well.<br clear="none">&gt; <br clear="none">&gt; can you please advise if this is a bug or what could be the reason for this.<br clear="none">&gt; <br clear="none">&gt; regards<br clear="none">&gt; Karthick</div><br clear="none">&gt; <br clear="none"><br clear="none"><br clear="none">-- <br clear="none">Yugo Nagata &lt;<a shape="rect" ymailto="mailto:nagata@sraoss.co.jp" href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a><div class="yqt7960589302" id="yqtfd58331">&gt;<br clear="none"></div><br><br></div> </div> </div>  </div></body></html>