Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <8466651.1176917415674.JavaMail.jira@brutus>
Date: Wed, 18 Apr 2007 10:30:15 -0700 (PDT)
From: "Kurt Huwig (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-2549) ArrayIndexOutOfBoundsException in
 SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE
In-Reply-To: <3641992.1176708495288.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


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