Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-2549

ArrayIndexOutOfBoundsException in SYSCS_UTIL.SYSCS_INPLACE_COMPRESS_TABLE

Attach filesAttach ScreenshotVotersWatch issueWatchersCreate sub-taskLinkCloneUpdate Comment AuthorReplace String in CommentUpdate Comment VisibilityDelete Comments
    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.2.2.0
    • 10.2.2.1, 10.3.1.4
    • Store
    • None
    • Linux 2.6.x, JRE 1.5.0_b7
    • Patch Available

    Description

      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

      Attachments

        1. DerbyDiskSpaceDiag.java
          10 kB
          Kristian Waagan
        2. derby-2549-v1.diff
          0.7 kB
          Kurt Huwig
        3. derby2549_v3.diff
          3 kB
          Mayuresh Nirhali
        4. derby2549_v3.diff
          3 kB
          Mayuresh Nirhali
        5. derby2549_v2.diff
          3 kB
          Mayuresh Nirhali
        6. derby2549_testv1.diff
          3 kB
          Mayuresh Nirhali
        7. derby2549_testv1.diff
          3 kB
          Mayuresh Nirhali
        8. derby2549_mikemv2.diff
          2 kB
          Mike Matrigali
        9. derby2549_mikem.diff
          2 kB
          Mike Matrigali
        10. A2549Test2.java
          1 kB
          Kurt Huwig
        11. A2549Test.java
          4 kB
          Mayuresh Nirhali
        12. 2549-histogram.png
          3 kB
          Kurt Huwig

        Activity

          This comment will be Viewable by All Users Viewable by All Users
          Cancel

          People

            mayureshnirhali Mayuresh Nirhali
            kurti Kurt Huwig
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Slack

                Issue deployment