Error: "Connection Pool Exhausted Exception", Unable to login to Enforce console: Database

Products

• Data Loss Prevention
• Data Loss Prevention Enforce

Issue/Introduction

Unable to login to the Enforce console due to Database connection pool exhausted errors

Errors seen in the localhost log:

Database connection failed

Failed to obtain DB connection 

A connection could not be obtained from the pool

DatabaseConnectionPoolExhaustedException

Other entries in the localhost log:

Unknown exception while processing user lockout event

LockManagerConnectionException

PersistenceBrokerException during the execution of the query: Used ConnectionManager instance could not obtain a connection

Cause

DB issues are causing lockout events and connections are not being released until the connection pool is exhausted.

 

Resolution

A reboot the Enforce server clears out Java, Memory, and all connections allowing new connections to be made to the Database.