Prepared statement does not exist

From: Nimesh Satam <nimesh(dot)zedo(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org, Nimesh Satam <nimesh(dot)satam(at)gmail(dot)com>
Subject: Prepared statement does not exist
Date: 2009-03-19 11:32:07
Message-ID: 965aa3ed0903190432i77ca9b39v733663f92ef3e2d0@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Glyn Astill 2009-03-19 11:37:11 Re: Prepared statement does not exist
Previous Message Oleg Bartunov 2009-03-19 07:02:41 Re: Extremely slow intarray index creation and inserts.