Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-generalpgsql-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

pgsql-novice by date

Next:From: GregDate: 2010-06-28 22:01:13
Subject: Re: Postgre Protocol
Previous:From: Jean-Yves F. BarbierDate: 2010-06-28 18:23:06
Subject: Re: AUTO COMMIT

pgsql-admin by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group