Обсуждение: 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 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
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:Change the parameter setting reset_query_list = 'ABORT; DISCARD ALL'
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'
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
--
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