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>
>
