Database connections leak until the system cannot obtain any more connections
Description
We found this on demo because it periodically hangs. Looking at a thread dump we determined that all of the threads are waiting for a database connection from the c3p0 pool but none seems to be available.
Acceptance / Success Criteria
None
Lucidchart Diagrams
Activity
Show:
Matt Brozowski August 20, 2013 at 10:38 AM
Ben and I wrote a AspectJ based database connection tracker (checked into opennms-tools) that monitors the c3p0 resource pool for allocating and deallocation connections.
After installing this on demo we found a leak on the the support/about.jsp page and fixed it. Not certain there are no more leaks but I am going to close this since we did find one.
We will leave this installed and see if we have any further hangs in case more leaks exist
We found this on demo because it periodically hangs. Looking at a thread dump we determined that all of the threads are waiting for a database connection from the c3p0 pool but none seems to be available.