[
https://issues.apache.org/jira/browse/NIFI-1931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17830657#comment-17830657
]
ASF subversion and git services commented on NIFI-1931:
-------------------------------------------------------
Commit 15eeb1d5bc6816a76d27ad023795b5ac5368a55e in nifi's branch
refs/heads/support/nifi-1.x from Jim Steinebrey
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=15eeb1d5bc ]
NIFI-1931: Add auto commit property to QueryDatabaseTable and
QueryDatabaseTable processors to allow disabling auto commit so PostgreSQL
Fetch Size will work
NIFI-1931 Add proper default value for auto commit (false) to
PostgreSQLDatabaseAdapter to allow FETCH_SIZE to be honored on reads.
NIFI-1931 Added customValidate code to check the auto commit property setting
against the db adapter's required auto commit setting and give validation error
message if they do not match.
NIFI-1931 Fix for NiFI 1.X
NIFI-1931 Added automated test to check the Auto Commit customValidate error
message.
NIFI-1931 Fix for NiFI 1.X
Signed-off-by: Matt Burgess <mattyb...@apache.org>
> 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: 40m
> 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)
