From: Nimesh Satam <nimesh.zedo@gmail.com>
To: pgsql-performance@postgresql.org, Nimesh Satam <nimesh.satam@gmail.com>
Subject: Prepared statement does not exist
Date: Thu, 19 Mar 2009 17:02:07 +0530
Message-ID: <965aa3ed0903190432i77ca9b39v733663f92ef3e2d0@mail.gmail.com> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: nimesh.zedo@gmail.com, nimesh.satam@gmail.com
Subject: Re: Prepared statement does not exist
In-Reply-To: <965aa3ed0903190432i77ca9b39v733663f92ef3e2d0@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox