[Pgpool-general] pool_add_prepared_statement: prepared statement already exists

Toshihiro Kitagawa kitagawa at sraoss.co.jp
Thu Jan 13 03:36:43 UTC 2011


On Wed, 12 Jan 2011 13:19:06 +0000 (GMT)
Glyn Astill <glynastill at yahoo.co.uk> wrote:

> Any luck with this?

I see.
You use pgpool-II in RAW(connection pooling) mode, but
I didn't check in the mode.

I've attached a new patch that includes previous patch.
Can you please try it?

--
SRA OSS, Inc. Japan
Toshihiro Kitagawa

> 
> --- On Tue, 11/1/11, Glyn Astill <glynastill at yahoo.co.uk> wrote:
> 
> > From: Glyn Astill <glynastill at yahoo.co.uk>
> > Subject: Re: [Pgpool-general] pool_add_prepared_statement: prepared statement already exists
> > To: "Toshihiro Kitagawa" <kitagawa at sraoss.co.jp>
> > Cc: pgpool-general at pgfoundry.org
> > Date: Tuesday, 11 January, 2011, 14:32
> > --- On Tue, 11/1/11, Toshihiro
> > Kitagawa <kitagawa at sraoss.co.jp>
> > wrote:
> > 
> > > From: Toshihiro Kitagawa <kitagawa at sraoss.co.jp>
> > > Subject: Re: [Pgpool-general]
> > pool_add_prepared_statement: prepared statement already
> > exists
> > > To: "Glyn Astill" <glynastill at yahoo.co.uk>
> > > Cc: pgpool-general at pgfoundry.org
> > > Date: Tuesday, 11 January, 2011, 13:47
> > > On Tue, 11 Jan 2011 12:35:24 +0000
> > > (GMT)
> > > Glyn Astill <glynastill at yahoo.co.uk>
> > > wrote:
> > > 
> > > > I've applied both patches, but I'm not seeing
> > any
> > > changes to either issue.
> > > > 
> > > > I've attached an strace log where I've:
> > > > 
> > > > 1) started pgpool
> > > > 2) connected from a client
> > > > 3) had that client issue the prepare, deallocate
> > and
> > > prepare to get the error
> > > > 4) killed pgpool
> > > > 
> > > > Let me know if this is any use.
> > > 
> > > Can you show debug mode log too?
> > > The debug mode uses -d option.
> > > 
> > 
> > No problem, attached.
> > 
> > Glyn
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: deallocate2.patch
Type: application/octet-stream
Size: 10945 bytes
Desc: not available
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110113/63e5875b/attachment-0001.obj>


More information about the Pgpool-general mailing list