View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000416 | pgpool-HA | Bug | public | 2018-07-25 02:11 | 2018-08-27 10:30 |
| Reporter | zachwalton | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | sometimes |
| Status | closed | Resolution | open | ||
| Platform | Linux | OS | CentOS | OS Version | 6.9 |
| Summary | 0000416: Detaching standby with load_balance_node=false causes application error: "ERROR: unable to read data from DB node 3" | ||||
| Description | Setup (note load_balance_node=false): [postgres@postgresdb001 ~]$ psql -p 9999 -h 127.0.0.1 -c 'show pool_nodes' node_id | hostname | port | status | lb_weight | role | select_cnt | load_balance_node | replication_delay ---------+-------------------------------------+------+--------+-----------+---------+------------+-------------------+------------------- 0 | postgresdb001 | 5432 | up | 0.166667 | primary | 1 | true | 0 1 | postgresdb002 | 5432 | up | 0.166667 | standby | 0 | false | 608 2 | postgresdb003 | 5432 | up | 0.166667 | standby | 0 | false | 608 3 | postgresdb004 | 5432 | up | 0.166667 | standby | 0 | false | 608 4 | postgresdb005 | 5432 | up | 0.166667 | standby | 0 | false | 608 5 | postgresdb006 | 5432 | up | 0.166667 | standby | 0 | false | 608 When detaching node 3: $ pcp_detach_node -w -n 3 pcp_detach_node -- Command Successful Our (Ruby on Rails) application throws an exception with the following error: ActiveRecord::StatementInvalid: PG::InternalError: ERROR: unable to read data from DB node 3 DETAIL: socket read failed with an error "Success" SSL SYSCALL error: EOF detected : SELECT ...(statement redacted)... I would maybe expect to see this behavior with load_balance_node=true, but we have load balancing off. Is it expected behavior that detaching a standby node with load_balance_node=false may cause application-level errors? | ||||
| Tags | No tags attached. | ||||
|
|
This is pgpool version: $ pgpool --version pgpool-II version 3.7.4 (amefuriboshi) |
|
|
Wrong project. Please report to "Pgpool-II" project. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2018-07-25 02:11 | zachwalton | New Issue | |
| 2018-07-25 02:13 | zachwalton | Note Added: 0002117 | |
| 2018-07-25 08:14 | administrator | Note Added: 0002118 | |
| 2018-08-27 10:30 | administrator | Status | new => closed |
