You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-dev@db.apache.org by "Karl Griesser (JIRA)" <ji...@apache.org> on 2014/10/13 20:05:33 UTC

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

Karl Griesser created DERBY-6761:
------------------------------------

             Summary: Closing resultset after retrieving a large > 32k value lob does not release locks
                 Key: DERBY-6761
                 URL: https://issues.apache.org/jira/browse/DERBY-6761
             Project: Derby
          Issue Type: Bug
          Components: Network Server
    Affects Versions: 10.11.1.1, 10.10.2.0
         Environment: Windows 8.1, Windows 7, jdk 8
            Reporter: Karl Griesser
            Priority: Critical


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.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)