View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000334 | Pgpool-II | Bug | public | 2017-08-28 11:59 | 2017-12-08 11:33 |
| Reporter | kong003 | Assigned To | t-ishii | ||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | closed | Resolution | open | ||
| OS | centos | OS Version | rel6 | ||
| Product Version | 3.6.5 | ||||
| Summary | 0000334: after upgrate postgresql to 9.6 , pgpool detect "all backends are down " aftre run a few hour or one day | ||||
| Description | but pgpool can run well if i remove "idle_in_transaction_session_timeout = 60000 " feature in postgresql.conf . | ||||
| Tags | No tags attached. | ||||
|
|
Try: fail_over_on_backend_error = off This should prevent unwanted failover. |
|
|
ok, i will try it later . now i set connection_life_time、child_life_time and client_idle_limit less than idle_in_transaction_session_timeout ,it seems ok , i will feedback it later |
|
|
test ok ，(set connection_life_time、child_life_time and client_idle_limit less than idle_in_transaction_session_timeout ) have run more than one day, thx! |
|
|
Thank you for the information! Maybe we should add this to our manual? |
|
|
i think so . |
|
|
I have registered to FAQ. https://pgpool.net/mediawiki/index.php/FAQ#After_enabling_idle_in_transaction_session_timeout.2C_Pgpool-II_sets_the_DB_node_status_to_all_down Please take a look at it and if it's, ok please close this issue. |
|
|
No response since 2017/9/4. Issue closed. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-08-28 11:59 | kong003 | New Issue | |
| 2017-08-28 14:06 | t-ishii | Assigned To | => t-ishii |
| 2017-08-28 14:06 | t-ishii | Status | new => assigned |
| 2017-08-28 14:08 | t-ishii | Note Added: 0001684 | |
| 2017-08-28 14:09 | t-ishii | Status | assigned => feedback |
| 2017-08-28 18:12 | kong003 | Note Added: 0001685 | |
| 2017-08-28 18:12 | kong003 | Status | feedback => assigned |
| 2017-08-29 07:39 | t-ishii | Status | assigned => feedback |
| 2017-08-29 17:23 | kong003 | Note Added: 0001689 | |
| 2017-08-29 17:23 | kong003 | Status | feedback => assigned |
| 2017-08-29 17:31 | t-ishii | Note Added: 0001690 | |
| 2017-08-30 00:22 | kong003 | Note Added: 0001692 | |
| 2017-09-04 10:45 | t-ishii | Note Added: 0001699 | |
| 2017-09-04 10:46 | t-ishii | Status | assigned => feedback |
| 2017-09-04 13:00 | t-ishii | Note Edited: 0001699 | |
| 2017-12-08 11:33 | t-ishii | Note Added: 0001849 | |
| 2017-12-08 11:33 | t-ishii | Status | feedback => closed |
