Re: Cached Queries Problem

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

On Apr 28, 2005, at 9:59 AM, Perrin Harkins wrote:

> David Christensen said:
>> I am using code you provided from the wiki for db_Main.  But I
>> neglected to close the connection after the initial load.  So I think
>> we ended up with a "shared" dbi handle between apache processed.
>> (Obviously a big no-no).  Once I added a
>> MyClass::DBI->db_Main->disconnect to the end of the startup file, it
>> seemed to work ok.
>
> That worries me a little because you said you were using Apache::DBI 
> and
> it should not cache connections opened during startup.  Maybe you have 
> an
> old version of DBI/Class::DBI/Apache::DBI?  I still think it would be a
> good idea to turn on the Apache::DBI debugging.
>
> - Perrin

The cpan tool reports that all of the above are up to date.  I'll 
enable to Apache::DBI debugging.  I'll also verify that the overridden 
db_Main matches the wiki's version.  One wrinkle that I noticed in the 
site now is that page loads seem to be taking a long time now (a second 
or so) whereas before it was fairly instantaneous.  Could be trying to 
reconnect every time.

David