You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2014/04/25 15:48:14 UTC
[jira] [Updated] (DERBY-6553) Sequence generator makes CREATE
TRIGGER fail with internal error
[ https://issues.apache.org/jira/browse/DERBY-6553?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Knut Anders Hatlen updated DERBY-6553:
--------------------------------------
Attachment: derby.log
I only see this error with a debug build of 10.10. It doesn't seem to fail in production builds.
Attaching derby.log from a run of the second script against db-derby-10.10.2.0-lib-debug. If I read it correctly, the rollback command first get a "too much contention" error, then an assert failure during cleanup (ASSERT FAILED Number of DDL Users is <= 0 when finishing a transaction), and finally the internal error reported by ij.
Although the reported error is not an assert failure, it is only raised in debug builds:
{code:title=impl.store.raw.xact.Xact.abort()}
if (SanityManager.DEBUG)
{
// Only global transaction is allowed to abort a closed
// transaction.
if (!sanityCheck_xaclosed)
{
throw StandardException.newException(
SQLState.XACT_PROTOCOL_VIOLATION_DETAILED,
toInternalDetailString());
}
}
{code}
> Sequence generator makes CREATE TRIGGER fail with internal error
> ----------------------------------------------------------------
>
> Key: DERBY-6553
> URL: https://issues.apache.org/jira/browse/DERBY-6553
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.11.0.0
> Reporter: Knut Anders Hatlen
> Attachments: derby.log
>
>
> I'm seeing this on trunk:
> {noformat}
> 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
> {noformat}
--
This message was sent by Atlassian JIRA
(v6.2#6252)