Prepared statement issue in Pgpool-II

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Cc: abbas(dot)dba(at)gmail(dot)com
Subject: Prepared statement issue in Pgpool-II
Date: 2010-06-28 21:32:03
Message-ID: AANLkTimzp4L13V8PeQ2mCJY4565dpQ94buAbY85ZspkJ@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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message raghu ram 2010-06-28 22:14:19 Prepared statement issue in Pgpool-II
Previous Message Emanuel Calvo Franco 2010-06-28 19:39:41 Re: pg in the sky

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2010-06-28 21:36:54 Re: Single quotes vs. double quotes when setting a pwd and other cmds
Previous Message Ingmar Alting 2010-06-28 20:48:28 PostgreSQL training

Browse pgsql-novice by date

  From Date Subject
Next Message Greg 2010-06-28 22:01:13 Re: Postgre Protocol
Previous Message Jean-Yves F. Barbier 2010-06-28 18:23:06 Re: AUTO COMMIT