Results 1 to 1 of 1
  1. #1
    Join Date
    Feb 2004
    Location
    Adelaide, Australia
    Posts
    1

    Unanswered: Communication link failure / mysqld.exe using 100% CPU

    Hi,

    We have just starting using MySQL and have changed our site to using it rather than MS Access. It has been running fantastic, however on Friday morning at around 5am and then again on Sunday morning (today) at around 5am we started getting errors like:

    java.sql.SQLException: Connection is closed

    java.sql.SQLException: Connection.close() has already been called.

    java.sql.SQLException: Communication link failure

    The site became not accessible and when I checked the server mysqld.exe was using 100% CPU. As soon as I stop start MySQL - everything is back to running fine again. I have MySQL running as a NT Service - on Windows 2000 Server. I am using Tomcat 5.0.14, MySQL 4.0.18 and mysql-connector-java-3.0.11. I am also using connection pooling using Tomcat and JNDI. There are no errors in the MySQL logs.

    Any advice would be much appreciated.

    .... It just happened again!

    I was using mysqld.exe and have just read about mysql-nt.exe mysql-max-nt.exe and have changed to using mysql-max-nt.exe. Any ideas if this will help or is better?
    Last edited by johnorth; 02-29-04 at 09:22.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •