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

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


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


      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. _cpds_0
          54 kB
          Lily Wei
        3. TestConnReuse.java
          1 kB
          Lily Wei
        4. DERBY-4343-testcase.diff
          3 kB
          Lily Wei
        5. DERBY-4343-2-testcase.diff
          3 kB
          Lily Wei
        6. DERBY-4343-3-testcase.diff
          3 kB
          Lily Wei
        7. DERBY-4343-4-trunk.diff
          3 kB
          Lily Wei

          Issue Links



              • Assignee:
                lilywei Lily Wei
                kmarsden Kathey Marsden
              • Votes:
                0 Vote for this issue
                0 Start watching this issue


                • Created: