We have had issues in the past with slowness or outages on our site and whenever this happened, c3p0 connections were usually high on one tomcat instance (>100).

Today, I noticed the count went up above 100 around the time a script performed a few updates/inserts on some large tables (1 of the tables > 20 GBs and 2nd table > 5 GBs).

I created a tomcat thread dump to see if anything was blocking but nothing looked like it was. However, it is very unusual with the lower traffic this time of year for us for c3p0 connections to jump that high.

I believe something spiked those c3p0 connections and whatever that is, is causing us issues when it does.

Any thoughts?