Skip site navigation (1) Skip section navigation (2)

Re: Prepared statement does not exist

From: Nimesh Satam <nimesh(dot)zedo(at)gmail(dot)com>
To: glynastill(at)yahoo(dot)co(dot)uk
Cc: pgsql-performance(at)postgresql(dot)org, Nimesh Satam <nimesh(dot)satam(at)gmail(dot)com>
Subject: Re: Prepared statement does not exist
Date: 2009-03-20 09:03:58
Message-ID: 965aa3ed0903200203w75bd3b96ofdf5b080dbbdd4c2@mail.gmail.com (view raw or flat)
Thread:
Lists: 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(at)yahoo(dot)co(dot)uk> wrote:

>
>
>
>
> --- On Thu, 19/3/09, Nimesh Satam <nimesh(dot)zedo(at)gmail(dot)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?
>
> 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.
>
>
>
>

In response to

Responses

pgsql-performance by date

Next:From: Richard HuxtonDate: 2009-03-20 09:21:18
Subject: Re: Need help with one query
Previous:From: Scott CareyDate: 2009-03-20 06:31:02
Subject: Re: Proposal of tunable fix for scalability of 8.4

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group