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)