Re: DBI 1.15+ establishes multiple connections under parent mod_perl process

2001-11-02 Thread Scott R. Godin
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Tim Bunce) wrote: > > There were connect() changes made between DBI 1.14 and 1.15 but I'd need > people to look into it for me. Should be trivial to debug by enabling > DBI tracing and Apache::DBi debug. Unless your admin refuses to run any of

Re: DBI 1.15+ establishes multiple connections under parent mod_perl process

2001-11-02 Thread Scott R. Godin
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Eric Kolve) wrote: > I have traced it back to prepare_cached() (at least that is what I > notice). > > Scott, try replacing your calls on startup with prepare() instead of > prepare_cached(). no, I'm using prepare(). an earlier post thread o

Re: DBI 1.15+ establishes multiple connections under parent mod_perl process

2001-11-02 Thread E Kolve
What trace level should I use? I figure I can run trace and debug for when it works and doesn't work; dump to two separate log files and post to either the group or just send it to you Tim if you have time to look at it. thanks, --eric Tim Bunce wrote: > > But prepare_cached/prepare has noth

Re: DBI 1.15+ establishes multiple connections under parent mod_perl process

2001-11-02 Thread Tim Bunce
But prepare_cached/prepare has nothing to do with multiple connections. There were connect() changes made between DBI 1.14 and 1.15 but I'd need people to look into it for me. Should be trivial to debug by enabling DBI tracing and Apache::DBi debug. Tim. On Fri, Nov 02, 2001 at 07:51:33AM -0800

Re: DBI 1.15+ establishes multiple connections under parent mod_perl process

2001-11-02 Thread Eric Kolve
I have traced it back to prepare_cached() (at least that is what I notice). Scott, try replacing your calls on startup with prepare() instead of prepare_cached(). I was also able to eliminate the problem if I commented out the following line in DBI.pm # $dbh->STORE('CachedKids', $cache = {})

Re: DBI 1.15+ establishes multiple connections under parent mod_perl process

2001-11-02 Thread Scott R. Godin
In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED] (Eric Kolve) wrote: > I think I have found a curious bug in DBI. It seems that since DBI 1.15 > - 1.20, when you bring up apache/mod_perl and execute queries against > the database handle in the parent process (startup.pl), multiple > connection

DBI 1.15+ establishes multiple connections under parent mod_perl process

2001-10-31 Thread Eric Kolve
I think I have found a curious bug in DBI. It seems that since DBI 1.15 - 1.20, when you bring up apache/mod_perl and execute queries against the database handle in the parent process (startup.pl), multiple connections result against the database. If I switch to DBI 1.14, no such problem occurs.