Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id AC3FA632F9E; Tue, 29 Jun 2010 02:25:54 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 61752-06; Tue, 29 Jun 2010 05:25:47 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from exprod7og123.obsmtp.com (exprod7og123.obsmtp.com [64.18.2.24]) by mail.postgresql.org (Postfix) with SMTP id 9D98162D9C0; Tue, 29 Jun 2010 02:25:44 -0300 (ADT) Received: from source ([209.85.216.170]) by exprod7ob123.postini.com ([64.18.6.12]) with SMTP ID DSNKTCmD1zO8ndAzTRlHIc2Jx279tcAXwLB0@postini.com; Mon, 28 Jun 2010 22:25:44 PDT Received: by qyk1 with SMTP id 1so1039597qyk.1 for ; Mon, 28 Jun 2010 22:25:42 -0700 (PDT) Received: by 10.224.32.163 with SMTP id c35mr4178660qad.184.1277789142798; Mon, 28 Jun 2010 22:25:42 -0700 (PDT) Received: from Vibhor-Kumars-MacBook-Pro.local ([117.195.2.121]) by mx.google.com with ESMTPS id i20sm22437129qci.45.2010.06.28.22.25.38 (version=SSLv3 cipher=RC4-MD5); Mon, 28 Jun 2010 22:25:41 -0700 (PDT) Message-ID: <4C29C32E.8070303@enterprisedb.com> Date: Tue, 29 Jun 2010 10:55:58 +0100 From: Vibhor Kumar Organization: EnterpriseDB Corporation User-Agent: Mozilla/5.0 (Macintosh; U; Intel Mac OS X 10.6; en-US; rv:1.9.1.10) Gecko/20100512 Lightning/1.0b1 Thunderbird/3.0.5 MIME-Version: 1.0 To: raghu ram CC: pgsql-admin@postgresql.org, pgsql-novice@postgresql.org, abbas.dba@gmail.com Subject: Re: [NOVICE] Prepared statement issue in Pgpool-II References: In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.173 tagged_above=-10 required=5 tests=BAYES_00=-1.9, DATE_IN_FUTURE_03_06=3.027, RCVD_IN_DNSWL_MED=-2.3 X-Spam-Level: X-Archive-Number: 201006/211 X-Sequence-Number: 34989 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