"SQLNestedException: Cannot get a connection, pool exhausted" error in tomcat log file

Products

• Data Loss Prevention Enforce

Issue/Introduction

Enforce UI is not responsive.  Unusually slow UI performance may be observed shortly before the UI becomes non-responsive.

Looking at the Tomcat logs, errors similar to the following are repeated:

MisfireHandler: Error handling misfires: Failed to obtain DB connection from data source '<DS name>': org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted

An error occured while scanning for the next trigger to fire.
org.quartz.JobPersistenceException: Failed to obtain DB connection from data source '<DS name>': org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool exhausted

Resolution

This error is often seen when the connection between the Enforce server and the DLP database is lost. Check the Incident Persister log to see if there are any common times when the DB connection is lost. This issue sometimes appears when a cold backup is performed, but the Enforce Services are not stopped before the DB is brought down. The proper method of backup is to bring down Enforce Services, then perform backup, then start Enforce Services after backup is complete.

This is usually auto-recovered, but when it's not, the solution would be to:

1. Verify that the DLP database and its listener are up and running
2. Stop, then restart the DLP services on the Enforce Server
3. Log in to Enforce UI to verify the problem is solved.