You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "David (Jira)" <ji...@apache.org> on 2021/02/23 00:44:00 UTC
[jira] [Updated] (NIFI-8249) ExecuteSQLRecord "administratively
yields" when fetch size < query partition size when an SQLException is
thrown
[ https://issues.apache.org/jira/browse/NIFI-8249?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
David updated NIFI-8249:
------------------------
Description:
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 indefinitely 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.
was:
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.
> 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
> Priority: Major
>
> 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 indefinitely 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)