Prepared statement does not exist - Mailing list pgsql-performance

From Nimesh Satam
Subject Prepared statement does not exist
Date
Msg-id 965aa3ed0903190432i77ca9b39v733663f92ef3e2d0@mail.gmail.com
Whole thread Raw
Responses Re: Prepared statement does not exist  (Glyn Astill <glynastill@yahoo.co.uk>)
List 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.
 
 
 

pgsql-performance by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: Extremely slow intarray index creation and inserts.
Next
From: Glyn Astill
Date:
Subject: Re: Prepared statement does not exist