[
https://issues.apache.org/jira/browse/DERBY-2549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12489826
]
Kurt Huwig commented on DERBY-2549:
-----------------------------------
I digged somehow deeper into this issue: I dropped all other tables and dropped
the index of the table; there is only the primary key left. I replaced all
values by '' and still the problem appeared. Then I tried to replace all values
with 'xxxx' of the same size; after 6857 successful row updates, this happened:
Exception in thread "main" org.apache.derby.shared.common.sanity.AssertFailure:
ASSERT FAILED statementContext is not expected to equal statementContexts[0]
at
org.apache.derby.shared.common.sanity.SanityManager.ASSERT(SanityManager.java:120)
at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.popStatementContext(GenericLanguageConnectionContext.java:2095)
at
org.apache.derby.impl.jdbc.EmbedResultSet.updateRow(EmbedResultSet.java:3773)
table DDL is:
CREATE TABLE journal(
ID VARCHAR(20) PRIMARY KEY default '' NOT NULL,
IP VARCHAR(45) default '' NOT NULL,
SENDER VARCHAR(32000) default '' NOT NULL,
RECIPIENT VARCHAR(32000) default '' NOT NULL,
MAILSENDER VARCHAR(32000) default '' NOT NULL,
MAILFROM VARCHAR(32000) default '' NOT NULL,
MAILTO VARCHAR(32000) default '' NOT NULL,
CC VARCHAR(32000) default '' NOT NULL,
BCC VARCHAR(32000) default '' NOT NULL,
REPLYTO VARCHAR(32000) default '' NOT NULL,
MAILDATE TIMESTAMP default '0001-01-01 00:00:00',
RECEIVEDDATE TIMESTAMP default '0001-01-01 00:00:00' NOT NULL,
SUBJECT VARCHAR(32000) default '' NOT NULL,
TOTALLENGTH BIGINT default 0 NOT NULL,
ATTACHMENTS VARCHAR(32000) default '' NOT NULL,
SPAMSCORE DOUBLE NOT NULL,
STATUS VARCHAR(11) default 'aborted' NOT NULL,
REASON VARCHAR(32000) NOT NULL);
CREATE INDEX journal_receiveddate_desc ON journal(receiveddate DESC);
FYI, I compiled Derby from the current SVN 10.2 branch and added
"line,vars,source" as debug options so that I can see where the issue happens.
And it is a "sane" build.
> ArrayIndexOutOfBoundsException in SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE
> -------------------------------------------------------------------------
>
> Key: DERBY-2549
> URL: https://issues.apache.org/jira/browse/DERBY-2549
> Project: Derby
> Issue Type: Bug
> Components: Store
> Affects Versions: 10.2.2.0
> Environment: Linux 2.6.x, JRE 1.5.0_b7
> Reporter: Kurt Huwig
> Attachments: DerbyDiskSpaceDiag.java
>
>
> I am doing this in my code:
> CALL SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE('SPONTS','" +
> "journal".toUpperCase(Locale.US) + "',1,1,1)")
> ("journal" is actually a String-variable, but I replaced it here for easier
> understanding)
> Sometime - not always - I am getting this exception:
> java.sql.SQLException: The exception
> 'java.lang.ArrayIndexOutOfBoundsException: 100' was thrown while evaluating
> an expression. SQLSTATE: XJ001:
> Java exception: '100: java.lang.ArrayIndexOutOfBoundsException'.
> at
> org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown Source)
> at org.apache.derby.client.am.SqlException.getSQLException(Unknown
> Source)
> at org.apache.derby.client.am.Statement.execute(Unknown Source)
> [...]
> Caused by: org.apache.derby.client.am.SqlException: The exception
> 'java.lang.ArrayIndexOutOfBoundsException: 100' was thrown while evaluating
> an expression.
> SQLSTATE: XJ001: Java exception: '100:
> java.lang.ArrayIndexOutOfBoundsException'.
> at org.apache.derby.client.am.Statement.completeExecute(Unknown
> Source)
> at
> org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
> Source)
> at
> org.apache.derby.client.net.NetStatementReply.readExecuteCall(Unknown Source)
> at org.apache.derby.client.net.StatementReply.readExecuteCall(Unknown
> Source)
> at org.apache.derby.client.net.NetStatement.readExecuteCall_(Unknown
> Source)
> at org.apache.derby.client.am.Statement.readExecuteCall(Unknown
> Source)
> at org.apache.derby.client.am.Statement.flowExecute(Unknown Source)
> at org.apache.derby.client.am.Statement.executeX(Unknown Source)
> ... 12 more
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
