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 (nike.apache.org: domain of pid@pidster.com designates
 74.125.82.173 as permitted sender)
Message-ID: <4F22CF6E.1030801@pidster.com>
Date: Fri, 27 Jan 2012 16:23:10 +0000
From: Pid <pid@pidster.com>
Organization: Pidster Inc
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7;
 rv:9.0) Gecko/20111222 Thunderbird/9.0.1
MIME-Version: 1.0
To: Tomcat Users List <users@tomcat.apache.org>
Subject: Re: Dead lock with tomcat-jdbc.jar on Tomcat 6.0.35
References: <1327642684.98385.YahooMailNeo@web112013.mail.gq1.yahoo.com>
 <1327647833.84426.YahooMailNeo@web112008.mail.gq1.yahoo.com>
 <8628400722563298381@unknownmsgid>
 <1327674345.28866.YahooMailNeo@web112015.mail.gq1.yahoo.com>
In-Reply-To: <1327674345.28866.YahooMailNeo@web112015.mail.gq1.yahoo.com>
OpenPGP: id=62590808
Content-Type: multipart/signed; micalg=pgp-sha512;
 protocol="application/pgp-signature";
 boundary="------------enigB7A86CBB52B8A9DA1FB8E9EB"

--------------enigB7A86CBB52B8A9DA1FB8E9EB
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

On 27/01/2012 14:25, gnath wrote:
> We have Mysql 5.0.
> What version should be stable enough to not run into these issues for m=
y Mysql version? Please let me know.

A version compatible with 5.0 probably so as documented on the MySQL
site - I remember using a v5 version of that driver, I think.

Don't be lazy, go read it up yourself if you're not sure.  It took me 10
seconds to find:

 http://dev.mysql.com/downloads/connector/j/


p


> Thanks
> -G
>=20
>=20
>=20
> ________________________________
>  From: Pid * <pid@pidster.com>
> To: Tomcat Users List <users@tomcat.apache.org>=20
> Sent: Friday, January 27, 2012 1:02 AM
> Subject: Re: Dead lock with tomcat-jdbc.jar on Tomcat 6.0.35
> =20
> On 27 Jan 2012, at 07:04, gnath <gautam_exquisite@yahoo.com> wrote:
>=20
>> Hi All,
>>
>> Quick update: after i looked at the dead lock trace, it looked to me l=
ike an issue with mysql driver jar. As i mentioned that we are using mysq=
l-connector-java.3.1.12-bin.jar, and i have been seeing these bugs that a=
re filed against something related to deadlock:
>>
>> http://bugs.mysql.com/bug.php?id=3D18719
>> http://bugs.mysql.com/bug.php?id=3D14972
>>
>> Please suggest if anyone has faced such issues and the upgrade of Mysq=
l connector jar had fixed this issue?
>=20
> That's a really old driver version. What version of MySQL are you using=
?
>=20
>=20
> p
>=20
>=20
>=20
>=20
>>
>> Thanks
>> -G
>>
>>
>> ________________________________
>> From: gnath <gautam_exquisite@yahoo.com>
>> To: "users@tomcat.apache.org" <users@tomcat.apache.org>
>> Sent: Thursday, January 26, 2012 9:38 PM
>> Subject: Dead lock with tomcat-jdbc.jar on Tomcat 6.0.35
>>
>> Hello all,
>>
>> So we have 2 Linux servers running our application with  Tomcat-6.0.35=
, JDK 1.6.30. We are using:
>> tomcat-jdbc.jar (Verison 1.1.1),
>>
>> mysql-connector-java-3.1.12-bin.jar
>>
>> We have 'removeAbandoned' flag to true in our configuration. We initia=
lly had commons-dbcp.jar 1.3 version and as it gave problems, we started =
using tomcat-jdbc.jar. One of the servers is working normally, but we saw=
 one issue on the second server. it hasn't been releasing the connections=

>> and was consistently growing slowly. So i collected thread dump and i
>> saw a deadlock :
>>
>> Found one Java-level deadlock:
>> =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
>> "catalina-exec-1":
>>    waiting to lock monitor 0x000000005d7944b8 (object 0x00000005bd5225=
68, a com.mysql.jdbc.Connection),
>>    which is held by "[Pool-Cleaner]:Tomcat Connection Pool[1-101548395=
1]"
>> "[Pool-Cleaner]:Tomcat Connection Pool[1-1015483951]":
>>    waiting to lock monitor 0x000000005dcdea28 (object 0x00000005bd659c=
e8, a com.mysql.jdbc.ResultSet),
>>    which is held by "catalina-exec-1"
>>
>> Java stack information for the threads listed above:
>> =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
>> "catalina-exec-1":
>>          at com.mysql.jdbc.Connection.getCharsetConverter(Connection.j=
ava:3177)
>>          - waiting to lock <0x00000005bd522568> (a com.mysql.jdbc.Conn=
ection)
>>          at com.mysql.jdbc.Field.getStringFromBytes(Field.java:583)
>>          at com.mysql.jdbc.Field.getName(Field.java:487)
>>          at com.mysql.jdbc.ResultSet.buildIndexMapping(ResultSet.java:=
593)
>>          at com.mysql.jdbc.ResultSet.findColumn(ResultSet.java:926)
>>          - locked <0x00000005bd659ce8> (a com.mysql.jdbc.ResultSet)
>>          at com.mysql.jdbc.ResultSet.getInt(ResultSet.java:2401)
>>
>> "[Pool-Cleaner]:Tomcat Connection Pool[1-1015483951]":
>>          at com.mysql.jdbc.ResultSet.close(ResultSet.java:736)
>>          - waiting to lock <0x00000005bd659ce8> (a com.mysql.jdbc.Resu=
ltSet)
>>          at com.mysql.jdbc.Statement.realClose(Statement.java:1606)
>>          - locked <0x00000005bd522568> (a com.mysql.jdbc.Connection)
>>          - locked <0x00000005bd5e81c0> (a com.mysql.jdbc.ServerPrepare=
dStatement)
>>          at com.mysql.jdbc.PreparedStatement.realClose(PreparedStateme=
nt.java:1703)
>>          at com.mysql.jdbc.ServerPreparedStatement.realClose(ServerPre=
paredStatement.java:901)
>>          - locked <0x00000005bd525ba0> (a java.lang.Object)
>>          - locked <0x00000005bd522568> (a com.mysql.jdbc.Connection)
>>          - locked <0x00000005bd5e81c0> (a com.mysql.jdbc.ServerPrepare=
dStatement)
>>          at com.mysql.jdbc.Connection.closeAllOpenStatements(Connectio=
n.java:2126)
>>          at com.mysql.jdbc.Connection.realClose(Connection.java:4422)
>>          at com.mysql.jdbc.Connection.close(Connection.java:2098)
>>          - locked <0x00000005bd522568> (a com.mysql.jdbc.Connection)
>>          at org.apache.tomcat.jdbc.pool.PooledConnection.disconnect(Po=
oledConnection.java:320)
>>
>>
>>
>> Please help us on this. Could it be a problem with tomcat-jdbc.jar? Wh=
at should be our next steps? I have read some article saying tomcat-jdbc.=
jar would give better performance than commons dbcp pool.
>>
>>
>> Thanks
>=20
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org


--=20

[key:62590808]


--------------enigB7A86CBB52B8A9DA1FB8E9EB
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG/MacGPG2 v2.0.17 (Darwin)
Comment: GPGTools - http://gpgtools.org
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQIcBAEBCgAGBQJPIs9yAAoJEGoM2OGpOvr9ae4QAKted5zuB+fZ/7JjhV7CzQfi
17r4ZryQiLNLQdPQUMeQCwUZVSuSx+v5pLjTxALLC5KmiM3abo26CLmuMeSJEcfz
p/hum3UjrvQsl/wgElYVOVFjWvqyzRV7BLp8O3vh/5ozonhWG9oU0uY3yOj2Drdj
1qG7v9FD+q0/3ELn6ExnWZaRdkGug7kzlq2p2PCm4mJfO1nJPXA0tOW09lHH0ltJ
NXgVzwRk1t3/KkLgb9GNHSO/rMiH4afAYTXXXGysh816vlQOYwY5+82SenkJ8j3w
pvy8cjlEzWSC0N9+QaTibP+LNYh3YJksmJs4glTsGCsEIPWR79gmacwuIMWUegMs
KVTuWNP5hWjX9DfE5S8esoKsnlkWX+OAPRKPaTsJrWOgQKerEpUZjE7zzkJWyHZF
/wpOYxwbtF4Hl+23xnEkhzv/IX3dICb3hrHgvo9Gp8sM7kGuDEkOndE6i534AaE2
P7zfUF/90ZG+reQpjm6eLAQEIoTFYtHWS93xtTpMpLKTvm2+yX6gLeYd7RlQJ71I
ZhLryPG3k0UGlLt/8Lcs4ki90O9fEJ+Ie7fEh2BK6rXzUeStYDH1cHCSq5qLeU6f
YgsQdX7LEGZx4WHy58C90RCP/46Z+R0E+3tR+YSbX30XSkt85E4zQpVV0RbVTFRU
bjWuhvPC+QapSkuF0FCj
=n9ee
-----END PGP SIGNATURE-----

--------------enigB7A86CBB52B8A9DA1FB8E9EB--