Postgres Pro
Downloads
Home   >   mailing lists

Prepared statement issue in Pgpool-II - Mailing list pgsql-admin

From raghu ram
Subject Prepared statement issue in Pgpool-II
Date
Msg-id AANLkTimzp4L13V8PeQ2mCJY4565dpQ94buAbY85ZspkJ@mail.gmail.com
Whole thread Raw
Responses Re: [NOVICE] Prepared statement issue in Pgpool-II  (Vibhor Kumar <vibhor.kumar@enterprisedb.com>)
List pgsql-admin
Tree view

Hi,



We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and facing the below error while running the select queries in the application side::


 ERROR:  prepared statement "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e" does not exist

 STATEMENT:  DEALLOCATE PREPARE mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e

 WARNING:  archive_mode enabled, yet archive_command is not set


In the pgpool.conf file set the  "reset_query_list" ='ABORT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'


We also tested on pgpool-II version 2.3.3, result will be same.


Please help us to resolve the issue.


Regards

Raghu

pgsql-admin by date:

Previous
From: Emanuel Calvo Franco
Date:
Subject: Re: pg in the sky
Next
From: Vibhor Kumar
Date:
Subject: Re: [NOVICE] Prepared statement issue in Pgpool-II