Re: Cached Queries Problem

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

Have I been Warnocked, or has no one come across this problem before?  
If there is a more appropriate forum to address this, I'd love to know.

Thanks,

David Christensen

-----
On Apr 26, 2005, at 8:58 PM, David Christensen wrote:

> Hey folks,
>
> I'm running into a problem wherein I periodically get fatal errors 
> about prepared statement handle "dbdpg_13" already exists.  This will 
> happen even with different queries, accompanied by fatal errors about 
> incorrect number of bind values.  It seems like the name which is 
> associated with a particular prepare_cached query is being reused.
>
> This seems to be related to a query which returns some invalid results 
> (i.e., we've had a die() because of invalid parameters), but it also 
> can be just after a period of time.  Hard restarting apache fixes the 
> problem for a while, but within a few page loads I start to see the 
> problem again.  I've scoured google and the archives to try to find 
> some information about why this may be occurring.
>
> Unfortunately, there are any number of pieces in this puzzle.  I'm 
> using Class::DBI to provide my object relational model, 
> mod_perl-enabled apache as the web server, and HTML::Mason as the 
> templating system.  I'm loading Apache::DBI, DBI, and Class::DBI at 
> startup, as well as the root of my custom Class::DBI subclass.  
> Database driver is DBD::Pg, with postgres 8.0.1 as the backend.
>
> Any ideas?  It seems like the problem is likely with the persistence 
> in some way.  I've already added the code from the wiki to set up my 
> own dbMain handle, and it does not seem to fix the problem.
>
> Thanks,
>
> David Christensen
>