View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000146 | Pgpool-II | Bug | public | 2015-09-17 05:19 | 2016-01-18 11:14 |
| Reporter | helicopter | Assigned To | t-ishii | ||
| Priority | high | Severity | major | Reproducibility | always |
| Status | resolved | Resolution | open | ||
| OS | Linux | ||||
| Summary | 0000146: Don't work parameterized query in transaction | ||||
| Description | Example: { PGconn * conn = PQconnectdb(""); const char * query = "select * from dbsync_test where num=$1; "; const char * params[1]; PQexec(conn, "begin;"); params[0] = "7"; PQexecParams( conn, query, 1, NULL, params, strlen(params[0]), NULL, NULL ); PQexec(conn, "commit;"); PQfinish(conn); } It is down with 'portalXXXXX does not exist' when packet 'parse' of select is being handled. | ||||
| Tags | No tags attached. | ||||
|
|
Works fine for me. This is pgpool-II 3.4.3, PostgreSQL 9.4.4, streaming replication mode. |
|
|
Sorry. Error occured if load_balancing is on in conf file. If load_balancing is off then all is fine. |
|
|
I have enabled load balancing. |
|
|
Ok. I don't use load balancing. You can close this issue. |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-09-17 05:19 | helicopter | New Issue | |
| 2015-09-17 11:55 | t-ishii | Assigned To | => t-ishii |
| 2015-09-17 11:55 | t-ishii | Status | new => assigned |
| 2015-09-17 12:02 | t-ishii | Note Added: 0000562 | |
| 2015-09-17 12:03 | t-ishii | Status | assigned => feedback |
| 2015-09-17 23:38 | helicopter | Note Added: 0000570 | |
| 2015-09-17 23:38 | helicopter | Status | feedback => assigned |
| 2015-09-18 09:50 | t-ishii | Note Added: 0000571 | |
| 2015-09-18 09:50 | t-ishii | Status | assigned => feedback |
| 2015-09-19 15:22 | helicopter | Note Added: 0000572 | |
| 2015-09-19 15:22 | helicopter | Status | feedback => assigned |
| 2016-01-18 11:14 | t-ishii | Status | assigned => resolved |
