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 15:45:15 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2549?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12489800
] 

Kurt Huwig commented on DERBY-2549:
-----------------------------------

Output from the app is

Tablename                 Type   ALLOC   FREE PSIZE   SAVE File      Size KB 
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
ATTACHMENTFILTER          TABLE      1      0  4096      0 c3c0.dat        8
  SQL070409002320120      INDEX      1      0  4096      0 c3d1.dat        8
AUTOBLACKLIST             TABLE      1      0  4096      0 c3e0.dat        8
  SQL070409002320240      INDEX      1      0  4096      0 c3f1.dat        8
CACHE                     TABLE    670      0  4096      0 c400.dat     2684
  SQL070409002320280      INDEX    596      0  4096      0 c411.dat     2388
DISINFECTIONOPTIN         TABLE      1      0  4096      0 c420.dat        8
  SQL070409002320310      INDEX      1      0  4096      0 c431.dat        8
DISPOSABLEOPTIN           TABLE      1      0  4096      0 c440.dat        8
  SQL070409002320350      INDEX      1      0  4096      0 c451.dat        8
DISPOSABLERECIPIENTS      TABLE      1      0  4096      0 c460.dat        8
  SQL070409002320380      INDEX      1      0  4096      0 c471.dat        8
DOMAINADMIN               TABLE      1      0  4096      0 c480.dat        8
  SQL070409002320410      INDEX      1      0  4096      0 c491.dat        8
ENVELOPEPOLICY            TABLE      2      0  4096      0 c4a0.dat       12
  SQL070409002320450      INDEX      1      0  4096      0 c4b1.dat        8
FETCHACCOUNT              TABLE      1      0  4096      0 c4c0.dat        8
  SQL070409002320520      INDEX      1      0  4096      0 c4d1.dat        8
FTPUSER                   TABLE      1      0  4096      0 c4e0.dat        8
  SQL070409002320570      INDEX      1      0  4096      0 c4f1.dat        8
JOURNAL                   TABLE   4710    377 32768 12353536 c500.dat   162816
  SQL070409002320610      INDEX   4619   1125  4096 4608000 c511.dat    22980
  JOURNAL_RECEIVEDDATE_DESC INDEX   5795      0  4096      0 c521.dat    23204
LOCALDOMAINS              TABLE      1      0  4096      0 c530.dat        8
  SQL070409002320700      INDEX      1      0  4096      0 c541.dat        8
MONITORPROXIES            TABLE      1      0  4096      0 c550.dat        8
  SQL070409002320730      INDEX      1      0  4096      0 c561.dat        8
RCPTREWRITE               TABLE      1      0  4096      0 c570.dat        8
  SQL070409002320780      INDEX      1      0  4096      0 c581.dat        8
RECIPIENTBACKEND          TABLE      1      0  4096      0 c590.dat        8
  SQL070409002320820      INDEX      1      0  4096      0 c5a1.dat        8
RECIPIENTKEYS             TABLE      1      0  4096      0 c5b0.dat        8
  SQL070409002320860      INDEX      1      0  4096      0 c5c1.dat        8
RECIPIENTSTATISTIC        TABLE     14      0  4096      0 c5d0.dat       60
  SQL070409002320890      INDEX     12      0  4096      0 c5e1.dat       52
REPLAYADMIN               TABLE      1      0  4096      0 c5f0.dat        8
  SQL070409002320930      INDEX      1      0  4096      0 c601.dat        8
REPLAYLOG                 TABLE      1      0 32768      0 c610.dat       64
  SQL070409002320970      INDEX      1      0  4096      0 c621.dat        8
  REPLAYLOG_RECEIVEDDATE_DESC INDEX      1      0  4096      0 c631.dat        8
STATISTICOPTIN            TABLE      1      0  4096      0 c640.dat        8
  SQL070409002321100      INDEX      1      0  4096      0 c651.dat        8
  SYSALIASES_INDEX1       INDEX      1      0  4096      0 c191.dat        8
  SYSALIASES_INDEX2       INDEX      1      0  4096      0 c1a1.dat        8
  SYSALIASES_INDEX3       INDEX      1      0  4096      0 c1b1.dat        8
SYSALIASES                TABLE      5      0  4096      0 c180.dat       24
  SYSCHECKS_INDEX1        INDEX      1      0  4096      0 c1f1.dat        8
SYSCHECKS                 TABLE      1      0  4096      0 c1e0.dat        8
  SYSCOLPERMS_INDEX1      INDEX      1      0  4096      0 c351.dat        8
  SYSCOLPERMS_INDEX2      INDEX      1      0  4096      0 c361.dat        8
  SYSCOLPERMS_INDEX3      INDEX      1      0  4096      0 c371.dat        8
SYSCOLPERMS               TABLE      1      0  4096      0 c340.dat        8
  SYSCOLUMNS_INDEX1       INDEX      7      0  4096      0 ca1.dat        32
  SYSCOLUMNS_INDEX2       INDEX      5      0  4096      0 cb1.dat        24
