postgres logs indicate errors with prepared statements, since pgbouncer was installed.

From: Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com>
To: Postgres General Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: postgres logs indicate errors with prepared statements, since pgbouncer was installed.
Date: 2009-11-03 17:19:31
Message-ID: BLU149-W393200AD8D422036E5B4B0D4B20@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


We are using pgbouncer and seeing these errors in the postgresql logs.

I don't believe pgbouncer allows for server prepared statements, so why would I see anything in the logs at all?

2009-11-03 12:00:37 EST:user(at)10(dot)0(dot)0(dot)1(56270):822ERROR: prepared statement "dbdpg_p1573_3968" does not exist
2009-11-03 12:00:37 EST:user(at)10(dot)0(dot)0(dot)1(56270):822STATEMENT: DEALLOCATE dbdpg_p1573_3968
2009-11-03 12:00:37 EST:user(at)10(dot)0(dot)0(dot)1(56126):28526ERROR: prepared statement "dbdpg_p1573_3969" does not exist
2009-11-03 12:00:37 EST:user(at)10(dot)0(dot)0(dot)1(56125):28525ERROR: prepared statement "dbdpg_p1573_3969" does not exist
2009-11-03 12:00:37 EST:user(at)10(dot)0(dot)0(dot)1(56125):28525STATEMENT: DEALLOCATE dbdpg_p1573_3969
2009-11-03 12:00:37 EST:user(at)10(dot)0(dot)0(dot)1(56270):822ERROR: prepared statement "dbdpg_p1573_3970" does not exist
2009-11-03 12:00:37 EST:user(at)10(dot)0(dot)0(dot)1(56270):822ERROR: prepared statement "dbdpg_p1573_3970" does not exist
2009-11-03 12:00:37 EST:user(at)10(dot)0(dot)0(dot)1(56270):822STATEMENT: DEALLOCATE dbdpg_p1573_3970

Any help would be appreciated.

_________________________________________________________________
Windows Live: Friends get your Flickr, Yelp, and Digg updates when they e-mail you.
http://go.microsoft.com/?linkid=9691817

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sam Jas 2009-11-03 17:21:10 Re: Connection Problems!
Previous Message Chris Barnes 2009-11-03 16:32:36 Bench marking performance or experience using Solid State Disk Drives (SSD) with postgres