Uploaded image for project: 'Apache NiFi'
  1. Apache NiFi
  2. NIFI-5789

DBCPConnectionPool controller service always leaves one connection open

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Resolved
    • Major
    • Resolution: Fixed
    • 1.8.0
    • 1.9.0
    • Extensions
    • Linux, OpenJDK 8, jTDS 1.3.1, MS SQL Server 2016

    Description

      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.

      Attachments

        Issue Links

          is caused by

          Improvement - An improvement or enhancement to an existing feature or task. NIFI-5790 DBCPConnectionPool configuration should expose underlying connection idle and eviction configuration

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              colindean Colin Dean
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: