| 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: | Whole Thread | Raw Message | 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. |