Re: Trying to chase down "too many connection" problems with DB

2018-03-24 Thread Shawn Heisey
On 3/24/2018 5:04 PM, Mark Thomas wrote: Regarding your configuration: Generally, that looks OK but I'd strongly recommend that you use "autoReconnect=false" in the URL. autoReconnect is known to be problematic with connection pools. The removeAbandonedTimeout looks low but if all the queries

Re: Trying to chase down "too many connection" problems with DB

2018-03-24 Thread Shawn Heisey
On 3/24/2018 5:04 PM, Mark Thomas wrote: There are two pools available. org.apache.tomcat.jdbc.pool.DataSourceFactory is a different pool developed in the Tomcat project (generally called JDBC pool). OK, so that means that the currently active config is using dbcp.  The *new* config that I'

Re: Connection closed error and certificateVerification="required"

2018-03-24 Thread Mark Thomas
On 23/03/18 15:00, Richard Tearle wrote: > On 22 March 2018 at 23:06, Mark Thomas wrote: >> On 22/03/18 15:27, Richard Tearle wrote: >>> On 22 March 2018 at 14:49, Mark Thomas wrote: >> >> >> >> OK. Time to think about this. NIO + JSSE works whereas NIO + OpenSSL >> doesn't with the same configu

Re: Trying to chase down "too many connection" problems with DB

2018-03-24 Thread Mark Thomas
On 24/03/18 22:28, Shawn Heisey wrote: > The factory we have now is > "org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory".  The factory in > the documentation, and what I put in the configuration I'm building, is > "org.apache.tomcat.jdbc.pool.DataSourceFactory". These are both in the > tomcat p

Re: Trying to chase down "too many connection" problems with DB

2018-03-24 Thread Shawn Heisey
On 3/24/2018 3:34 PM, Christopher Schultz wrote: Before we go too far, you have said: 1. You have 5 prod servers 2. They have several pools defined 3. The above is an example of a defined pool Just above, that configuration says maxActive=60. 5 * 60 = 300 connections. And that's just for one po

Re: Tomcat stopped and Debug can't be done in Eclipse

2018-03-24 Thread Konstantin Kolinko
> > Thanks Konstantin for giving me quite a clear detail on how to do the actual > debugging. > > The thing is that I am constantly getting 404 with certain occasion able to > get the tutorRegister page being displayed so I think there is still > something not quite right in the setting or somet

Re: Trying to chase down "too many connection" problems with DB

2018-03-24 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Shawn, On 3/24/18 12:08 AM, Shawn Heisey wrote: > This message is long. Lots of details, a fair amount of history. Thanks for the back-story and the configurations. It really helps explain what is going on. > Here's a redacted configuration that

Re: Trying to chase down "too many connection" problems with DB

2018-03-24 Thread Shawn Heisey
On 3/24/2018 5:36 AM, Filippo Machi wrote: Hello Shawn, about this question, are you sure that none of the webapps running on those tomcats are connecting to the database without using the pools configured in the context.xml? Creating other pools or performing direct connections? That could expla

Re: Tomcat stopped and Debug can't be done in Eclipse

2018-03-24 Thread Karen Goh
On Sat, 3/17/18, Konstantin Kolinko wrote: Subject: Re: Tomcat stopped and Debug can't be done in Eclipse To: "Tomcat Users List" Date: Saturday, March 17, 2018, 10:25 PM /Hi! 2018-03-17 10:11 GMT+03:00 Karen Goh : > > I have added this in

Re: Trying to chase down "too many connection" problems with DB

2018-03-24 Thread Filippo Machi
*1) I think this is the really burning question in my mind: Why is the server opening NEW connections when there are dozens of them already open? Does this mean that (as I suspect) all those connections are abandoned? If so, why are they not getting cleaned up, when we have removeAbandoned set to