eric twilegar created NIFI-5607:
-----------------------------------
Summary: 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
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.
What is odd is that the database connection is not going through the VPN, but
DNS is. The db connection is actually through an SSH tunnel. I'm using ip
addresses though, so I'm not really sure why the networking would even be
disrupted, but it sure does. Maybe its just a linux thing on the network stack
with openvpn. Either way Nifi isn't handling some type of networking issue in
there.
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)
