Re: Cached Queries Problem

[prev] [thread] [next] [Date index for 2005/04/28]

On Apr 27, 2005, at 11:35 PM, Perrin Harkins wrote:
>>> I'm running into a problem wherein I periodically get fatal errors 
>>> about prepared statement handle "dbdpg_13" already exists.
>
> Have you determined where the name dbdpg_13 comes from?  That might be 
> a clue.

I believe it would be the 13th query that DBD::Pg has cached thus far.

> Also, make sure you are not opening any connections or preparing any 
> queries before apache forks.  (Or make sure you close them if you 
> must.)

One thing that I am doing is trying to preload my Class::DBI subclass 
in apache (just via a use statement). I'm using one of the table-setup 
utility functions rather than hard-coding the fields in, so that may be 
the cause of the problem -- we obviously have to query the database 
before we can pull info out of the system tables.

I'll try avoiding the preload and let you all know how things work out.

Thanks,

David