Hi, Below is the log of $Apache::DBI::DEBUG = 2;
[Thu Nov 12 12:45:34 2009] [notice] SIGHUP received. Attempting to restart 32162 Apache::DBI PerlChildInitHandler 32162 Apache::DBI need ping: yes 32163 Apache::DBI PerlChildInitHandler 32163 Apache::DBI need ping: yes 32164 Apache::DBI PerlChildInitHandler 32164 Apache::DBI need ping: yes 32165 Apache::DBI PerlChildInitHandler 32165 Apache::DBI need ping: yes 32166 Apache::DBI PerlChildInitHandler 32166 Apache::DBI need ping: yes 32167 Apache::DBI PerlChildInitHandler 32167 Apache::DBI need ping: yes 32168 Apache::DBI PerlChildInitHandler 32168 Apache::DBI need ping: yes 32169 Apache::DBI PerlChildInitHandler [Thu Nov 12 12:45:35 2009] [notice] Apache/2.2.13 (Unix) PHP/5.2.10 mod_perl/2.0.4 Perl/v5.8.8 configured -- resuming normal operations 32169 Apache::DBI need ping: yes 32163 Apache::DBI new connect to 'xxxAutoCommit=1PrintError=1RaiseError=1Username=xxx' 32162 Apache::DBI new connect to 'xxxAutoCommit=1PrintError=1RaiseError=1Username=xxx' 32164 Apache::DBI new connect to 'xxxAutoCommit=1PrintError=1RaiseError=1Username=xxx' 32166 Apache::DBI new connect to 'xxxAutoCommit=1PrintError=1RaiseError=1Username=xxx' 32165 Apache::DBI new connect to 'xxxAutoCommit=1PrintError=1RaiseError=1Username=xxx' 32168 Apache::DBI new connect to 'xxxAutoCommit=1PrintError=1RaiseError=1Username=xxx' 32167 Apache::DBI new connect to 'xxxAutoCommit=1PrintError=1RaiseError=1Username=xxx' 32169 Apache::DBI new connect to 'xxxAutoCommit=1PrintError=1RaiseError=1Username=xxx' 32162 Apache::DBI push PerlCleanupHandler 32162 Apache::DBI need ping: yes 32162 Apache::DBI already connected to 'xxxAutoCommit=1PrintError=1RaiseError=1Username=xxx' 32162 Apache::DBI PerlCleanupHandler -Raja -----Original Message----- From: Perrin Harkins [mailto:phark...@gmail.com] Sent: Wednesday, November 11, 2009 11:26 PM To: Artem Kuchin Cc: Kulasekaran, Raja; modperl@perl.apache.org Subject: 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