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

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

    XMLWordPrintableJSON

Details

    • 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.

      Attachments

        1. TestConnReuse.java
          1 kB
          Katherine 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

            People

              lilywei Lily Wei
              kmarsden Katherine Marsden
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: