db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Kurt Huwig (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2549) ArrayIndexOutOfBoundsException in SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE
Date Wed, 18 Apr 2007 17:30:15 GMT

    [ 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.


Mime
View raw message