Thread: postgres logs indicate errors with prepared statements, since pgbouncer was installed.
postgres logs indicate errors with prepared statements, since pgbouncer was installed.
From
Chris Barnes
Date:
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@10.0.0.1(56270):822ERROR: prepared statement "dbdpg_p1573_3968" does not exist
2009-11-03 12:00:37 EST:user@10.0.0.1(56270):822STATEMENT: DEALLOCATE dbdpg_p1573_3968
2009-11-03 12:00:37 EST:user@10.0.0.1(56126):28526ERROR: prepared statement "dbdpg_p1573_3969" does not exist
2009-11-03 12:00:37 EST:user@10.0.0.1(56125):28525ERROR: prepared statement "dbdpg_p1573_3969" does not exist
2009-11-03 12:00:37 EST:user@10.0.0.1(56125):28525STATEMENT: DEALLOCATE dbdpg_p1573_3969
2009-11-03 12:00:37 EST:user@10.0.0.1(56270):822ERROR: prepared statement "dbdpg_p1573_3970" does not exist
2009-11-03 12:00:37 EST:user@10.0.0.1(56270):822ERROR: prepared statement "dbdpg_p1573_3970" does not exist
2009-11-03 12:00:37 EST:user@10.0.0.1(56270):822STATEMENT: DEALLOCATE dbdpg_p1573_3970
Any help would be appreciated.
Get a great deal on Windows 7 and see how it works the way you want. Check out the offers on Windows 7now.
Re: postgres logs indicate errors with prepared statements, since pgbouncer was installed.
From
"Greg Sabino Mullane"
Date:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: RIPEMD160
> We are using pgbouncer and seeing these errors in the postgresql logs.
> ...ERROR: prepared statement "dbdpg_p1573_3968" does not exist
>
> I don't believe pgbouncer allows for server prepared statements,
> so why would I see anything in the logs at all?
Because you are using prepared statements. :) You are probably running pgbouncer
at the "transaction" level, in which case you need to do this inside DBD::Pg
right after the initial connection:
$dbh->{pg_server_prepare} = 0;
This will prevent DBD::Pg from using server-side prepares. There's a small cost
to this, but it's usually overshadowed by the efficiency savings of using
pgbouncer.
- --
Greg Sabino Mullane greg@turnstep.com
End Point Corporation
PGP Key: 0x14964AC8 200911051621
http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8
-----BEGIN PGP SIGNATURE-----
iEYEAREDAAYFAkrzQh4ACgkQvJuQZxSWSsg3rACfVejcM3ZJg4yF1ehLB9YbDoMZ
6uUAn0MDvjHqH5ackLznQxTjVBMJUZHm
=Odco
-----END PGP SIGNATURE-----