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.
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. |