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

Sequence generator makes CREATE TRIGGER fail with internal error

    XMLWordPrintableJSON

Details

    • Repro attached
    • Regression

    Description

      I'm seeing this on trunk:

      ij version 10.11
      ij> connect 'jdbc:derby:memory:db;create=true';
      ij> create table t1(x int, y int, z int);
      0 rows inserted/updated/deleted
      ij> create table t2(x int, y int, z int);
      0 rows inserted/updated/deleted
      ij> create sequence seq;
      0 rows inserted/updated/deleted
      ij> values next value for seq;
      1          
      -----------
      -2147483648
      
      1 row selected
      ij> create trigger tr1 after insert on t1 insert into t2(x) values (next value for seq);
      ERROR 40XT8: An internal error was identified by RawStore module. Internal state detail from the transaction is as follows: savedEndStatus = 0
      needSync = false
      justCreated = false
      myGlobalId = null
      myId = null
      state = 0
      inComplete = null
      seenUpdates = false
      inPostCommitProcessing = false
      logStart = null
      logLast = null
      recoveryTransaction = false
      postCompleteMode = false
      sanityCheck_xaclosed = false
      transName = UserTransaction
      readOnly = false
      flush_log_on_xact_end = true
      backupBlocked = false
      dontWaitForLocks = false
      

      Attachments

        1. derby-6553-01-aa-verifyFix.diff
          2 kB
          Richard N. Hillegas
        2. derby.log
          17 kB
          Knut Anders Hatlen

        Activity

          People

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

            Dates

              Created:
              Updated:
              Resolved: