<html><body><div style="color:#000; background-color:#fff; font-family:arial, helvetica, sans-serif;font-size:10px"><div><span>yes thats correct.</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> Monday, 17 November 2014 6:35 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 19:35:53 +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">> These are run the the same servers and we checked the _otherhostname_ it looks fine only.<br clear="none"><br clear="none">You mean, the same two pcp_command were run at a server, but the results<br clear="none">were different; the first one returned BackendError and the second succeeded?<br clear="none"><br clear="none"><br clear="none">On Fri, 14 Nov 2014 19:50:51 +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">> These are the files and values. Let me know if aything elseto be added?<br clear="none">> <br
clear="none">> more pgpool.conf | grep pgpool_hostname<br clear="none">> other_pgpool_hostname0 = '10.0.90.11'<br clear="none">> more pgpool.conf_10.0.90.11 | grep pgpool_hostname<br clear="none">> other_pgpool_hostname0 = '10.0.90.12'<br clear="none">> more pgpool.conf_10.0.90.12 | grep pgpool_hostname<br clear="none">> other_pgpool_hostname0 = '10.0.90.11'<br clear="none"><br clear="none">I assume there are two machine (IP: 10.0.90.{11,12}) each of which has<br clear="none">pgpool-II installed, and the conf file is pgpool.conf_${IP}. <br clear="none"><br clear="none">It seems no problem. If you want to know watchdog status of other pgpool<br clear="none">with this pgpool.conf, the command to be run is; <br clear="none"><br clear="none"> $ pcp_watchdog_info 0 node1 9898 postgres test 0<br clear="none"><br clear="none">since the last argument is the postfix number of "ohter_pgpool_hostnameX".<br clear="none"><br clear="none">So, when
the last argument is specified to 2 this returns BackendError<br clear="none">since other_pgpool_hostname2 isn't specified.<br clear="none"><br clear="none">> <br clear="none">> <br clear="none">> <br clear="none">> ________________________________<br clear="none">> From: Yugo Nagata <<a shape="rect" ymailto="mailto:nagata@sraoss.co.jp" href="mailto:nagata@sraoss.co.jp">nagata@sraoss.co.jp</a>><br clear="none">> To: Karthick Thanigaimani <<a shape="rect" ymailto="mailto:kargold100@yahoo.com" href="mailto:kargold100@yahoo.com">kargold100@yahoo.com</a>> <br clear="none">> Cc: "<a shape="rect" ymailto="mailto:pgpool-general@pgpool.net" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>" <<a shape="rect" ymailto="mailto:pgpool-general@pgpool.net" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a>> <br clear="none">> Sent: Friday, 14 November 2014 7:08 PM<br
clear="none">> Subject: Re: [pgpool-general: 3284] Strange behaviour of pcp_watchdog_info<br clear="none">> <br clear="none">> <br clear="none">> 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.<br clear="none">> <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 class="qtdSeparateBR"><br><br></div><div class="yqt1671570491" id="yqtfd12579"><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><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>><br clear="none"></div><br><br></div> </div> </div> </div></body></html>