View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000320 | Pgpool-II | Bug | public | 2017-07-16 12:06 | 2017-08-30 02:30 |
| Reporter | SampsonCrowley | Assigned To | t-ishii | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Platform | x86_64 | OS | Linux (Arch) | OS Version | 4.11.9-1 |
| Product Version | 3.6.4 | ||||
| Summary | 0000320: Index Error Violations are never returned to the application | ||||
| Description | If I executed a prepared statement from node-pg, PGPool never returns the error when there is a unique index violation | ||||
| Steps To Reproduce | Install pgpool 3.6.4 with streaming replication and Load balancing | ||||
| Additional Information | There is something PGpool is not returning from postgres queries. The EXACT same code used directly with postgres works perfectly. it is only when PGPool is involved that transaction errors hang indefinitely | ||||
| Tags | node, pgpool in load balancing mode | ||||
|
|
Maybe this is caused by the same bug (317). If so, attached patch should fix the problem. Please try. |
|
|
How do I apply this patch? |
|
|
You can use the patch command to apply the patch to the source tree. |
|
|
there is no pool_query_context.c on my pgpool server, where specifically am I supposed to apply this patch |
|
|
do i need to remove and recompile the whole thing? |
|
|
Yep, that is what had to be done.. I will update you if it worked |
|
|
It did not work. still same issue. pgpool reports "unable to read data from frontend". then "EOF from frontend" |
|
|
Can we share the pgpool log with debug option on (-d enabled)? |
|
|
yeah, i'll get that to you on monday |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-07-16 12:06 | SampsonCrowley | New Issue | |
| 2017-07-16 12:06 | SampsonCrowley | Tag Attached: pgpool in load balancing mode | |
| 2017-07-16 12:06 | SampsonCrowley | Tag Attached: node | |
| 2017-07-19 14:12 | t-ishii | File Added: pgpool-hung.diff | |
| 2017-07-19 14:12 | t-ishii | Note Added: 0001584 | |
| 2017-07-19 14:12 | t-ishii | Assigned To | => t-ishii |
| 2017-07-19 14:12 | t-ishii | Status | new => feedback |
| 2017-07-19 14:35 | SampsonCrowley | Note Added: 0001588 | |
| 2017-07-19 14:35 | SampsonCrowley | Status | feedback => assigned |
| 2017-07-19 14:41 | t-ishii | Note Added: 0001589 | |
| 2017-07-19 16:47 | t-ishii | Status | assigned => feedback |
| 2017-07-22 02:21 | SampsonCrowley | Note Added: 0001599 | |
| 2017-07-22 02:21 | SampsonCrowley | Status | feedback => assigned |
| 2017-07-22 02:26 | SampsonCrowley | Note Added: 0001600 | |
| 2017-07-22 03:04 | SampsonCrowley | Note Added: 0001601 | |
| 2017-07-24 13:45 | t-ishii | Status | assigned => feedback |
| 2017-07-26 04:58 | SampsonCrowley | Note Added: 0001604 | |
| 2017-07-26 04:58 | SampsonCrowley | Status | feedback => assigned |
| 2017-07-27 14:32 | t-ishii | Note Added: 0001609 | |
| 2017-07-27 14:33 | t-ishii | Status | assigned => feedback |
| 2017-07-29 03:44 | SampsonCrowley | Note Added: 0001610 | |
| 2017-07-29 03:44 | SampsonCrowley | Status | feedback => assigned |
| 2017-08-03 14:46 | t-ishii | Status | assigned => feedback |
| 2017-08-29 09:28 | pengbo | Status | feedback => closed |
