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

Too much contention followed by assert failure when accessing sequence in transaction that created it

    XMLWordPrintableJSON

Details

    • Blocker
    • Repro attached

    Description

      ij version 10.11
      ij> connect 'jdbc:derby:memory:db;create=true' as c1;
      ij> autocommit off;
      ij> create sequence seq;
      0 rows inserted/updated/deleted
      ij> values next value for seq;
      1          
      -----------
      ERROR X0Y84: Too much contention on sequence SEQ. This is probably caused by an uncommitted scan of the SYS.SYSSEQUENCES catalog. Do not query this catalog directly. Instead, use the SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE function to view the current value of a query generator.
      ij> rollback;
      ERROR 08003: No current connection.
      ij> connect 'jdbc:derby:memory:db' as c2;
      ij(C2)> autocommit off;
      ij(C2)> create sequence seq;
      0 rows inserted/updated/deleted
      ij(C2)> values next value for seq;
      1          
      -----------
      ERROR 38000: The exception 'org.apache.derby.shared.common.sanity.AssertFailure: ASSERT FAILED Identity being changed on a live cacheable. Old uuidString = 0ddd00a9-0145-98ba-79df-000007d88b08' was thrown while evaluating an expression.
      ERROR XJ001: Java exception: 'ASSERT FAILED Identity being changed on a live cacheable. Old uuidString = 0ddd00a9-0145-98ba-79df-000007d88b08: org.apache.derby.shared.common.sanity.AssertFailure'.
      

      Attachments

        1. derby-6554-02-ag-raiseSelfDeadlockAlways.diff
          25 kB
          Richard N. Hillegas
        2. derby-6554-02-af-askToRaiseSelfDeadlock.diff
          56 kB
          Richard N. Hillegas
        3. derby-6554-02-ae-selfDeadlock_sps_compress.diff
          25 kB
          Richard N. Hillegas
        4. derby-6554-02-ac-selfDeadlock.diff
          22 kB
          Richard N. Hillegas
        5. D6554_2.java
          6 kB
          Richard N. Hillegas
        6. derby-6554-02-ab-selfDeadlock.diff
          21 kB
          Richard N. Hillegas
        7. derby-6554-02-aa-selfDeadlock.diff
          21 kB
          Richard N. Hillegas
        8. derby-6554-01-ad-bugfixes.diff
          10 kB
          Richard N. Hillegas
        9. derby-6554-01-ac-useCreationTransaction.diff
          21 kB
          Richard N. Hillegas
        10. derby-6554-01-ab-useCreationTransaction.diff
          11 kB
          Richard N. Hillegas
        11. D6554.java
          0.9 kB
          Knut Anders Hatlen
        12. derby-6554-01-aa-useCreationTransaction.diff
          10 kB
          Richard N. Hillegas

        Issue Links

          Activity

            People

              Unassigned Unassigned
              knutanders Knut Anders Hatlen
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: