View Issue Details

IDProjectCategoryView StatusLast Update
0000146Pgpool-IIBugpublic2016-01-18 11:14
ReporterhelicopterAssigned Tot-ishii 
PriorityhighSeveritymajorReproducibilityalways
Status resolvedResolutionopen 
PlatformOSLinuxOS Version
Product Version 
Target VersionFixed in Version 
Summary0000146: Don't work parameterized query in transaction
DescriptionExample:
  {
    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.
TagsNo tags attached.

Activities

t-ishii

2015-09-17 12:02

developer   ~0000562

Works fine for me. This is pgpool-II 3.4.3, PostgreSQL 9.4.4, streaming replication mode.

helicopter

2015-09-17 23:38

reporter   ~0000570

Sorry. Error occured if load_balancing is on in conf file. If load_balancing is off then all is fine.

t-ishii

2015-09-18 09:50

developer   ~0000571

I have enabled load balancing.

helicopter

2015-09-19 15:22

reporter   ~0000572

Ok. I don't use load balancing. You can close this issue.

Issue History

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