[JCR-2832] Crash when adding node to cluster with big journal on PSQL DB

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 2.1.2
• Fix Version/s: 2.2.2
• Component/s: clustering, jackrabbit-core
• Environment: Clustering with database journal using PSQL
• Assignee: Jukka Zitting
• Reporter: Omid Milani
• Created: 07/Dec/10 12:29
• Updated: 04/Oct/11 08:39
• Resolved: 18/Jan/11 16:17

Description

When adding a new node to a cluster with big journal on PSQL database application runs out of memory on the new node and crashes (no exception, application exits with code 137).
It's because with PSQL, when no fetchSize is specified, all the results of query are loaded into memory before being passed to application. Furthermore, specification of fetchSize only works in transactional mode and have no effect if autoCommit is true. (these are configured in ConnectionHelper)

Issue Links

• is related to: JCR-3090 setFetchSize() fails in getAllNodeIds()