[
https://issues.apache.org/jira/browse/NIFI-1931?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17830658#comment-17830658
]
ASF subversion and git services commented on NIFI-1931:
-------------------------------------------------------
Commit 08ff54f5fb712d01f372fd25a2d904d605e271ba in nifi's branch
refs/heads/main from Jim Steinebrey
[ https://gitbox.apache.org/repos/asf?p=nifi.git;h=08ff54f5fb ]
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 Added automated test to check the Auto Commit customValidate error
message.
NIFI-1931 remove clearDefaultValue() because it is not needed since required =
false a;ready defaults it to null.
This closes #8534
Signed-off-by: Matt Burgess <[email protected]>
> 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
> Fix For: 1.26.0
>
> Time Spent: 1h 20m
> 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)
