View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000609 | Pgpool-II | Bug | public | 2020-04-30 20:45 | 2020-05-01 20:19 |
| Reporter | Seema | Assigned To | t-ishii | ||
| Priority | urgent | Severity | major | Reproducibility | always |
| Status | feedback | Resolution | open | ||
| Product Version | 3.5.3 | ||||
| Summary | 0000609: server closed the connection unexpectedly | ||||
| Description | When Application tries to insert data into a new DB created (Schema DB), the operation fails with error: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. The connection to the server was lost. Attempting reset: Succeeded. | ||||
| Steps To Reproduce | We have created a DN with multiple Schemas ; around 80 schemas inside a single DB. Insert operation on any schema fails with the above mentioned error. | ||||
| Tags | No tags attached. | ||||
|
|
Can you share Pgpool-II log and pgpool.conf? |
|
|
Hi, Conf file and log files are shared |
|
|
May 1 11:06:12 apgp1 pgpool[6445]: [12-1] 2020-05-01 11:06:12: pid 6445: LOG: child process with pid: 6555 exits with status 10 by signal 10 It seems your problem is related to this. Pgpool-II 3.5.3 is very old (released 4 years ago) and there have been multiple fixes related to SIGUSR1 (= signal 10) since then. I am not sure which of which is related to the problem but I suggest you to upgrade to the latest version of Pgpool-II 3.5 series. Currently it's 3.5.24. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2020-04-30 20:45 | Seema | New Issue | |
| 2020-05-01 17:29 | t-ishii | Assigned To | => t-ishii |
| 2020-05-01 17:29 | t-ishii | Status | new => assigned |
| 2020-05-01 17:33 | t-ishii | Note Added: 0003347 | |
| 2020-05-01 17:33 | t-ishii | Status | assigned => feedback |
| 2020-05-01 19:39 | Seema | File Added: pgpool.conf | |
| 2020-05-01 19:39 | Seema | File Added: pgpool_may1.log | |
| 2020-05-01 19:39 | Seema | Note Added: 0003348 | |
| 2020-05-01 19:39 | Seema | Status | feedback => assigned |
| 2020-05-01 20:18 | t-ishii | Note Added: 0003350 | |
| 2020-05-01 20:19 | t-ishii | Status | assigned => feedback |
