[
https://issues.apache.org/jira/browse/NIFI-5607?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16620741#comment-16620741
]
Pierre Villard commented on NIFI-5607:
--------------------------------------
Hi [~twiggy], did you set the validation query in the controller service
configuration?
> JDBC connection processors hang after network disruptions.
> ----------------------------------------------------------
>
> Key: NIFI-5607
> URL: https://issues.apache.org/jira/browse/NIFI-5607
> Project: Apache NiFi
> Issue Type: Bug
> Components: Core Framework
> Affects Versions: 1.6.0
> Reporter: eric twilegar
> Priority: Major
>
> I use a VPN connection to connect to our AWS VPC. openVPN can sometimes just
> drop the connection.
> If i'm developing a task that connects to postgres over VPN and my vpn
> connection drops any processors using the service hangs. The processors
> themselves won't stop nor the service.
> I don't see this issue on production since the networking is far more
> consistent.
> I'll take a look at the code later, as I'm sure this will be a hard ticket to
> reproduce for any developer. If I get some time maybe I'll see if I can
> reproduce it with mysql to eliminate postgres JDBC drivers as the culprit.
> I know there was some posts about the desire to "hard stop" processors and/or
> services. At the moment I have to restart the entire server.
> Thanks!
>
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
