[
https://issues.apache.org/jira/browse/DERBY-7151?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17695900#comment-17695900
]
Richard N. Hillegas commented on DERBY-7151:
--------------------------------------------
It would be good to see the SQL statement which is failing. If you can't find
it in derby.log, then you may need to increase the level of diagnostic logging
by adding the following system properties to the JVM boot command which starts
your application:
{noformat}
-Dderby.language.logStatementText=true -Dderby.stream.error.logSeverityLevel=0
{noformat}
> ERROR XSDA7: Restore of a serializable or SQLData object of class , attempted
> to read more data than was originally stored
> --------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-7151
> URL: https://issues.apache.org/jira/browse/DERBY-7151
> Project: Derby
> Issue Type: Bug
> Affects Versions: 10.16.1.1
> Environment: 'Windows 10' Version '10.0' Arch 'amd64'
> Java Info: Vendor 'Eclipse Adoptium' URL 'https://adoptium.net/' Version
> '17.0.2'
> Reporter: Daniel Gonzalez
> Priority: Major
>
> Unfortunately we can't reproduce this one but have had a customer report of
> the following crash:
>
> {quote}Restore of a serializable or SQLData object of class , attempted to
> read more data than was originally stored
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:115)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:141)
> at org.apache.derby.impl.jdbc.Util.seeNextException(Util.java:252)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:438)
> at
> org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:360)
> at
> org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:2405)
> at
> org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:88)
> at
> org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(EmbedResultSet.java:4663)
> at
> org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:490)
> at org.apache.derby.impl.jdbc.EmbedResultSet.next(EmbedResultSet.java:394)
> at
> uk.co.screamingfrog.seospider.db.UniqueUrlsTableOperations.getEncodedUrlIdFromDb(UniqueUrlsTableOperations.java:213)
> ... 9 more
> Caused by: ERROR XSDA7: Restore of a serializable or SQLData object of class
> , attempted to read more data than was originally stored
> at
> org.apache.derby.shared.common.error.StandardException.newException(StandardException.java:300)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.wrapArgsForTransportAcrossDRDA(SQLExceptionFactory.java:170)
> at
> org.apache.derby.impl.jdbc.SQLExceptionFactory.getSQLException(SQLExceptionFactory.java:75)
> ... 19 more
> Caused by: java.io.EOFException
> at
> org.apache.derby.iapi.services.io.ArrayInputStream.readDerbyUTF(ArrayInputStream.java:429)
> at
> org.apache.derby.iapi.types.SQLChar.readExternalFromArray(SQLChar.java:1093)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.readRecordFromArray(StoredPage.java:5676)
> at
> org.apache.derby.impl.store.raw.data.StoredPage.restoreRecordFromSlot(StoredPage.java:1526)
> at
> org.apache.derby.impl.store.raw.data.BasePage.fetchFromSlot(BasePage.java:450)
> at
> org.apache.derby.impl.store.raw.data.CachedPage.fetchFromSlot(CachedPage.java:53)
> at
> org.apache.derby.impl.store.access.btree.ControlRow.compareIndexRowFromPageToKey(ControlRow.java:1243)
> at
> org.apache.derby.impl.store.access.btree.ControlRow.searchForEntry(ControlRow.java:1001)
> at
> org.apache.derby.impl.store.access.btree.LeafControlRow.search(LeafControlRow.java:328)
> at
> org.apache.derby.impl.store.access.btree.BranchControlRow.search(BranchControlRow.java:291)
> at
> org.apache.derby.impl.store.access.btree.BranchControlRow.search(BranchControlRow.java:291)
> at
> org.apache.derby.impl.store.access.btree.BranchControlRow.search(BranchControlRow.java:291)
> at
> org.apache.derby.impl.store.access.btree.BTreeScan.positionAtStartForForwardScan(BTreeScan.java:392)
> at
> org.apache.derby.impl.store.access.btree.BTreeForwardScan.positionAtStartPosition(BTreeForwardScan.java:70)
> at
> org.apache.derby.impl.store.access.btree.BTreeForwardScan.fetchRows(BTreeForwardScan.java:129)
> at
> org.apache.derby.impl.store.access.btree.BTreeScan.fetchNextGroup(BTreeScan.java:1682)
> at
> org.apache.derby.impl.sql.execute.BulkTableScanResultSet.reloadArray(BulkTableScanResultSet.java:424)
> at
> org.apache.derby.impl.sql.execute.BulkTableScanResultSet.getNextRowCore(BulkTableScanResultSet.java:367)
> at
> org.apache.derby.impl.sql.execute.IndexRowToBaseRowResultSet.getNextRowCore(IndexRowToBaseRowResultSet.java:346)
> at
> org.apache.derby.impl.sql.execute.ProjectRestrictResultSet.getNextRowCore(ProjectRestrictResultSet.java:287)
> at
> org.apache.derby.impl.sql.execute.BasicNoPutResultSetImpl.getNextRow(BasicNoPutResultSetImpl.java:488)
> at
> org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:450)
> ... 11 more
> {quote}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
