View Issue Details

Jump to NotesJump to History
IDProjectCategoryView StatusDate SubmittedLast Update
0000634Pgpool-IIBugpublic2020-08-18 16:522020-08-18 22:41
Reportermi Assigned Tot-ishii  
PrioritynormalSeverityminorReproducibilityalways
Status feedbackResolutionopen 
Product Version4.1.2 
Summary0000634: Until pgpool determines that the standby node is down, the query to the cluster fails
DescriptionThe problem is when I stop the service of standby node,

 I get the following error until,pgpool determines that the standby node is down.

 psql: FATAL: failed to create a backend connection
 DETAIL: executing failover on backend

After pgpool determined that standby node was down, I can execute any query succesfully.

---
 node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change
---------+--------------+------+--------+-----------+---------+------------+-------------------+-------------------+-------------------+------------------------+---------------------
 0 | 172.16.0.194 | 5432 | up | 0.500000 | primary | 0 | true | 0 | | | 2020-08-18 16:42:45
 1 | 172.16.0.196 | 5432 | up | 0.500000 | standby | 0 | false | 0 | streaming | async | 2020-08-18 16:42:45
(2 rows)
---

I hope you can help me.

Thank you.
TagsNo tags attached.

Activities

t-ishii

2020-08-18 22:40

developer   ~0003479

That's an expected behavior. While doing failover, the internal state of pgpool is not consistent. So pgpool refuses to connect from clients.

Issue History

Date Modified Username Field Change
2020-08-18 16:52 mi New Issue
2020-08-18 22:40 t-ishii Note Added: 0003479
2020-08-18 22:41 t-ishii Assigned To => t-ishii
2020-08-18 22:41 t-ishii Status new => feedback