[
https://issues.apache.org/jira/browse/DERBY-4139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12697365#action_12697365
]
Trung Tran commented on DERBY-4139:
-----------------------------------
Upgrading on another platform and moving back to AS400 doesn't work. Same
error. After a lot of testing, it looks like the limit is 2 GB for 10.4 derby
on AS400 while on other platforms, I don't see this limitation. This points to
the JVM, but without much information, IBM will not be able to help.
> error on sql when upgrading database from 10.2.2 to 10.4.1.3
> ------------------------------------------------------------
>
> Key: DERBY-4139
> URL: https://issues.apache.org/jira/browse/DERBY-4139
> Project: Derby
> Issue Type: Bug
> Components: SQL
> Affects Versions: 10.4.1.3
> Environment: AS400 V5R3
> Reporter: Trung Tran
>
> I upgraded a 10.2.2 database to 10.4.1.3 on the AS400 V5R3 and when I try to
> access a large table, derby throws this error.
> select max(column) from table;
> ERROR XSDG0: Page Page(86673,Container(0, 4432)) could not be read from disk.
>
> ERROR XJ001: Java exception: 'The value specified for the argument is not
> correct. Read/write failed: java.io.IOException'.
> In derby.log
> ERROR XSDG0: Page Page(86673,Container(0, 4432)) could not be read from disk.
> at java.lang.Throwable.<init>(Throwable.java:195)
> at java.lang.Exception.<init>(Exception.java:41)
> at org.apache.derby.iapi.error.StandardException.<init>(Unknown Source)
> at org.apache.derby.iapi.error.StandardException.newException(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.CachedPage.readPage(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown
> Source)
> at
> org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Unknown Source)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Unknown Source)
> at org.apache.derby.impl.services.cache.Clock.find(Unknown Source)
> at
> org.apache.derby.impl.store.raw.data.FileContainer.getAllocPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainer.getAllocPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.getAllocPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.AllocationCache.validate(Unknown Source)
> at
> org.apache.derby.impl.store.raw.data.AllocationCache.getLastPageNumber(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source)
> at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source)
> at
> org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at
> org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
> at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
> at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
> at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)
> at org.apache.derby.tools.ij.main(Unknown Source)
> Caused by: java.io.IOException: The value specified for the argument is not
> correct. Read/write failed
> at java.lang.Throwable.<init>(Throwable.java:195)
> at java.lang.Exception.<init>(Exception.java:41)
> at java.io.IOException.<init>(IOException.java:40)
> at sun.nio.ch.FileDispatcher.pread0(Native Method)
> at sun.nio.ch.FileDispatcher.pread(FileDispatcher.java:60)
> at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:230)
> at sun.nio.ch.IOUtil.read(IOUtil.java:206)
> at sun.nio.ch.FileChannelImpl.read(FileChannelImpl.java:617)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.readFull(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.readPage0(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.readPage(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.CachedPage.readPage(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown
> Source)
> at
> org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Unknown Source)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Unknown Source)
> at org.apache.derby.impl.services.cache.Clock.find(Unknown Source)
> at
> org.apache.derby.impl.store.raw.data.FileContainer.getAllocPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainer.getAllocPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.getAllocPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.AllocationCache.validate(Unknown Source)
> at
> org.apache.derby.impl.store.raw.data.AllocationCache.getLastPageNumber(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source)
> at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source)
> at
> org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at
> org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
> at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
> at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
> at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)
> ============= begin nested exception, level (1) ===========
> java.io.IOException: The value specified for the argument is not correct.
> Read/write failed
> at java.lang.Throwable.<init>(Throwable.java:195)
> at java.lang.Exception.<init>(Exception.java:41)
> at java.io.IOException.<init>(IOException.java:40)
> at sun.nio.ch.FileDispatcher.pread0(Native Method)
> at sun.nio.ch.FileDispatcher.pread(FileDispatcher.java:60)
> at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:230)
> at sun.nio.ch.IOUtil.read(IOUtil.java:206)
> at sun.nio.ch.FileChannelImpl.read(FileChannelImpl.java:617)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.readFull(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.readPage0(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.readPage(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.CachedPage.readPage(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.CachedPage.setIdentity(Unknown
> Source)
> at
> org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Unknown Source)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Unknown Source)
> at org.apache.derby.impl.services.cache.Clock.find(Unknown Source)
> at
> org.apache.derby.impl.store.raw.data.FileContainer.getAllocPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainer.getAllocPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.getAllocPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.AllocationCache.validate(Unknown Source)
> at
> org.apache.derby.impl.store.raw.data.AllocationCache.getLastPageNumber(Unknown
> Source)
> at org.apache.derby.impl.store.raw.data.FileContainer.pageValid(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.FileContainer.getUserPage(Unknown Source)
> at org.apache.derby.impl.store.raw.data.FileContainer.getPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.raw.data.BaseContainerHandle.getPage(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(Unknown
> Source)
> at
> org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Unknown
> Source)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(Unknown Source)
> at
> org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(Unknown
> Source)
> at
> org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source)
> at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source)
> at
> org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown
> Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> at org.apache.derby.impl.jdbc.EmbedStatement.execute(Unknown Source)
> at org.apache.derby.impl.tools.ij.ij.executeImmediate(Unknown Source)
> at org.apache.derby.impl.tools.ij.utilMain.doCatch(Unknown Source)
> at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(Unknown Source)
> at org.apache.derby.impl.tools.ij.utilMain.go(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.go(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.mainCore(Unknown Source)
> at org.apache.derby.impl.tools.ij.Main.main(Unknown Source)
> ============= end nested exception, level (1) ===========
> I noticed that one of the datafile is over 8 GB. Does the newer version of
> derby have a problem with large files? I will try 10.4.2.0 to see if the
> same problem exists.
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
