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