[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-admin
Subject:    Re: [ADMIN] [NOVICE] Prepared statement issue in Pgpool-II
From:       raghu ram <raghuchennuru () gmail ! com>
Date:       2010-06-29 7:49:07
Message-ID: AANLkTikez6YPtvCC7zMXaD89JrrK1IdeBHfvPpc6HFKN () mail ! gmail ! com
[Download RAW message or body]

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


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

[Attachment #3 (text/html)]

<br><br><div class="gmail_quote">On Tue, Jun 29, 2010 at 3:25 PM, Vibhor Kumar <span \
dir="ltr">&lt;<a href="mailto:vibhor.kumar@enterprisedb.com">vibhor.kumar@enterprisedb.com</a>&gt;</span> \
wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex;"> <div class="im">On 28/06/10 10:32 PM, raghu ram \
wrote:<br> <blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px \
#ccc solid;padding-left:1ex"> <br>
ERROR:  prepared statement \
&quot;mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e&quot; does not exist<br> \
<br>  STATEMENT:  DEALLOCATE PREPARE \
mdb2_statement_pgsql_71417ca02c1aa9cec1dd2570c46e992e<br> <br>
 WARNING:  archive_mode enabled, yet archive_command is not set<br>
<br>
<br>
In the pgpool.conf file set the  &quot;reset_query_list&quot; =&#39;ABORT; RESET ALL; \
SET SESSION AUTHORIZATION DEFAULT&#39;<br> <br>
</blockquote>
<br></div>
Change the parameter setting reset_query_list = &#39;ABORT; DISCARD ALL&#39;<br><font \
color="#888888"> <br></font></blockquote><div><br></div><div>Thanks \
Vibhor...</div><div><br></div><div>If you set the  reset_query_list = &#39;ABORT; \
DISCARD ALL&#39;  (or) reset_query_list = &#39;ABORT; DISCARD TEMPORARY&#39; also \
getting the same error again for both version of the Pgpool-II.</div> \
<div><br></div><div><br></div><div>Thanks&amp;Regards</div><div>Raghu</div><div><br></div><div><br></div><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
                solid;padding-left:1ex;"><font color="#888888">
-- <br>
Thanks&amp;  Regards,<br>
Vibhor Kumar.<br>
Senior System Engineer.</font><div><div></div><div class="h5"><br>
EnterpriseDB Corporation<br>
The Enterprise Postgres Company<br>
<br>
Office: 732-331-1300 Ext-2022<br>
<br>
Website: <a href="http://www.enterprisedb.com" \
target="_blank">www.enterprisedb.com</a><br> EnterpriseDB Blog: <a \
href="http://blogs.enterprisedb.com" \
target="_blank">http://blogs.enterprisedb.com</a><br> Follow us on Twitter: <a \
href="http://www.twitter.com/enterprisedb" \
target="_blank">http://www.twitter.com/enterprisedb</a><br> <br>
</div></div></blockquote></div><br>



[prev in list] [next in list] [prev in thread] [next in thread]