Re: DBI Connectons accumulate under Mod_perl
On Nov 10, 2009, at 9:34 PM, Kulasekaran, Raja wrote: I'm connecting against oracle. So for every request it establish the connection and it remains stable even though the request has been completed successfully . That sounds right, as the Apache process that handles the requests will stick around to handle more requests. But when that process dies, it should disconnect from the database. Does it? Best, David
Re: DBI Connectons accumulate under Mod_perl
On Tue, Nov 10, 2009 at 10:04 AM, Artem Kuchin mat...@itlegion.ru wrote: The weirdest thing is that there are two sites, running pretty much the same software (minor changes to user part, no changes to db part). Connections from one site accumulate, connection from other site do not accmulate - disconnect work fine. Your disconnect() calls should not not do anything if Apache::DBI is loaded. Make sure you load it before you load DBI. To see what's happening, turn on debugging by setting $Apache::DBI::DEBUG to 2 after you load Apache::DBI. - Perrin
Alias
Hi, i've got in httpd.conf this directive Alias /dummy/ /var/local/apache2/example How can I take the real path value ? Idel
RE: DBI Connectons accumulate under Mod_perl
No. I could see that oracle instances are still alive. -Original Message- From: David E. Wheeler [mailto:da...@kineticode.com] Sent: Wednesday, November 11, 2009 11:20 PM To: Kulasekaran, Raja Cc: Artem Kuchin; modperl@perl.apache.org Subject: Re: DBI Connectons accumulate under Mod_perl On Nov 10, 2009, at 9:34 PM, Kulasekaran, Raja wrote: I'm connecting against oracle. So for every request it establish the connection and it remains stable even though the request has been completed successfully . That sounds right, as the Apache process that handles the requests will stick around to handle more requests. But when that process dies, it should disconnect from the database. Does it? Best, David
Re: DBI Connectons accumulate under Mod_perl
On Nov 11, 2009, at 6:22 PM, Kulasekaran, Raja wrote: No. I could see that oracle instances are still alive. That shouldn't be, of course. Did you run the DBI trace mode as Perrin suggested? Best, David