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