David created NIFI-8249:
---------------------------
Summary: ExecuteSQLRecord "administratively yields" when fetch
size < query partition size when an SQLException is thrown
Key: NIFI-8249
URL: https://issues.apache.org/jira/browse/NIFI-8249
Project: Apache NiFi
Issue Type: Bug
Components: Core Framework
Affects Versions: 1.11.4
Reporter: David
When ExecuteSQLRecord executes a query with a partition size > the fetch size
and one or more of the fetches throws an SQLException, the exception appears to
get "swallowed" and a more general "IOException: Could not obtain next record
from ResultSet: routing to failure" in addition to a "transfer relationship not
specified;Processor Administratively Yielded for 1 sec" error is thrown.
The problematic query/flowfile gets put back into the incoming queue and will
continue to fail infinitely until it is manually removed from the queue.
If the fetch size >= to the query partition size, the exact SQL error message
is thrown and the flowfile gets routed to the failure queue.
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
