100% CPU utilization with MySQL Connector/J 2.0.14

I recently upgraded from MM.MySQL 2.0.13 to MySQL Connector/J
2.0.14 and have encountered what seems like a serious bug.

After upgrading to 2.0.14, the Tomcat process now regularly goes up to
100% CPU utilization on the machine, disrupting the operation of the
server, although Tomcat and the db queries continue to function. When
I switched back to 2.0.13, the problem went away. I've tested it with
both drivers several times, and when using 2.0.14, this problem
happens consistently, and never happens with the previous version.

How-to-repeat:

Upgrade to Connector/J 2.0.14 on a Windows 2000 Server with Apache
Tomcat/4.0.3 and mysql-3.23.38.

Let Tomcat accept some servlet/JSP requests that query DB through
Connector/J. Wait for CPU utilization to climb to 100%.

------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12712@lists.mysql.com
To unsubscribe, e-mail

Re:100% CPU utilization with MySQL Connector/J 2.0.14

> Subject:
> 100% CPU utilization with MySQL Connector/J 2.0.14
> From:
> Jonathan Abrams
> Date:
> Sun, 13 Oct 2002 15:44:19 -0700
> To:
> bugs@lists.mysql.com
>
>
>I recently upgraded from MM.MySQL 2.0.13 to MySQL Connector/J
>2.0.14 and have encountered what seems like a serious bug.
>
>After upgrading to 2.0.14, the Tomcat process now regularly goes up to
>100% CPU utilization on the machine, disrupting the operation of the
>server, although Tomcat and the db queries continue to function. When
>I switched back to 2.0.13, the problem went away. I've tested it with
>both drivers several times, and when using 2.0.14, this problem
>happens consistently, and never happens with the previous version.
>
>How-to-repeat:
>
>Upgrade to Connector/J 2.0.14 on a Windows 2000 Server with Apache
>Tomcat/4.0.3 and mysql-3.23.38.
>
>Let Tomcat accept some servlet/JSP requests that query DB through
>Connector/J. Wait for CPU utilization to climb to 100%.
>

Can you create a _reproducible_ test case? I have this same setup (but a
newer version of MySQL server) as part of my testing environment and
can't reproduce this problem. Also, there are literally thousands of
people using this version of the driver with Tomcat, so more than likely
this has something to do with some specific way you are using the driver
and/or Tomcat.

It would be most helpful if you could send a version of your servlet,
and the database schema and some test data, or another bit of code that
causes the same problem to happen.

As an alternative, you could try upgrading to MySQL Connector/J 3.0.1 to
see if that solves your problem.

-Mark



------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs-thread12725@lists.mysql.com
To unsubscribe, e-mail