Received: from localhost (unknown [200.46.208.211])
	by mail.postgresql.org (Postfix) with ESMTP id 6265E6325D4
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 19 Mar 2009 08:32:13 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024)
	with ESMTP id 88827-09
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Thu, 19 Mar 2009 08:32:02 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from rv-out-0506.google.com (rv-out-0506.google.com
 [209.85.198.231])
	by mail.postgresql.org (Postfix) with ESMTP id BB08F62F5D9
	for <pgsql-performance@postgresql.org>;
	Thu, 19 Mar 2009 08:32:07 -0300 (ADT)
Received: by rv-out-0506.google.com with SMTP id l9so510515rvb.43
	for <pgsql-performance@postgresql.org>;
	Thu, 19 Mar 2009 04:32:07 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:date:message-id:subject
	:from:to:content-type;
	bh=lmwArYoCmcwZmwPJQNEfGXsoJ6/QiWgNTEeDuqUEyAU=;
	b=PpJanVodOIVXccJu79NDdmUkaSrZ4LGUwGrq5FZdIjaqA19zPp0EmQu7I4mwO7ce/w
	1q73n2QhTtl3sFqUc1g1klNh57ZOGAgEfwITUbLLit73stainv1YlqKzzuMZkZhLzkZ+
	o7ZWrCQe0bWnJeVLSUgvNnJdvznCBAUwgRWHo=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:date:message-id:subject:from:to:content-type;
	b=AnO5zZDI7NvQnThSY6Aj0WAl6dYKDUU/8qtSUNngiE8kPOzhHtiDxe8OlIxy7kg+GP
	joN4v+Pr4V0BPWKK15VMQzMunx+wP238AUk9Q4xKbAO8JGZagfmlPjVFz/zQP9Auc3pY
	jMX+aWE/vw1xPdxiifM5LItTg44ZiHl7YZ95A=
MIME-Version: 1.0
Received: by 10.142.103.11 with SMTP id a11mr886548wfc.208.1237462327060;
 Thu,
	19 Mar 2009 04:32:07 -0700 (PDT)
Date: Thu, 19 Mar 2009 17:02:07 +0530
Message-ID: <965aa3ed0903190432i77ca9b39v733663f92ef3e2d0@mail.gmail.com>
Subject: Prepared statement does not exist
From: Nimesh Satam <nimesh.zedo@gmail.com>
To: pgsql-performance@postgresql.org, Nimesh Satam <nimesh.satam@gmail.com>
Content-Type: multipart/alternative; boundary=00504502c8ee6d688f04657726bf
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200903/264
X-Sequence-Number: 33186

--00504502c8ee6d688f04657726bf
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

Hi,

I am not sure if sending this to the right place. I did try to get the
answer from pgpool mailing list but no luck . Would appreciate if someone
can help here.

We are receving the following error in the postgres database logs:

2009-03-19 02:14:20 PDT [2547]: [79-1] LOG:  duration: 0.039 ms  statement:
RESET ALL
2009-03-19 02:14:20 PDT [2547]: [80-1] LOG:  duration: 0.027 ms  statement:
SET SESSION AUTHORIZATION DEFAULT
2009-03-19 02:14:20 PDT [2547]: [81-1] ERROR:  prepared statement "S_1" does
not exist
2009-03-19 02:14:20 PDT [2547]: [82-1] STATEMENT:  DEALLOCATE "S_1"
2009-03-19 02:14:20 PDT [2547]: [83-1] ERROR:  prepared statement "S_4" does
not exist
2009-03-19 02:14:20 PDT [2547]: [84-1] STATEMENT:  DEALLOCATE "S_4"

We receive this errors when we start connecting the java application
thorugh pgpool. What causes this problem and how can it be avoided?

Postgres version: 8.3.3
pgpool II: 2.0.1

Thanks & Regards,
Nimesh.

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

<div>Hi,</div>
<div>=A0</div>
<div>I am not sure if sending this to the right place. I did try to get the=
 answer from pgpool mailing list but no luck . Would appreciate if someone =
can help here.</div>
<div>=A0</div>
<div>We are receving the following error in the postgres database logs:</di=
v>
<div>=A0</div>
<div>2009-03-19 02:14:20 PDT [2547]: [79-1] LOG:=A0 duration: 0.039 ms=A0 s=
tatement:=A0 RESET ALL</div>
<div>2009-03-19 02:14:20 PDT [2547]: [80-1] LOG:=A0 duration: 0.027 ms=A0 s=
tatement:=A0 SET SESSION AUTHORIZATION DEFAULT=A0</div>
<div>2009-03-19 02:14:20 PDT [2547]: [81-1] ERROR:=A0 prepared statement &q=
uot;S_1&quot; does not exist</div>
<div>2009-03-19 02:14:20 PDT [2547]: [82-1] STATEMENT:=A0 DEALLOCATE &quot;=
S_1&quot;</div>
<div>2009-03-19 02:14:20 PDT [2547]: [83-1] ERROR:=A0 prepared statement &q=
uot;S_4&quot; does not exist</div>
<div>2009-03-19 02:14:20 PDT [2547]: [84-1] STATEMENT:=A0 DEALLOCATE &quot;=
S_4&quot;</div>
<div>=A0</div>
<div>We receive this errors when we start=A0connecting the=A0java applicati=
on thorugh=A0pgpool. What causes this problem and how can it be avoided? </=
div>
<div>=A0</div>
<div>Postgres version: 8.3.3</div>
<div>pgpool II: 2.0.1</div>
<div>=A0</div>
<div>Thanks &amp; Regards,</div>
<div>Nimesh.</div>
<div>=A0</div>
<div>=A0</div>
<div>=A0</div>

--00504502c8ee6d688f04657726bf--