Prepared statement issue in Pgpool-II

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

On Tue, Jun 29, 2010 at 3:25 PM, Vibhor Kumar <vibhor.kumar@enterprisedb.com

wrote:

On 28/06/10 10:32 PM, raghu ram wrote:

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'

Change the parameter setting reset_query_list = 'ABORT; DISCARD ALL'

Thanks Vibhor...

If you set the reset_query_list = 'ABORT; DISCARD ALL'
(or) reset_query_list = 'ABORT; DISCARD TEMPORARY' also getting the same
error again for both version of the Pgpool-II.

Thanks&Regards
Raghu

--

On Tue, Jun 29, 2010 at 3:23 PM, Vibhor Kumar <vibhor.kumar@enterprisedb.com

wrote:

On 28/06/10 11:14 PM, raghu ram wrote:

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

Try with reset_query_list= 'ABORT; DISCARD ALL'

Thanks Vibhor...

If you set the reset_query_list = 'ABORT; DISCARD ALL'
(or) reset_query_list = 'ABORT; DISCARD TEMPORARY' also getting the same
error again for both version of the Pgpool-II.

Thanks&Regards
Raghu

On 28/06/10 11:14 PM, raghu ram wrote:

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

Try with reset_query_list= 'ABORT; DISCARD ALL'

--
Thanks& Regards,
Vibhor Kumar.
EnterpriseDB Corporation
The Enterprise Postgres Company

Office: 732-331-1300 Ext-2022

Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb

On 28/06/10 10:32 PM, raghu ram wrote:

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'

Change the parameter setting reset_query_list = 'ABORT; DISCARD ALL'

--
Thanks& Regards,
Vibhor Kumar.
Senior System Engineer.
EnterpriseDB Corporation
The Enterprise Postgres Company

Office: 732-331-1300 Ext-2022

Website: www.enterprisedb.com
EnterpriseDB Blog: http://blogs.enterprisedb.com
Follow us on Twitter: http://www.twitter.com/enterprisedb