List:General Discussion« Previous MessageNext Message »
From:Chris Date:January 20 2000 2:35am
Subject:Re: Database Handle Destroyed without explicit Disconnect
View as plain text  
Not sure about the other errors, but "Database Handle Destroyed without
explicit Disconnect" occurs when you allow a database handle (lets call it
$dbh) to go out of scope without calling $dbh->disconnect();

--Chris

On Thu, 20 Jan 2000, Wari Wahab wrote:

> After running our Apache/mod_perl server for a few days, we will
> occasionally get server hangs and such all due to the mysql
> 
> Apache error logs are as follows:
> [Thu Jan 20 10:17:38 2000] null: DBD::mysql::st execute failed: Lost
> connection to MySQL server during query at
> /usr/local/apache/lib/perl/Apache/Wasp.pm line 308.
> 
> [Thu Jan 20 10:17:38 2000] [error] DBD::mysql::st execute failed: Lost
> connection to MySQL server during query at
> /usr/local/apache/lib/perl/Apache/Wasp.pm line 308.
> 
> [Thu Jan 20 10:17:38 2000] null: Database handle destroyed without
> explicit disconnect at /usr/lib/perl5/site_perl/Apache/DBI.pm line 119.
> 
> [Thu Jan 20 10:17:38 2000] [error] DBI->connect failed: Can't connect to
> MySQL server on 'wizdb' (0) at /usr/local/apache/lib/perl/Apache/LogDBI.pm
> line 16
> 
> [Thu Jan 20 10:17:38 2000] null: Database handle destroyed without
> explicit disconnect at /usr/lib/perl5/site_perl/Apache/DBI.pm line 119.  
> 
> Actually the lines go down to a few hundreds, it usually spawns too much
> httpd processes while bringing down the server to a grinding halt.. The
> logs on mysql side looks like this:
> 
> 000120 10:16:22  Aborted connection 534870 to db: 'wasp_module' user:
> 'sqluser' (Got timeout reading communication packets)
> 000120 10:16:22  Aborted connection 408401 to db: 'wasp_module' user:
> 'sqluser' (Got timeout reading communication packets)
> 000120 10:16:22  Aborted connection 534912 to db: 'wasp_module' user:
> 'sqluser' (Got timeout reading communication packets)
> 000120 10:16:22  Aborted connection 412731 to db: 'wasp_wasp' user:
> 'sqluser' (Got timeout reading communication packets)
> 000120 10:16:22  Aborted connection 534891 to db: 'wasp_wasp' user:
> 'sqluser' (Got timeout reading communication packets)
> 000120 10:16:22  Aborted connection 408381 to db: 'wasp_module' user:
> 'sqluser' (Got timeout reading communication packets)
> 000120 10:16:22  Aborted connection 534941 to db: 'wasp_wasp' user:
> 'sqluser' (Got timeout reading communication packets)
> 000120 10:16:22  Aborted connection 534860 to db: 'wasp_module' user:
> 'sqluser' (Got timeout reading communication packets)
> 
> Do note that the time is not in sync, what could be happening?
> 
> -- 
> Regards: Wari Wahab
> If a camel is a horse designed by a committee, then a consensus
> forecast is a camel's behind.
> 		-- Edgar R. Fiedler
> 
> -- 
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail mysql-thread24772@stripped
> 
> To unsubscribe, send a message to:
>     <mysql-unsubscribe-chris=hiro.studentadvantage.com@stripped>
> 

Thread
Database Handle Destroyed without explicit DisconnectWari Wahab20 Jan
  • Re: Database Handle Destroyed without explicit DisconnectChris20 Jan
  • Re: Database Handle Destroyed without explicit DisconnectChristof Damian20 Jan
    • Re: Database Handle Destroyed without explicit DisconnectWari Wahab21 Jan
  • Re: Database Handle Destroyed without explicit DisconnectChristof Damian21 Jan