[DERBY-6761] Closing resultset after retrieving a large > 32k value lob does not release locks

• Type: Bug
• Status: Closed
• Priority: Critical
• Resolution: Not A Problem
• Affects Version/s: 10.10.2.0, 10.11.1.1
• Component/s: Network Server
• Environment: Windows 8.1, Windows 7, jdk 8
• Bug behavior facts: Performance, Seen in production
• Assignee: Unassigned
• Reporter: Karl Griesser
• Created: 13/Oct/14 18:04
• Updated: 14/Oct/14 11:27
• Resolved: 14/Oct/14 11:27

Description

Same issue as in https://issues.apache.org/jira/browse/DERBY-2892 but seems to have made it into 10.0.2.0

I've create a simple java that
*) creates a database + table.
*) inserts data (first round 10k blob)
*) select with close rs and close statement
*) prints locks
*) inserts data (first round > 32k blob)
*) select with close rs and close statement
*) prints locks

In the scenario with the 32k blob the Shared Lock on the row is not released until the transaction is commited.