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