SYSCOLUMNS                TABLE      8      0  4096      0 c90.dat        36
  SYSCONGLOMERATES_INDEX1 INDEX      3      0  4096      0 c31.dat        16
  SYSCONGLOMERATES_INDEX2 INDEX      4      0  4096      0 c41.dat        20
  SYSCONGLOMERATES_INDEX3 INDEX      3      0  4096      0 c51.dat        16
SYSCONGLOMERATES          TABLE      7      0  4096      0 c20.dat        32
  SYSCONSTRAINTS_INDEX1   INDEX      1      0  4096      0 c101.dat        8
  SYSCONSTRAINTS_INDEX2   INDEX      1      0  4096      0 c111.dat        8
  SYSCONSTRAINTS_INDEX3   INDEX      1      0  4096      0 c121.dat        8
SYSCONSTRAINTS            TABLE      1      0  4096      0 cf0.dat         8
  SYSDEPENDS_INDEX1       INDEX      1      0  4096      0 c161.dat        8
  SYSDEPENDS_INDEX2       INDEX      1      0  4096      0 c171.dat        8
SYSDEPENDS                TABLE      1      0  4096      0 c150.dat        8
SYSDUMMY1                 TABLE      1      0  4096      0 c2f0.dat        8
  SYSFILES_INDEX1         INDEX      1      0  4096      0 c271.dat        8
  SYSFILES_INDEX2         INDEX      1      0  4096      0 c281.dat        8
SYSFILES                  TABLE      1      0  4096      0 c260.dat        8
  SYSFOREIGNKEYS_INDEX1   INDEX      1      0  4096      0 c211.dat        8
  SYSFOREIGNKEYS_INDEX2   INDEX      1      0  4096      0 c221.dat        8
SYSFOREIGNKEYS            TABLE      1      0  4096      0 c200.dat        8
  SYSKEYS_INDEX1          INDEX      1      0  4096      0 c141.dat        8
SYSKEYS                   TABLE      1      0  4096      0 c130.dat        8
  SYSROUTINEPERMS_INDEX1  INDEX      1      0  4096      0 c391.dat        8
  SYSROUTINEPERMS_INDEX2  INDEX      1      0  4096      0 c3a1.dat        8
  SYSROUTINEPERMS_INDEX3  INDEX      1      0  4096      0 c3b1.dat        8
SYSROUTINEPERMS           TABLE      1      0  4096      0 c380.dat        8
  SYSSCHEMAS_INDEX1       INDEX      1      0  4096      0 cd1.dat         8
  SYSSCHEMAS_INDEX2       INDEX      1      0  4096      0 ce1.dat         8
SYSSCHEMAS                TABLE      1      0  4096      0 cc0.dat         8
  SYSSTATEMENTS_INDEX1    INDEX      1      0  4096      0 c241.dat        8
  SYSSTATEMENTS_INDEX2    INDEX      3      0  4096      0 c251.dat       16
SYSSTATEMENTS             TABLE     25     23  4096  94208 c230.dat      196
  SYSSTATISTICS_INDEX1    INDEX      1      0  4096      0 c2e1.dat        8
SYSSTATISTICS             TABLE      1      0  4096      0 c2d0.dat        8
  SYSTABLEPERMS_INDEX1    INDEX      1      0  4096      0 c311.dat        8
  SYSTABLEPERMS_INDEX2    INDEX      1      0  4096      0 c321.dat        8
  SYSTABLEPERMS_INDEX3    INDEX      1      0  4096      0 c331.dat        8
SYSTABLEPERMS             TABLE      1      0  4096      0 c300.dat        8
  SYSTABLES_INDEX1        INDEX      1      0  4096      0 c71.dat         8
  SYSTABLES_INDEX2        INDEX      1      0  4096      0 c81.dat         8
SYSTABLES                 TABLE      2      0  4096      0 c60.dat        12
  SYSTRIGGERS_INDEX1      INDEX      1      0  4096      0 c2a1.dat        8
  SYSTRIGGERS_INDEX2      INDEX      1      0  4096      0 c2b1.dat        8
  SYSTRIGGERS_INDEX3      INDEX      1      0  4096      0 c2c1.dat        8
SYSTRIGGERS               TABLE      1      0  4096      0 c290.dat        8
  SYSVIEWS_INDEX1         INDEX      1      0  4096      0 c1d1.dat        8
SYSVIEWS                  TABLE      1      0  4096      0 c1c0.dat        8
UCEOPTIN                  TABLE      1      0  4096      0 c660.dat        8
  SQL070409002321140      INDEX      1      0  4096      0 c671.dat        8
USERS                     TABLE      1      0  4096      0 c680.dat        8
  SQL070409002321170      INDEX      1      0  4096      0 c691.dat        8
VALIDRECIPIENTS           TABLE    192      4  4096  16384 c6a0.dat      788
  SQL070409002321210      INDEX    263      0  4096      0 c6b1.dat     1056
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Total                            17030   1529   n/a 17072128 KB n/a     217200

The table is basically a log file. It is created by only adding new records and when 350.000
records are reached, the first (oldest) 50.000 entries are deleted. This is done by determining
the 50.000th element and then deleting entries with "WHERE xxx < yyy" where xxx is an order
column and yyy is the value of this column of the 50.000th element.

> 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