Mailing-List: contact dev-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Developers List" <dev@tomcat.apache.org>
From: bugzilla@apache.org
To: dev@tomcat.apache.org
Subject: [Bug 54116] Deadlocks with mysql driver
Date: Fri, 09 Nov 2012 11:47:19 +0000
Message-ID: <bug-54116-78-8O7lPV9WD0@https.issues.apache.org/bugzilla/>
In-Reply-To: <bug-54116-78@https.issues.apache.org/bugzilla/>
References: <bug-54116-78@https.issues.apache.org/bugzilla/>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Auto-Submitted: auto-generated
MIME-Version: 1.0

https://issues.apache.org/bugzilla/show_bug.cgi?id=3D54116

--- Comment #2 from Alfredo Casado <casado.alfredo@gmail.com> ---
Thanks for your response.

Please can you answer my second question: =C2=BFif the Pool-Cleaner thread =
is
blocked how this affect the behaviour of the pool?, =C2=BFthe pool is no lo=
nger
"clean" unused connections?. If this is true the problem is really a big is=
sue
in production
 environments using tomcat+mysql.

In the first place i go to mysql driver project issue manager, i found one
report of a identical bug and following the recomendations in this issue i'm
here contacting with "my pool vendor". As you can see now i have two deadlo=
cks:
one in my production servers and the second one in this bug resolution.

As you can see in the mysql bug they insist that the pool implementation mu=
st
call abort() instead of close(). I'm not sure what are the implications of
this.

I'm not an expert in JDBC spec and in driver's or pool's implementations
details, i can't judge if the problem is in mysql driver like you say or if=
 the
problem is in pool implementations, like the mysql guy say.

I have the following options:

- go again to mysql issue manager and reopen the bug.=20
- don't use jdbc-pool (i think that others pool implementations call close =
in
the same way, the option is not using a pool at all)
- don't use mysql j/connector driver. =C2=BFis there another mysql driver
implementation i can use?

=C2=BFwhat do you recomend?

--=20
You are receiving this mail because:
You are the assignee for the bug.=

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org