Re: [NOVICE] Prepared statement issue in Pgpool-II

From: raghu ram <raghuchennuru(at)gmail(dot)com>
To: Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org, abbas(dot)dba(at)gmail(dot)com
Subject: Re: [NOVICE] Prepared statement issue in Pgpool-II
Date: 2010-06-29 07:48:34
Message-ID: AANLkTikez6YPtvCC7zMXaD89JrrK1IdeBHfvPpc6HFKN@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general pgsql-novice

On Tue, Jun 29, 2010 at 3:25 PM, Vibhor Kumar <vibhor(dot)kumar(at)enterprisedb(dot)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
>
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message raghu ram 2010-06-29 07:49:58 Re: Prepared statement issue in Pgpool-II
Previous Message raghu ram 2010-06-28 22:14:19 Prepared statement issue in Pgpool-II

Browse pgsql-general by date

  From Date Subject
Next Message raghu ram 2010-06-29 07:49:58 Re: Prepared statement issue in Pgpool-II
Previous Message dario.ber@libero.it 2010-06-29 07:37:36 R: Re: postgres user password: Log on failure

Browse pgsql-novice by date

  From Date Subject
Next Message raghu ram 2010-06-29 07:49:58 Re: Prepared statement issue in Pgpool-II
Previous Message Tom Lane 2010-06-28 23:10:45 Re: Postgre Protocol