Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 11008 invoked from network); 2 Apr 2009 18:39:39 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 2 Apr 2009 18:39:39 -0000 Received: (qmail 95368 invoked by uid 500); 2 Apr 2009 18:39:39 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 95290 invoked by uid 500); 2 Apr 2009 18:39:38 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 95282 invoked by uid 99); 2 Apr 2009 18:39:38 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Apr 2009 18:39:38 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=10.0 tests=ALL_TRUSTED X-Spam-Check-By: apache.org Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 02 Apr 2009 18:39:36 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 9EED8234C051 for ; Thu, 2 Apr 2009 11:39:13 -0700 (PDT) Message-ID: <257931009.1238697553635.JavaMail.jira@brutus> Date: Thu, 2 Apr 2009 11:39:13 -0700 (PDT) From: "Trung Tran (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (DERBY-4139) error on sql when upgrading database from 10.2.2 to 10.4.1.3 In-Reply-To: <319070345.1238686092993.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-4139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12695087#action_12695087 ] Trung Tran commented on DERBY-4139: ----------------------------------- Rick, Here is the DDL for the table. I have upgraded many databases from 10.2.2 to 10.4.1.3 without an issue with the same schema. FYI, I tried 10.4.2.0 and still get the same error. Thanks. CREATE TABLE test( a INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY (START WITH 1, INCREMENT BY 1), b timestamp NOT NULL, c VARCHAR(32) NOT NULL, d INTEGER, e INTEGER, f INTEGER, g INTEGER, h INTEGER, i INTEGER, j BIGINT, k VARCHAR(2000) NOT NULL, l VARCHAR(12), m VARCHAR(20), n BIGINT, o CHAR(1), p CHAR(2), q CHAR(1), r VARCHAR(15), s CHAR(1), t BIGINT, u CHAR(1), v VARCHAR(2000), w VARCHAR(2000), x VARCHAR(6), y CHAR(1), z timestamp, 1 timestamp, 2 timestamp, 3 timestamp, 4 INTEGER, 5 VARCHAR(64), 6 INTEGER, constraint pk_a PRIMARY KEY(a) ); > 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.(Throwable.java:195) > at java.lang.Exception.(Exception.java:41) > at org.apache.derby.iapi.error.StandardException.(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.(Throwable.java:195) > at java.lang.Exception.(Exception.java:41) > at java.io.IOException.(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.(Throwable.java:195) > at java.lang.Exception.(Exception.java:41) > at java.io.IOException.(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.