Derby
  1. Derby
  2. DERBY-4343

ASSERT FAILED calling setTransactionIsolation checking isolation_ == level on pooled connection

    Details

    • Issue & fix info:
      High Value Fix, Newcomer, Patch Available, Repro attached

      Description

      For DERBY-4314, I thought I would do a little testing to understand the server round trips in various scenarios for pooled connections. So I wrote the small attached program ConnReuse.java and hit this assertion in client:

      Exception in thread "main" org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED
      at org.apache.derby.shared.common.sanity.SanityManager.ASSERT(SanityManager.java:98)
      at org.apache.derby.client.am.Connection.setTransactionIsolationX(Connection.java:987)
      at org.apache.derby.client.am.Connection.setTransactionIsolation(Connection.java:915)
      at org.apache.derby.client.am.LogicalConnection.setTransactionIsolation(LogicalConnection.java:253)
      at TestConnReuse.main(TestConnReuse.java:32)
      ---------------

      To run the program on trunk:
      java org.apache.derby.drda.NetworkServerControl start
      java TestConnReuse.

      This needs more investigation, but I thought I would go ahead and log the bug. I tried this only on trunk. I have not yet

      • Tried it on the branches.
      • Tried it with Lily's DERBY-4314 patch.
      • Tried it with embedded.
      • Tried actually doing something with the prior logical connection which might be related.
      1. TestConnReuse.java
        1 kB
        Kathey Marsden
      2. TestConnReuse.java
        1 kB
        Lily Wei
      3. DERBY-4343-testcase.diff
        3 kB
        Lily Wei
      4. DERBY-4343-4-trunk.diff
        3 kB
        Lily Wei
      5. DERBY-4343-3-testcase.diff
        3 kB
        Lily Wei
      6. DERBY-4343-2-testcase.diff
        3 kB
        Lily Wei
      7. _cpds_0
        54 kB
        Lily Wei

        Issue Links

          Activity

          Kathey Marsden created issue -
          Kathey Marsden made changes -
          Field Original Value New Value
          Link This issue relates to DERBY-4314 [ DERBY-4314 ]
          Kathey Marsden made changes -
          Attachment TestConnReuse.java [ 12415797 ]
          Kathey Marsden made changes -
          Priority Major [ 3 ] Minor [ 4 ]
          Lily Wei made changes -
          Attachment _cpds_0 [ 12415911 ]
          Attachment TestConnReuse.java [ 12415912 ]
          Lily Wei made changes -
          Assignee Lily Wei [ lilywei ]
          Lily Wei made changes -
          Attachment DERBY-4343-testcase.diff [ 12443827 ]
          Lily Wei made changes -
          Attachment DERBY-4343-2-testcase.diff [ 12444131 ]
          Lily Wei made changes -
          Attachment DERBY-4343-3-testcase.diff [ 12444139 ]
          Lily Wei made changes -
          Attachment DERBY-4343-4-trunk.diff [ 12444143 ]
          Lily Wei made changes -
          Fix Version/s 10.7.0.0 [ 12314971 ]
          Affects Version/s 10.6.1.0 [ 12313727 ]
          Issue & fix info [High Value Fix, Newcomer, Repro attached] [High Value Fix, Newcomer, Patch Available, Repro attached]
          Affects Version/s 10.5.3.1 [ 12314182 ]
          Lily Wei made changes -
          Status Open [ 1 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Lily Wei made changes -
          Link This issue is required by DERBY-4728 [ DERBY-4728 ]
          Lily Wei made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Lily Wei made changes -
          Status Reopened [ 4 ] Resolved [ 5 ]
          Resolution Fixed [ 1 ]
          Kathey Marsden made changes -
          Link This issue is required by DERBY-4728 [ DERBY-4728 ]
          Rick Hillegas made changes -
          Fix Version/s 10.7.1.1 [ 12315564 ]
          Fix Version/s 10.7.1.0 [ 12314971 ]
          Kathey Marsden made changes -
          Status Resolved [ 5 ] Closed [ 6 ]
          Kathey Marsden made changes -
          Link This issue is required by DERBY-4994 [ DERBY-4994 ]
          Kathey Marsden made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          Kathey Marsden made changes -
          Link This issue is required by DERBY-4994 [ DERBY-4994 ]
          Kathey Marsden made changes -
          Labels derby_backport_reject_10_6
          Myrna van Lunteren made changes -
          Labels derby_backport_reject_10_6 derby_backport_reject_10_5 derby_backport_reject_10_6
          Myrna van Lunteren made changes -
          Status Reopened [ 4 ] Closed [ 6 ]
          Resolution Fixed [ 1 ]
          Gavin made changes -
          Workflow jira [ 12472594 ] Default workflow, editable Closed status [ 12801219 ]

            People

            • Assignee:
              Lily Wei
              Reporter:
              Kathey Marsden
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development