Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6761

Closing resultset after retrieving a large > 32k value lob does not release locks

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Critical
    • Resolution: Not A Problem
    • 10.10.2.0, 10.11.1.1
    • None
    • Network Server
    • None
    • Windows 8.1, Windows 7, jdk 8
    • Performance, Seen in production

    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.

      Attachments

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            Unassigned Unassigned
            Sargul Karl Griesser
            Votes:
            1 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment