[pgpool-general: 6760] Re: Watchdog does not get consensus for failover

[shacky]

Hi Tatsuo,

- "show pool_nodes" command out put
>

postgres at proxy1:~$ psql -h 127.0.0.1 -p 5432 -U repmgr -c "show pool_nodes;"
DEBUG:  SimpleQuery
DETAIL:  nodes reporting
 node_id | hostname  | port | status | lb_weight |  role   | select_cnt |
load_balance_node | replication_delay | last_status_change
---------+-----------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------
 0       | postgres1 | 5432 | up     | 0.333333  | primary | 0          |
true              | 0                 | 2019-10-28 18:47:14
 1       | postgres2 | 5432 | up     | 0.333333  | standby | 0          |
false             | 0                 | 2019-10-28 18:47:14
 2       | postgres3 | 5432 | up     | 0.333333  | standby | 0          |
false             | 0                 | 2019-10-28 18:47:14
(3 rows)

postgres at proxy2:~$ psql -h 127.0.0.1 -p 5432 -U repmgr -c "show pool_nodes;"
DEBUG:  SimpleQuery
DETAIL:  nodes reporting
 node_id | hostname  | port | status | lb_weight |  role   | select_cnt |
load_balance_node | replication_delay | last_status_change
---------+-----------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------
 0       | postgres1 | 5432 | up     | 0.333333  | primary | 0          |
true              | 0                 | 2019-10-28 18:47:09
 1       | postgres2 | 5432 | up     | 0.333333  | standby | 0          |
false             | 0                 | 2019-10-28 18:47:09
 2       | postgres3 | 5432 | up     | 0.333333  | standby | 0          |
false             | 0                 | 2019-10-28 18:47:09
(3 rows)

postgres at proxy3:~$ psql -h 127.0.0.1 -p 5432 -U repmgr -c "show pool_nodes;"
DEBUG:  SimpleQuery
DETAIL:  nodes reporting
 node_id | hostname  | port | status | lb_weight |  role   | select_cnt |
load_balance_node | replication_delay | last_status_change
---------+-----------+------+--------+-----------+---------+------------+-------------------+-------------------+---------------------
 0       | postgres1 | 5432 | up     | 0.333333  | primary | 1          |
true              | 0                 | 2019-10-28 17:34:05
 1       | postgres2 | 5432 | up     | 0.333333  | standby | 11         |
false             | 0                 | 2019-10-28 18:23:39
 2       | postgres3 | 5432 | up     | 0.333333  | standby | 0          |
false             | 0                 | 2019-10-28 18:47:04
(3 rows)


> - debug log (especially for health check)
>

You can download both proxy1 and proxy2 debug logs from
https://we.tl/t-Bj89RKZBFC.

Thanks!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20191029/f7e52094/attachment.html>