[pgpool-general: 8511] PgPool showing node as down but it's up

shacky shacky83 at gmail.com
Thu Dec 8 01:51:59 JST 2022


Hi,
I have a 3-nodes PgPool 4.2.10 cluster connected to a 3-nodes PostgreSQL
12.13 cluster.
I am in streaming replication mode, the streaming replication is actually
working well without any errors.

Suddenly PgPool began to recognise the node_id 2 as down, but it is up and
running and reachable from the PgPool node itself:
=================================================================
bash-4.4$ psql -h 127.0.0.1 -p 5432 -U pgpool -c "show pool_nodes;" postgres
 node_id |       hostname        | port | status | lb_weight |  role   |
select_cnt | load_balance_node | replication_delay | replication_state |
repl
ication_sync_state | last_status_change
---------+-----------------------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+-----
-------------------+---------------------
 0       | postgres1.my.domain.com | 5432 | up     | 0.333333  | primary |
2801705    | true              | 0                 |                   |

                   | 2022-12-06 20:28:45
 1       | postgres2.my.domain.com | 5432 | up     | 0.333333  | standby |
0          | false             | 0                 |                   |

                   | 2022-12-06 20:28:45
 2       | postgres3.my.domain.com | 5432 | down   | 0.333333  | standby |
0          | false             | 0                 |                   |

                   | 2022-12-06 20:26:32
(3 rows)
=================================================================

The PostgreSQL node is up and running and reachable from the PgPool node
itself:
=================================================================
bash-4.4$ psql -hpostgres3.my.domain.com -Upgpool -W -dpostgres -c'SELECT
pg_is_in_recovery();'
Password for user pgpool:
 pg_is_in_recovery
-------------------
 t
(1 row)
=================================================================

I tried to attach it using pcp_attach_node, but nothing happens (no errors
and no logs into the PgPool log file even if it is configured as debug1):
=================================================================
bash-4.4$ pcp_attach_node 2 -h localhost -p 9898 -w -v
pcp_attach_node -- Command Successful
=================================================================

Could you help me to understand what's wrong, please?

Thank you very much!
Bye
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.pgpool.net/pipermail/pgpool-general/attachments/20221207/39593c6c/attachment.htm>


More information about the pgpool-general mailing list