[
https://issues.apache.org/jira/browse/DERBY-6553?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13980912#comment-13980912
]
Knut Anders Hatlen commented on DERBY-6553:
-------------------------------------------
I'm able to reproduce this error outside of a trigger as well:
{noformat}
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> commit;
ij> values next value for seq;
1
-----------
-2147483648
1 row selected
ij> create sequence seq;
ERROR X0Y68: Sequence 'SEQ' already exists.
ij> rollback;
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 variant is reproducible on head of 10.10 too.
> 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
>
> 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)
