Bug #20512 Using Hibernate, there's is a deadlock condition that's easily repeatable
Submitted: 16 Jun 2006 17:13 Modified: 24 Oct 2006 17:35
Reporter: Package Bugs Email Updates:
Status: Closed Impact on me:
None 
Category:Connector / J Severity:S1 (Critical)
Version:3.1.12 OS:Solaris (Solaris 10 SPARC and x86)
Assigned to: CPU Architecture:Any

[16 Jun 2006 17:13] Package Bugs
Description:
Using Hibernate3 and making a series of inserts, updates, and selects, we periodically see a deadlock. By "deadlock" a thread will hang forever. No exception is thrown. We've tried the development version Connector/J to no avail. 

How to repeat:
Please download the package below, compile, and run.

http://clamps.fotolog.net/tmp/deadlock_test.tgz

In said package following the directions below:

1. make all MYSQL_USER=root MYSQL_PASSWD=flr0ot_0502 MYSQL_HOST=db.sol
   - after it prints first couple lines of output, wait 15-20 sec and
2. pgrep -n java | xargs kill -QUIT
[16 Jun 2006 17:39] Mark Matthews
Can you post the thread dump (i.e. _your_ output of "pgrep -n java | xargs kill -QUIT")?
[16 Jun 2006 18:35] Package Bugs
full jvm thread dump for mysql-connector-java-3.1.12-bin.jar

Attachment: mysql-connector-java-3.1.12-bin.jar.out (application/octet-stream, text), 12.96 KiB.

[16 Jun 2006 18:36] Package Bugs
full jvm thread dump for mysql-connector-java-5.0.0-beta-bin.jar

Attachment: mysql-connector-java-5.0.0-beta-bin.jar.out (application/octet-stream, text), 12.31 KiB.

[16 Jun 2006 18:37] Package Bugs
Thanks for the reply!

Here are 2 stacktraces for mysql-connector-java-3.1.12-bin.jar and mysql-connector-java-5.0.0-beta-bin.jar.
They deadlock in different places but both do deadlock:

In the 'files' section there are:
mysql-connector-java-3.1.12-bin.jar.out
mysql-connector-java-5.0.0-beta-bin.jar.out

In both cases

java version "1.5.0_06"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_06-b05)
Java HotSpot(TM) Client VM (build 1.5.0_06-b05, mixed mode)

and

mysql  Ver 14.7 Distrib 4.1.18, for pc-solaris2.8 (i386) using readline 5.0

were used.

Thanks for looking into it!
[16 Jun 2006 18:58] Mark Matthews
Please try the latest nightly snapshot build of 5.0 from http://downloads.mysql.com/snapshots.php#connector-j as it has fixes for this problem that have been reported in earlier bug reports.
[16 Jun 2006 21:44] Package Bugs
Running with mysql-connector-java-5.0-nightly-20060616-bin.jar for more than an hour now, Ok so far. With earlier versions it only took seconds to deadlock. I'll keep running the tests but looks like it got fixed!
Thanks a lot!

Any hints as to when we can expect production release?