View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000248 | Pgpool-II | Bug | public | 2016-09-20 05:45 | 2016-09-28 09:34 |
| Reporter | supp_k | Assigned To | t-ishii | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | open | ||
| Platform | x86 64 | OS | CentOs | OS Version | 6.x & 7.x |
| Product Version | 3.5.3 | ||||
| Target Version | 3.5.5 | ||||
| Summary | 0000248: pgpool doesnt restores backend connections | ||||
| Description | The pcp_attach_node tool doesnt give any result if all backends were down. Detail: all backend nodes are down, pgpool requires at least one valid node. | ||||
| Steps To Reproduce | Environment: - 3 pgpool nodes (watchdog cluster) - 2 postgresql backends Actions: - stop 2 backends The pgpool states there are valid backends and it is ok. But restoring at least 1 PostgreSQL instance and attaching it to pgpool (master) with pcp_attach_node gives no result. Pgpool still states there no valid backends though pgpool_status reflects the attached backend is up. Only full restart of all pgpool nodes helps. | ||||
| Tags | No tags attached. | ||||
|
|
Good catch. Just we did not consider the case (all backends are down then 1 node is recovered by pcp_attach_node). Attached patch should fix the problem. Please try. |
|
|
|
|
|
Hi, quick test reveals the issue is fixed. When will it be applied to the major cosdebase - Say V3_5? |
|
|
It has been already applied to V3_5 and other branches. http://git.postgresql.org/gitweb?p=pgpool2.git;a=commitdiff;h=b306e04dd5c4a6c95cc5d97e0203e280d3983cb4 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-09-20 05:45 | supp_k | New Issue | |
| 2016-09-21 09:07 | t-ishii | Assigned To | => t-ishii |
| 2016-09-21 09:07 | t-ishii | Status | new => assigned |
| 2016-09-21 09:07 | t-ishii | Target Version | => 3.5.4 |
| 2016-09-21 09:18 | t-ishii | Note Added: 0001074 | |
| 2016-09-21 09:21 | t-ishii | File Added: all_backend_down.diff | |
| 2016-09-21 14:59 | t-ishii | Target Version | 3.5.4 => 3.5.5 |
| 2016-09-21 14:59 | t-ishii | Status | assigned => feedback |
| 2016-09-28 05:07 | supp_k | Note Added: 0001094 | |
| 2016-09-28 05:07 | supp_k | Status | feedback => assigned |
| 2016-09-28 07:37 | t-ishii | Note Edited: 0001074 | |
| 2016-09-28 07:39 | t-ishii | Note Added: 0001095 | |
| 2016-09-28 09:34 | t-ishii | Status | assigned => resolved |
