<div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hi Pierre, thanks, I noticed the /tmp/pgpool_status file had a status of "up" for node 1 and "down" for node 2 (even though node 2 was actually up). So I tried stopping pgpool, delete the /tmp/pgpool_status file and startup pgpool, now the /tmp/pgpool_status has an "up" status for both nodes.</div><div dir="ltr"><br></div><div>But now pgpool log shows following errors repetitively:</div><div><br></div><div><div>Nov 26 10:41:06 hoopa-uat-pgpool-1 pgpool[6491]: [39-1] 2018-11-26 10:41:06: pid 6491: db [No Connection]: user [No Connection]: client_app [No Connection]ERROR: invalid LSN format</div><div>Nov 26 10:41:06 hoopa-uat-pgpool-1 pgpool[6491]: [39-2] 2018-11-26 10:41:06: pid 6491: db [No Connection]: user [No Connection]: client_app [No Connection]DETAIL: wrong log location format: 110001</div><div>Nov 26 10:41:06 hoopa-uat-pgpool-1 pgpool[6491]: [39-3] 2018-11-26 10:41:06: pid 6491: db [No Connection]: user [No Connection]: client_app [No Connection]CONTEXT: while checking replication time lag</div><div>Nov 26 10:41:06 hoopa-uat-pgpool-1 pgpool[6491]: [40-1] 2018-11-26 10:41:06: pid 6491: db [No Connection]: user [No Connection]: client_app [No Connection]LOG: get_query_result: no rows returned</div><div>Nov 26 10:41:06 hoopa-uat-pgpool-1 pgpool[6491]: [40-2] 2018-11-26 10:41:06: pid 6491: db [No Connection]: user [No Connection]: client_app [No Connection]DETAIL: node id (0)</div><div>Nov 26 10:41:06 hoopa-uat-pgpool-1 pgpool[6491]: [40-3] 2018-11-26 10:41:06: pid 6491: db [No Connection]: user [No Connection]: client_app [No Connection]CONTEXT: while checking replication time lag</div></div><div><br></div><div>And in the Postgres log I got this error:</div><div><br></div><div><div>2018-11-26 10:45:27.925 +08 [PID=1701 application="[unknown]" user_name=pgpool database=postgres host(port)=10.31.1.238(45800)] ERROR: function pg_current_xlog_location() does not exist at character 8</div><div>2018-11-26 10:45:27.925 +08 [PID=1701 application="[unknown]" user_name=pgpool database=postgres host(port)=10.31.1.238(45800)] HINT: No function matches the given name and argument types. You might need to add explicit type casts.</div><div>2018-11-26 10:45:27.925 +08 [PID=1701 application="[unknown]" user_name=pgpool database=postgres host(port)=10.31.1.238(45800)] STATEMENT: SELECT pg_current_xlog_location()</div></div><div><br></div><div>Shouldn't it be calling pg_current_wal_lsn() instead? My PostgreSQL version is 11.1</div><div><br></div><div>Thank you!</div><div><br></div><div>Regards,</div><div>Mike Yeap</div></div></div></div></div></div></div><br><div class="gmail_quote"><div dir="ltr">On Fri, Nov 23, 2018 at 6:21 PM Pierre Timmermans <<a href="mailto:ptim007@yahoo.com">ptim007@yahoo.com</a>> wrote:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div class="m_2214606033319453450ydpf6e2a5deyahoo-style-wrap" style="font-family:Helvetica Neue,Helvetica,Arial,sans-serif;font-size:16px"><div><div>You have to look in the pgpool log file why pgpool decided to detach the node, it typically happens when the healtch check fails (db was stopped, no network connectivity, etc.)<br></div><div><br></div><div>To put it back up you must use the pcp_attach_node command, it will be something like</div><div><br></div><div>pcp_attach_node -h localhost -p 9898 -w 1<br></div><div><br></div><div>note: -w is to disable password prompting, it requires to have a .pcppass file in your home directory with the right permissions.<br></div><div><br></div><div class="m_2214606033319453450ydpf6e2a5designature">Pierre</div></div>
<div><br></div><div><br></div>
</div><div id="m_2214606033319453450ydp78145bd5yahoo_quoted_3751811828" class="m_2214606033319453450ydp78145bd5yahoo_quoted">
<div style="font-family:'Helvetica Neue',Helvetica,Arial,sans-serif;font-size:13px;color:#26282a">
<div>
On Friday, November 23, 2018, 11:14:03 AM GMT+1, Mike Yeap <<a href="mailto:wkk1020@gmail.com" target="_blank">wkk1020@gmail.com</a>> wrote:
</div>
<div><br></div>
<div><br></div>
<div><div id="m_2214606033319453450ydp78145bd5yiv4800783543"><div dir="ltr"><div dir="ltr"><div dir="ltr">Hi, I'm new to Pgpool-II and trying a setup based on a two nodes streaming replication configuration. But the "show pool_nodes" command shows a "down" status for the standby node:</div><div dir="ltr"><br></div><div dir="ltr"><div dir="ltr"><font face="monospace, monospace">[postgres@hoopa-uat-1 log]$ psql -h hoopa-uat-pgpool-1 -p 9999 -U postgres -c "show pool_nodes" postgres</font></div><div dir="ltr"><br></div><div dir="ltr"><font face="monospace, monospace"> node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | last_status_change</font></div><div dir="ltr"><font face="monospace, monospace">---------+-------------+------+--------+-----------+---------+------------+-------------------+-------------------+--------------------</font></div><div dir="ltr"><font face="monospace, monospace"> 0 | hoopa-uat-1 | 5432 | up | 0.500000 | primary | 0 | true | 0 | 2018-11-23 17:57:16</font></div><div dir="ltr"><font face="monospace, monospace"> 1 | hoopa-uat-2 | 5432 | down | 0.500000 | standby | 0 | false | 0 | 2018-11-23 17:57:16</font></div><div><br></div><div>Actually the standby node is up, and I can run queries on it.</div><div><br></div><div>Can someone please enlighten me?</div><div><br></div><div>pgpool-II version 4.0.1<br></div><div>PostgreSQL version 11.1</div><div><br></div><div>Thank you.</div><div>Regards,</div><div>Mike Yeap</div></div></div></div></div>_______________________________________________<br>pgpool-general mailing list<br><a href="mailto:pgpool-general@pgpool.net" rel="nofollow" target="_blank">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" rel="nofollow" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br></div>
</div>
</div></div></blockquote></div>