View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000354 | Pgpool-II | Bug | public | 2017-10-17 17:56 | 2017-10-24 21:59 |
| Reporter | ghuysmans | Assigned To | t-ishii | ||
| Priority | normal | Severity | block | Reproducibility | always |
| Status | closed | Resolution | open | ||
| Product Version | 3.6.3 | ||||
| Fixed in Version | 3.6.6 | ||||
| Summary | 0000354: No ReadyForQuery packet after an erroneous prepared statement | ||||
| Description | After you try preparing an erroneous query (because of a non-existing table, for example), pgpool doesn't send any 'Z' packet following the error packet. Therefore, the connection gets stuck. | ||||
| Steps To Reproduce | cc -lpq prep.c && ./a.out | ||||
| Tags | No tags attached. | ||||
|
|
|
|
|
Without looking at pgpool.conf I guess it sounds like a known issue and already fixed. Please try the latest version (3.6.6). |
|
|
You were right! We use the master-slave mode (master_slave_sub_mode = 'stream') and the master node has a zero weight. The latest version wasn't available in the Alpine repositories, so I've written a Dockerfile to build it. |
|
|
So have you confirmed that the problem was gone with 3.6.6? |
|
|
Yes, thank you! |
|
|
Thanks! I'm going close this issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2017-10-17 17:56 | ghuysmans | New Issue | |
| 2017-10-17 17:56 | ghuysmans | File Added: prep.c | |
| 2017-10-17 18:44 | t-ishii | Note Added: 0001759 | |
| 2017-10-17 23:50 | ghuysmans | Note Added: 0001761 | |
| 2017-10-18 09:12 | t-ishii | Note Added: 0001762 | |
| 2017-10-18 09:13 | t-ishii | Assigned To | => t-ishii |
| 2017-10-18 09:13 | t-ishii | Status | new => feedback |
| 2017-10-20 15:21 | ghuysmans | Note Added: 0001771 | |
| 2017-10-20 15:21 | ghuysmans | Status | feedback => assigned |
| 2017-10-20 16:50 | t-ishii | Note Added: 0001772 | |
| 2017-10-24 21:59 | t-ishii | Status | assigned => closed |
| 2017-10-24 21:59 | t-ishii | Fixed in Version | => 3.6.6 |
