Carlos Manuel António Fernandes created NIFI-2381:
-----------------------------------------------------

             Summary: Connection Pooling Service -Drop invalid connections and 
create new ones 
                 Key: NIFI-2381
                 URL: https://issues.apache.org/jira/browse/NIFI-2381
             Project: Apache NiFi
          Issue Type: Improvement
          Components: Core Framework
    Affects Versions: 0.7.0
         Environment: all
            Reporter: Carlos Manuel António Fernandes


The connections  in Connection Pooling Service become invalid for several 
reasons : session timeout, firewalls block idle connections, outages of backend 
server, etc.

In the current niif releases this connections rest in the pool as good  but 
when the user use one of them is triggered an errror  for the backend database. 
Ex: org.netezza.error.NzSQLException: FATAL 1:  Connection Terminated - session 
timeout exceeded

With this improvement we pretend periodicaly to test all the connections , drop 
the invalid ,create new ones and  mantain all the pool healthy.




--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to