--0016364edb1c06a811048a1ddab3
Content-Type: text/plain; charset=ISO-8859-1

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

--0016364edb1c06a811048a1ddab3
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">Hi,</p><=
p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier"><br></p><=
p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier"><br></p><=
p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">
We are using pgool-II version 2.3.2.2 (tomiteboshi)and postgres 8.3.9 and f=
acing the below error while running the select queries in the application s=
ide::</p>
<p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier; min-heig=
ht: 16.0px"><br></p>
<p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">=A0ERROR=
:=A0 prepared statement "mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570=
c46e992e" does not exist</p>
<p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">=A0STATE=
MENT:=A0 DEALLOCATE PREPARE mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c4=
6e992e</p>
<p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">=A0WARNI=
NG:=A0 archive_mode enabled, yet archive_command is not set</p>
<p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier; min-heig=
ht: 16.0px"><br></p>
<p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">In the p=
gpool.conf file set the=A0=A0"reset_query_list" =3D'ABORT; RE=
SET ALL; SET SESSION AUTHORIZATION DEFAULT'</p>
<p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier; min-heig=
ht: 16.0px"><br></p><p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0=
px Courier; min-height: 16.0px">We also tested on=A0pgpool-II version 2.3.3=
, result will be same.</p>
<p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier; min-heig=
ht: 16.0px"><br></p><p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0=
px Courier; min-height: 16.0px">Please help us to resolve the issue.</p><p =
style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">
<br></p><p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courier">=
Regards</p><p style=3D"margin: 0.0px 0.0px 0.0px 0.0px; font: 13.0px Courie=
r">Raghu</p>

--0016364edb1c06a811048a1ddab3--

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


--
Sent via pgsql-novice mailing list (pgsql-novice [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

--001517511876e39215048a2676d3
Content-Type: text/plain; charset=ISO-8859-1

On Tue, Jun 29, 2010 at 3:25 PM, Vibhor Kumar <vibhor.kumar [at] 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


--
> 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
>
>

--001517511876e39215048a2676d3
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<br><br><div class=3D"gmail_quote">On Tue, Jun 29, 2010 at 3:25 PM, Vibhor =
Kumar <span dir=3D"ltr"><<a href=3D"mailto:vibhor.kumar [at] enterprisedb.com=
">vibhor.kumar [at] enterprisedb.com</a>></span> wrote:<br><blockquote class=
=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;padd=
ing-left:1ex;">
<div class=3D"im">On 28/06/10 10:32 PM, raghu ram wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
<br>
ERROR: =A0prepared statement "mdb2_statement_pgsql_71417ca02c1aa9cec1d=
d2570c46e992e" does not exist<br>
<br>
=A0STATEMENT: =A0DEALLOCATE PREPARE mdb2_statement_pgsql_71417ca02c1aa9cec1=
dd2570c46e992e<br>
<br>
=A0WARNING: =A0archive_mode enabled, yet archive_command is not set<br>
<br>
<br>
In the pgpool.conf file set the =A0"reset_query_list" =3D'ABO=
RT; RESET ALL; SET SESSION AUTHORIZATION DEFAULT'<br>
<br>
</blockquote>
<br></div>
Change the parameter setting reset_query_list =3D 'ABORT; DISCARD ALL&#=
39;<br><font color=3D"#888888">
<br></font></blockquote><div><br></div><div>Thanks Vibhor...</div><div><br>=
</div><div>If you set the =A0reset_query_list =3D 'ABORT; DISCARD ALL&#=
39; =A0(or)=A0reset_query_list =3D 'ABORT; DISCARD TEMPORARY' also =
getting the same error again for both version of the Pgpool-II.</div>
<div><br></div><div><br></div><div>Thanks&Regards</div><div>Raghu</div>=
<div><br></div><div><br></div><blockquote class=3D"gmail_quote" style=3D"ma=
rgin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;"><font color=
=3D"#888888">
-- <br>
Thanks& =A0Regards,<br>
Vibhor Kumar.<br>
Senior System Engineer.</font><div><div></div><div class=3D"h5"><br>
EnterpriseDB Corporation<br>
The Enterprise Postgres Company<br>
<br>
Office: 732-331-1300 Ext-2022<br>
<br>
Website: <a href=3D"http://www.enterprisedb.com" target=3D"_blank">www.ente=
rprisedb.com</a><br>
EnterpriseDB Blog: <a href=3D"http://blogs.enterprisedb.com" target=3D"_bla=
nk">http://blogs.enterprisedb.com</a><br>
Follow us on Twitter: <a href=3D"http://www.twitter.com/enterprisedb" targe=
t=3D"_blank">http://www.twitter.com/enterprisedb</a><br>
<br>
</div></div></blockquote></div><br>

--001517511876e39215048a2676d3--