Re: Prepared statement does not exist
| От | Nimesh Satam |
|---|---|
| Тема | Re: Prepared statement does not exist |
| Дата | |
| Msg-id | 965aa3ed0903200203w75bd3b96ofdf5b080dbbdd4c2@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Prepared statement does not exist (Glyn Astill <glynastill@yahoo.co.uk>) |
| Ответы |
Re: Prepared statement does not exist
|
| Список | pgsql-performance |
Glyn Astill,
Thank for your reply. But can you confirm on this? As what I see from
the logs, its pgpool which is trying to deallocate the prepared
statement and not the application. The application just disconnects
and not tyring to use the same connection.
Regards,
Nimesh.
On Thu, Mar 19, 2009 at 5:07 PM, Glyn Astill <glynastill@yahoo.co.uk> wrote:
Looks like your app is dissconnecting from pgpool which is causing pgpool to send the RESET ALL, this will deallocate the prepared statement. Then the app is reconnecting to pgpool again and expecting the prepared statement to still be available, which it will not be.
--- On Thu, 19/3/09, Nimesh Satam <nimesh.zedo@gmail.com> wrote:
>
> 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?
В списке pgsql-performance по дате отправления: