Re: Occasional long wait for a JDBC connection

2015-01-14 Thread Filip Hanik
The timeout happens in your SocketRead, this is configurable (default is forever) http://dev.mysql.com/doc/connector-j/en/connector-j-reference-configuration-properties.html what appears to be happening is that somewhere there isn't a reset packet sent from the server to the JDBC driver. Setting a

Re: Occasional long wait for a JDBC connection

2015-01-14 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Darren, On 1/13/15 11:32 PM, Darren Davis wrote: > On Tue, Jan 13, 2015 at 8:39 PM, Christopher Schultz < > ch...@christopherschultz.net> wrote: > > Darren, > > (Sorry... just had to remove that monstrous stack trace...) > > On 1/13/15 5:04 PM,

Re: Occasional long wait for a JDBC connection

2015-01-13 Thread Darren Davis
On Tue, Jan 13, 2015 at 8:39 PM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Darren, > > (Sorry... just had to remove that monstrous stack trace...) > > On 1/13/15 5:04 PM, Darren Davis wrote: > > Hi Christopher. Yes, we've tr

Re: Occasional long wait for a JDBC connection

2015-01-13 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Darren, (Sorry... just had to remove that monstrous stack trace...) On 1/13/15 5:04 PM, Darren Davis wrote: > Hi Christopher. Yes, we've tried a show process list and can find > no evidence of the validation query running on mysql. Strange. Maybe

Re: Occasional long wait for a JDBC connection

2015-01-13 Thread Darren Davis
On Tue, Jan 13, 2015 at 2:33 PM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Darren, > > On 1/13/15 1:04 PM, Christopher Schultz wrote: > > On 1/13/15 11:49 AM, Darren Davis wrote: > >> The problem occurred again this morning.

Re: Occasional long wait for a JDBC connection

2015-01-13 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Darren, On 1/13/15 1:04 PM, Christopher Schultz wrote: > On 1/13/15 11:49 AM, Darren Davis wrote: >> The problem occurred again this morning. I was able to generate >> a thread dump and narrow down the source of our problem to >> tomcat thread 23.

RE: Occasional long wait for a JDBC connection

2015-01-13 Thread MWick
> From: Christopher Schultz [mailto:ch...@christopherschultz.net] > Sent: Tuesday, January 13, 2015 1:05 PM > To: Tomcat Users List > Subject: Re: Occasional long wait for a JDBC connection > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Darren, > >

Re: Occasional long wait for a JDBC connection

2015-01-13 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Darren, On 1/13/15 11:49 AM, Darren Davis wrote: > The problem occurred again this morning. I was able to generate a > thread dump and narrow down the source of our problem to tomcat > thread 23. > >> From 8:45:51,397 to 09:01:19,083, it was stuck

Re: Occasional long wait for a JDBC connection

2015-01-13 Thread Daniel Mikusa
On Tue, Jan 13, 2015 at 11:49 AM, Darren Davis wrote: First thing, please don't top post. The convention followed on this list is to either reply inline, like this, or reply at the bottom. The problem occurred again this morning. I was able to generate a thread > dump and narrow down the sourc

Re: Occasional long wait for a JDBC connection

2015-01-13 Thread Darren Davis
The problem occurred again this morning. I was able to generate a thread dump and narrow down the source of our problem to tomcat thread 23. >From 8:45:51,397 to 09:01:19,083, it was stuck in the validate check for a newly instantiated connection: I ran the thread dump several times during this

Re: Occasional long wait for a JDBC connection

2015-01-13 Thread Daniel Mikusa
On Tue, Jan 13, 2015 at 9:51 AM, Darren Davis wrote: > Recently we deployed our production application on a Tomcat 8.0.14 web > server. We are using the Tomcat JDBC Connection pool against MySQL 5. Our > web application uses Spring (3.2.11.RELEASE) /Hibernate (3.6.10.Final) for > transaction ma