Colin Dean created NIFI-5789: -------------------------------- Summary: DBCPConnectionPool controller service always leaves one connection open Key: NIFI-5789 URL: https://issues.apache.org/jira/browse/NIFI-5789 Project: Apache NiFi Issue Type: Bug Components: Extensions Affects Versions: 1.8.0 Environment: Linux, OpenJDK 8, jTDS 1.3.1, MS SQL Server 2016 Reporter: Colin Dean
Out of the box, NiFi (at least, as of 1.8.0), appears to keep open one database connection for each DBCPConnectionPool controller service enabled. I have multiple DBCPConnectionPool controller services configured to access the same server with different options, so this quickly adds up against a limited number of connections to my database server. I have a scheduled workflow that runs ~nightly. Connections need not be active except when in active use during a short window of time. -- This message was sent by Atlassian JIRA (v7.6.3#76005)