Prepared statement issue in Pgpool-II

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Prepared statement issue in Pgpool-II
Date: 2010-06-28 22:14:19
Message-ID: AANLkTilIhn8hWGrxid5r5_ZTO9IGX3XeklCTv0Lkgag_@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-novice

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message raghu ram 2010-06-29 07:48:34 Re: [NOVICE] Prepared statement issue in Pgpool-II
Previous Message raghu ram 2010-06-28 21:32:03 Prepared statement issue in Pgpool-II

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2010-06-28 22:36:10 Re: The case of PostgreSQL on NFS Server
Previous Message Scott Marlowe 2010-06-28 21:45:50 Re: weird initdb output

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2010-06-28 23:10:45 Re: Postgre Protocol
Previous Message Greg 2010-06-28 22:01:13 Re: Postgre Protocol