You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@nifi.apache.org by "Matt Burgess (Jira)" <ji...@apache.org> on 2024/03/22 16:02:00 UTC
[jira] [Updated] (NIFI-1931) QueryDatabaseTable processor; setFetchSize not working for postgres driver causing out of memory
[ https://issues.apache.org/jira/browse/NIFI-1931?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Matt Burgess updated NIFI-1931:
-------------------------------
Affects Version/s: (was: 0.6.1)
Status: Patch Available (was: Open)
> QueryDatabaseTable processor; setFetchSize not working for postgres driver causing out of memory
> ------------------------------------------------------------------------------------------------
>
> Key: NIFI-1931
> URL: https://issues.apache.org/jira/browse/NIFI-1931
> Project: Apache NiFi
> Issue Type: Bug
> Components: Core Framework
> Reporter: Paul Bormans
> Assignee: Jim Steinebrey
> Priority: Major
> Time Spent: 0.5h
> Remaining Estimate: 0h
>
> With NIFI-1691 the ability to specify the fetch size is added. However for postgres driver (or at least for postgresql-9.4.1208.jre6.jar) this seems not to be working since after some time out of memory is reported in the logs.
> See https://jdbc.postgresql.org/documentation/head/query.html also for some constraints; like auto commit needs to be set to False.
--
This message was sent by Atlassian Jira
(v8.20.10#820010)