View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000351 | Pgpool-II | Bug | public | 2017-10-09 19:08 | 2017-12-08 11:35 |
| Reporter | tstm | Assigned To | t-ishii | ||
| Priority | normal | Severity | crash | Reproducibility | sometimes |
| Status | closed | Resolution | open | ||
| Product Version | 3.6.6 | ||||
| Summary | 0000351: pgpool crashes after a network outage to the master | ||||
| Description | We had a network outage on our internal VPN for a few minutes and we got the following log entries: 2017-10-09 10:03:41: pid 1388: LOG: fork a new child process with pid: 5175 2017-10-09 10:03:47: pid 5175: LOG: new connection received 2017-10-09 10:03:47: pid 5175: DETAIL: connecting host=localhost port=51268 2017-10-09 10:03:57: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:03:57: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:04:07: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:04:07: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:04:17: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:04:17: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:04:27: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:04:27: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:04:37: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:04:37: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:04:47: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:04:47: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:04:57: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:04:57: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:05:07: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:05:07: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:05:17: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:05:17: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:05:27: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:05:27: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:05:37: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:05:37: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:05:47: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:05:47: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:05:57: pid 5175: LOG: trying connecting to PostgreSQL server on "10.0.0.2:5432" by INET socket 2017-10-09 10:05:57: pid 5175: DETAIL: timed out. retrying... 2017-10-09 10:05:57: pid 5175: LOG: failed to connect to PostgreSQL server on "10.0.0.2:5432", getsockopt() detected error "Connection timed out" 2017-10-09 10:05:57: pid 5175: LOG: failed to create a backend 0 connection 2017-10-09 10:05:57: pid 5175: DETAIL: skip this backend because because fail_over_on_backend_error is off and we are in streaming replication mode and node is standby node 2017-10-09 10:05:57: pid 1388: WARNING: child process with pid: 5175 was terminated by segmentation fault And dmesg has this: pgpool[5175]: segfault at 0 ip 000000000041d2b3 sp 00007ffde942c3c0 error 4 in pgpool[400000+146000] | ||||
| Steps To Reproduce | Disconnect network connectivity to the postgresql master in streaming replication mode with hot stanby, make a query, wait for the connection to time out a few times, then pgpool promptly crashes. | ||||
| Tags | master slave, replication, streaming replication | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-10-09 19:08 | tstm | New Issue | |
| 2017-10-09 19:08 | tstm | Tag Attached: master slave | |
| 2017-10-09 19:08 | tstm | Tag Attached: replication | |
| 2017-10-09 19:08 | tstm | Tag Attached: streaming replication | |
| 2017-10-10 09:49 | t-ishii | Note Added: 0001747 | |
| 2017-10-10 09:49 | t-ishii | Assigned To | => t-ishii |
| 2017-10-10 09:49 | t-ishii | Status | new => feedback |
| 2017-12-08 11:34 | t-ishii | Note Added: 0001851 | |
| 2017-12-08 11:35 | t-ishii | Status | feedback => closed |
