View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000801 | Pgpool-II | Bug | public | 2023-06-15 05:56 | 2023-06-19 13:51 |
| Reporter | anukrish | Assigned To | pengbo | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | feedback | Resolution | open | ||
| Product Version | 4.2.6 | ||||
| Summary | 0000801: show pool_nodes role column not getting updated on postgres faiover | ||||
| Description | show pool_nodes role not getting updated aftr postgrs failover (lpp01rvcsqt502:postgres) $ psql -h 10.70.20.186 -p 9999 -U postgres -c "show pool_nodes" node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay | replication_state | replication_sync_state | last_status_change ---------+-------------------------+------+--------+-----------+---------+------------+-------------------+-------------------+------------------- +------------------------+--------------------- 0 | lpp01rvcsqt502.lp.local | 5432 | up | 0.500000 | primary | 0 | false | 0 | | | 2023-06-14 13:08:03 1 | lpp02rvcsqt502.lp.local | 5432 | up | 0.500000 | standby | 0 | true | 0 | | | 2023-06-14 13:08:03 (lpp01rvcsqt502:postgres) $ psql -x -c "select pg_is_in_recovery();" -[ RECORD 1 ]-----+-- pg_is_in_recovery | t the database is in standby mode but show pole node not reflecting the same. | ||||
| Tags | No tags attached. | ||||
|
|
(lpp01rvcsqt502:postgres) $ pcp_node_info --verbose -h lpp01rvcsqt502.lp.local 0 Password: Hostname : lpp01rvcsqt502.lp.local Port : 5432 Status : 2 Weight : 0.500000 Status Name : up Role : primary Replication Delay : 0 Replication State : Replication Sync State : Last Status Change : 2023-06-14 13:08:03 |
|
|
> show pool_nodes role not getting updated aftr postgrs failover How was the failover performed? Did pgpool perform postgres failover? |
|
|
manual failover not through pgpool |
|
|
Basically pgpool should manage the state of the PostgreSQL cluster and trigger failover. Manual failover of PostgreSQL is not recommended. To reset the status you need to restart pgpool. If you want to perform failover manually, you need to enable health check to allow pgpool to detect the node failure. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2023-06-15 05:56 | anukrish | New Issue | |
| 2023-06-15 05:58 | anukrish | Note Added: 0004395 | |
| 2023-06-15 08:50 | pengbo | Note Added: 0004396 | |
| 2023-06-15 08:50 | pengbo | Status | new => feedback |
| 2023-06-15 08:51 | pengbo | Note Edited: 0004396 | |
| 2023-06-15 08:51 | pengbo | Note Edited: 0004396 | |
| 2023-06-17 05:19 | anukrish | Note Added: 0004397 | |
| 2023-06-17 05:19 | anukrish | Status | feedback => new |
| 2023-06-19 13:50 | pengbo | Note Added: 0004399 | |
| 2023-06-19 13:51 | pengbo | Assigned To | => pengbo |
| 2023-06-19 13:51 | pengbo | Status | new => feedback |
