Derby
  1. Derby
  2. DERBY-800

derbylang/ConcurrentImplicitCreateSchema.java fails intermittently with a lock timeout

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: 10.2.1.6
    • Fix Version/s: 10.1.3.1, 10.2.1.6
    • Component/s: Test
    • Labels:
      None
    • Bug behavior facts:
      Regression Test Failure

      Description

      I have seen ConcurrentImplicitCreateSchema.java get a lock timeout periodically and it occurred in the posted sun tests for build 365391

      http://www.multinet.no/~solberg/public/Apache/Derby/testlog/CYGWIN_NT-5.2_i686-unknown/365391-derbylang_diff.txt
      (I don't know how long this link will last. Below is the diff)

                      • Diff file derbylang/derbylang/ConcurrentImplicitCreateSchema.diff
          • Start: ConcurrentImplicitCreateSchema jdk1.5.0_04 derbylang:derbylang 2006-01-02 20:03:09 ***
            2 del
            < Closed connection
            3 del
            < Test ConcurrentImplicitCreateSchema PASSED
            3 add
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:480)SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:550)SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > at org.apache.derby.impl.store.access.btree.index.B2IRowLocking3._lockScan(B2IRowLocking3.java:135)SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301)SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > at org.apache.derby.impl.store.access.btree.BTreeScan.next(BTreeScan.java:1696)SQL Exception: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requestedSQL Exception: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > at org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:441)SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getColumnDescriptorsScan(DataDictionaryImpl.java:2259)SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > SQL Exception: A lock could not be obtained within the time requested
            > ERROR 40XL1: A lock could not be obtained within the time requested
            > Closed connection
            > Test ConcurrentImplicitCreateSchema FAILED
            Test Failed.
      1. derby-800.diff
        1 kB
        Øystein Grøvlen

        Activity

        Kathey Marsden created issue -
        Øystein Grøvlen made changes -
        Field Original Value New Value
        Assignee Øystein Grøvlen [ oysteing ]
        Mike Matrigali made changes -
        Component/s Regression Test Failure [ 12310664 ]
        Priority Minor [ 4 ] Critical [ 2 ]
        Øystein Grøvlen made changes -
        Status Open [ 1 ] In Progress [ 3 ]
        Øystein Grøvlen made changes -
        Attachment derby-800.diff [ 12323230 ]
        Øystein Grøvlen made changes -
        Other Info [Patch available]
        Bernt M. Johnsen made changes -
        Status In Progress [ 3 ] Resolved [ 5 ]
        Resolution Fixed [ 1 ]
        Øystein Grøvlen made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Bernt M. Johnsen made changes -
        Resolution Fixed [ 1 ]
        Status Closed [ 6 ] Reopened [ 4 ]
        Bernt M. Johnsen made changes -
        Status Reopened [ 4 ] Closed [ 6 ]
        Fix Version/s 10.1.3.0 [ 12310616 ]
        Resolution Fixed [ 1 ]
        Fix Version/s 10.2.0.0 [ 11187 ]
        Dag H. Wanvik made changes -
        Derby Categories [Regression Test Failure]
        Dag H. Wanvik made changes -
        Component/s Regression Test Failure [ 12310664 ]
        Gavin made changes -
        Workflow jira [ 12345442 ] Default workflow, editable Closed status [ 12799310 ]

          People

          • Assignee:
            Øystein Grøvlen
            Reporter:
            Kathey Marsden
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development