Carlos Manuel António Fernandes commented on NIFI-2381:

Toivo, i Tested with DB2 and Netezza  and i havent more broken connections 

For me this patch resolved the problem.


> 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
>            Assignee: Toivo Adams
> 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

Reply via email to