Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (athena.apache.org: local policy)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
  s=s1024; d=yahoo.com;
  h=X-YMail-OSG:Received:X-Mailer:References:Message-ID:Date:From:Reply-To:Subject:To:In-Reply-To:MIME-Version:Content-Type;
  b=0PhVbpb7TxouEquhNgwPzfQkGMk4/oO5jMVftLJK8Yn4sD/Z6uEv7Rt3lA5K81UT1fuXvGlDySOF7iNtCQr8ejgk6bL3G0D3Lr8kSU1plu7NiFJgB1L53eeSSLtn63AoIPrxCvteLL9SQ7LPvi0vNYXQoj9Ts8HTqexMtd35c6I=;
References: <1327642684.98385.YahooMailNeo@web112013.mail.gq1.yahoo.com>
Message-ID: <1327647833.84426.YahooMailNeo@web112008.mail.gq1.yahoo.com>
Date: Thu, 26 Jan 2012 23:03:53 -0800 (PST)
From: gnath <gautam_exquisite@yahoo.com>
Reply-To: gnath <gautam_exquisite@yahoo.com>
Subject: Re: Dead lock with tomcat-jdbc.jar on Tomcat 6.0.35
To: Tomcat Users List <users@tomcat.apache.org>
In-Reply-To: <1327642684.98385.YahooMailNeo@web112013.mail.gq1.yahoo.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
 boundary="1047836954-1809160673-1327647833=:84426"

--1047836954-1809160673-1327647833=:84426
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: quoted-printable

Hi All, =0A=0AQuick update: after i looked at the dead lock trace, it looke=
d to me like an issue with mysql driver jar. As i mentioned that we are usi=
ng mysql-connector-java.3.1.12-bin.jar, and i have been seeing these bugs t=
hat are filed against something related to deadlock:=0A=0Ahttp://bugs.mysql=
.com/bug.php?id=3D18719=0Ahttp://bugs.mysql.com/bug.php?id=3D14972=0A=0APle=
ase suggest if anyone has faced such issues and the upgrade of Mysql connec=
tor jar had fixed this issue?=0A=0AThanks=0A-G=0A=0A=0A____________________=
____________=0A From: gnath <gautam_exquisite@yahoo.com>=0ATo: "users@tomca=
t.apache.org" <users@tomcat.apache.org> =0ASent: Thursday, January 26, 2012=
 9:38 PM=0ASubject: Dead lock with tomcat-jdbc.jar on Tomcat 6.0.35=0A =0AH=
ello all,=0A=0ASo we have 2 Linux servers running our application with=A0 T=
omcat-6.0.35, JDK 1.6.30. We are using:=0Atomcat-jdbc.jar (Verison 1.1.1), =
=0A=0Amysql-connector-java-3.1.12-bin.jar=0A=0AWe have 'removeAbandoned' fl=
ag to true in our configuration. We initially had commons-dbcp.jar 1.3 vers=
ion and as it gave problems, we started using tomcat-jdbc.jar. One of the s=
ervers is working normally, but we saw one issue on the second server. it h=
asn't been releasing the connections =0Aand was consistently growing slowly=
. So i collected thread dump and i =0Asaw a deadlock :=0A=0AFound one Java-=
level deadlock:=0A=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0A"catalina-exec-1":=0A=A0 waiting to lock m=
onitor 0x000000005d7944b8 (object 0x00000005bd522568, a com.mysql.jdbc.Conn=
ection),=0A=A0 which is held by "[Pool-Cleaner]:Tomcat Connection Pool[1-10=
15483951]"=0A"[Pool-Cleaner]:Tomcat Connection Pool[1-1015483951]":=0A=A0 w=
aiting to lock monitor 0x000000005dcdea28 (object 0x00000005bd659ce8, a com=
.mysql.jdbc.ResultSet),=0A=A0 which is held by "catalina-exec-1"=0A=0AJava =
stack information for the threads listed above:=0A=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=0A"catalina-exec-1":=
=0A=A0=A0=A0=A0=A0=A0=A0 at com.mysql.jdbc.Connection.getCharsetConverter(C=
onnection.java:3177)=0A=A0=A0=A0=A0=A0=A0=A0 - waiting to lock <0x00000005b=
d522568> (a com.mysql.jdbc.Connection)=0A=A0=A0=A0=A0=A0=A0=A0 at com.mysql=
.jdbc.Field.getStringFromBytes(Field.java:583)=0A=A0=A0=A0=A0=A0=A0=A0 at c=
om.mysql.jdbc.Field.getName(Field.java:487)=0A=A0=A0=A0=A0=A0=A0=A0 at com.=
mysql.jdbc.ResultSet.buildIndexMapping(ResultSet.java:593)=0A=A0=A0=A0=A0=
=A0=A0=A0 at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:926)=0A=A0=
=A0=A0=A0=A0=A0=A0 - locked <0x00000005bd659ce8> (a com.mysql.jdbc.ResultSe=
t)=0A=A0=A0=A0=A0=A0=A0=A0 at com.mysql.jdbc.ResultSet.getInt(ResultSet.jav=
a:2401)=0A=0A"[Pool-Cleaner]:Tomcat Connection Pool[1-1015483951]":=0A=A0=
=A0=A0=A0=A0=A0=A0 at com.mysql.jdbc.ResultSet.close(ResultSet.java:736)=0A=
=A0=A0=A0=A0=A0=A0=A0 - waiting to lock <0x00000005bd659ce8> (a com.mysql.j=
dbc.ResultSet)=0A=A0=A0=A0=A0=A0=A0=A0 at com.mysql.jdbc.Statement.realClos=
e(Statement.java:1606)=0A=A0=A0=A0=A0=A0=A0=A0 - locked <0x00000005bd522568=
> (a com.mysql.jdbc.Connection)=0A=A0=A0=A0=A0=A0=A0=A0 - locked <0x0000000=
5bd5e81c0> (a com.mysql.jdbc.ServerPreparedStatement)=0A=A0=A0=A0=A0=A0=A0=
=A0 at com.mysql.jdbc.PreparedStatement.realClose(PreparedStatement.java:17=
03)=0A=A0=A0=A0=A0=A0=A0=A0 at com.mysql.jdbc.ServerPreparedStatement.realC=
lose(ServerPreparedStatement.java:901)=0A=A0=A0=A0=A0=A0=A0=A0 - locked <0x=
00000005bd525ba0> (a java.lang.Object)=0A=A0=A0=A0=A0=A0=A0=A0 - locked <0x=
00000005bd522568> (a com.mysql.jdbc.Connection)=0A=A0=A0=A0=A0=A0=A0=A0 - l=
ocked <0x00000005bd5e81c0> (a com.mysql.jdbc.ServerPreparedStatement)=0A=A0=
=A0=A0=A0=A0=A0=A0 at com.mysql.jdbc.Connection.closeAllOpenStatements(Conn=
ection.java:2126)=0A=A0=A0=A0=A0=A0=A0=A0 at com.mysql.jdbc.Connection.real=
Close(Connection.java:4422)=0A=A0=A0=A0=A0=A0=A0=A0 at com.mysql.jdbc.Conne=
ction.close(Connection.java:2098)=0A=A0=A0=A0=A0=A0=A0=A0 - locked <0x00000=
005bd522568> (a com.mysql.jdbc.Connection)=0A=A0=A0=A0=A0=A0=A0=A0 at org.a=
pache.tomcat.jdbc.pool.PooledConnection.disconnect(PooledConnection.java:32=
0)=0A=0A=0A=0APlease help us on this. Could it be a problem with tomcat-jdb=
c.jar? What should be our next steps? I have read some article saying tomca=
t-jdbc.jar would give better performance than commons dbcp pool.=0A=0A=0ATh=
anks
--1047836954-1809160673-1327647833=:84426--