<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 <nagata@sraoss.co.jp><br> <b><span style="font-weight: bold;">To:</span></b> Karthick Thanigaimani <kargold100@yahoo.com> <br><b><span style="font-weight: bold;">Cc:</span></b> "pgpool-general@pgpool.net"
<pgpool-general@pgpool.net> <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 <<a shape="rect" ymailto="mailto:kargold100@yahoo.com" href="mailto:kargold100@yahoo.com">kargold100@yahoo.com</a>> wrote:<br clear="none"><br clear="none">> Hi,<br clear="none">> <br clear="none">> We were facing a Backenderror when we try to check the status of the node using the pcp_watchdog_info command.<br clear="none">> we have postgres 9.3.4 and pgpool 3.3.3 .<br clear="none">> <br clear="none">> $ psql -p9999 -h node1 -c "show pool_nodes"<br clear="none">> Password:<br clear="none">> node_id |
hostname | port | status | lb_weight | role<br clear="none">> ---------+------------+------+--------+-----------+---------<br clear="none">> 0 | node1 | 5432 | 2 | 0.500000 | primary<br clear="none">> 1 | node2 | 5432 | 2 | 0.500000 | standby<br clear="none">> (2 rows)<br clear="none">> <br clear="none">> $ pcp_watchdog_info 10 node1 9898 postgres test 1<br clear="none">> BackendError<br clear="none">> <br clear="none">> $ pcp_watchdog_info 10 node1 9898 postgres test 1<br clear="none">> 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">> <br clear="none">> the nodes are in sync and the DB / pgpool is online as well.<br clear="none">> <br clear="none">> can you please advise if this is a bug or what could be the reason for this.<br clear="none">> <br clear="none">> regards<br clear="none">> Karthick</div><br clear="none">> <br clear="none"><br clear="none"><br clear="none">-- <br clear="none">Yugo Nagata <<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">><br clear="none"></div><br><br></div> </div> </div> </div></body></html>