Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 13982 invoked from network); 11 Jun 2008 08:09:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 11 Jun 2008 08:09:37 -0000 Received: (qmail 81774 invoked by uid 500); 11 Jun 2008 08:09:40 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 81547 invoked by uid 500); 11 Jun 2008 08:09:39 -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 81536 invoked by uid 99); 11 Jun 2008 08:09:39 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 11 Jun 2008 01:09:39 -0700 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; Wed, 11 Jun 2008 08:08:57 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 13E3B234C13A for ; Wed, 11 Jun 2008 01:08:45 -0700 (PDT) Message-ID: <490143500.1213171725080.JavaMail.jira@brutus> Date: Wed, 11 Jun 2008 01:08:45 -0700 (PDT) From: "Se Youn Ban (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Updated: (DERBY-3688) multiple db instance and ERROR XSDG3: Meta-data for Container org.apache.derby.impl.store.raw.data.RAFContainer4@d1cfbb could not be accessed In-Reply-To: <338626350.1211530316521.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-Virus-Checked: Checked by ClamAV on apache.org [ https://issues.apache.org/jira/browse/DERBY-3688?page=3Dcom.atlassia= n.jira.plugin.system.issuetabpanels:all-tabpanel ] Se Youn Ban updated DERBY-3688: ------------------------------- Description:=20 I got this error when I took queries for multiple db instances.=20 I make db instance for every day and access the db instance of the day when= I need to query. The size of one day db instance is about 6G. When I try to select query for a week, the ERROR XSDG3 occurs and derby is = goning to be crashed. Please, check the attached derby log. -------------------------------- ERROR XSDG3: Meta-data for Container org.apache.derby.impl.store.raw.data.R= AFContainer4@d1cfbb could not be accessed =09at org.apache.derby.iapi.error.StandardException.newException(StandardEx= ception.java:296) =09at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.ja= va:1451) =09at java.security.AccessController.doPrivileged(Native Method) =09at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFCo= ntainer.java:854) =09at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFC= ontainer4.java:146) =09at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileConta= iner.java:365) =09at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFCont= ainer.java:134) =09at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Cached= Item.java:222) =09at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800) =09at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303) =09at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContaine= r(BaseDataFileFactory.java:629) =09at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContaine= r(BaseDataFileFactory.java:559) =09at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:128= 3) =09at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readC= onglomerate(HeapConglomerateFactory.java:237) =09at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(= RAMAccessManager.java:482) =09at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglom= erate(RAMTransaction.java:397) =09at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTr= ansaction.java:1664) =09at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostCon= troller(CompilerContextImpl.java:460) =09at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostControlle= r(FromBaseTable.java:4471) =09at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBase= Table.java:946) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Opt= imizerImpl.java:2623) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimiza= ble(OptimizerImpl.java:2171) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Optim= izerImpl.java:1984) =09at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTa= ble.java:520) =09at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Proj= ectRestrictNode.java:316) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java= :1766) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:894) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :255) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Proj= ectRestrictNode.java:316) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java= :1766) =09at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(= DMLStatementNode.java:305) =09at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(Cursor= Node.java:515) =09at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatemen= t.java:365) =09at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.j= ava:88) =09at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa= reInternalStatement(GenericLanguageConnectionContext.java:768) =09at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(EmbedPrepare= dStatement.java:128) =09at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(EmbedPrepa= redStatement20.java:82) =09at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(EmbedPrepa= redStatement30.java:63) =09at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.jav= a:99) =09at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConn= ection.java:1475) =09at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConn= ection.java:1356) =09at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:6= 35) =09at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatemen= t.java:596) =09at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThre= ad.java:3618) =09at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThr= ead.java:789) =09at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278= ) Caused by: java.io.IOException: =ED=8C=8C=EC=9D=BC=EC=9D=B4 =EC=9D=B4=EB=AF= =B8 =EC=9E=88=EC=9C=BC=EB=AF=80=EB=A1=9C =EB=A7=8C=EB=93=A4 =EC=88=98 =EC= =97=86=EC=8A=B5=EB=8B=88=EB=8B=A4 (can not create file) =09at java.io.RandomAccessFile.open(Native Method) =09at java.io.RandomAccessFile.(RandomAccessFile.java:204) =09at org.apache.derby.impl.io.DirRandomAccessFile.(DirRandomAccessFi= le.java:57) =09at org.apache.derby.impl.io.DirRandomAccessFile4.(DirRandomAccessF= ile4.java:57) =09at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:2= 50) =09at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.ja= va:1392) was: I got this error when I took queries for multiple db instances.=20 I make db instance for every day and access the db instance of the day when= I need to query. The size of one day db instance is about 6G. When I try to select query for a week, the ERROR XSDG3 occurs and derby is = goning to be crashed. -------------------------------- ERROR XSDG3: Meta-data for Container org.apache.derby.impl.store.raw.data.R= AFContainer4@d1cfbb could not be accessed =09at org.apache.derby.iapi.error.StandardException.newException(StandardEx= ception.java:296) =09at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.ja= va:1451) =09at java.security.AccessController.doPrivileged(Native Method) =09at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFCo= ntainer.java:854) =09at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFC= ontainer4.java:146) =09at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileConta= iner.java:365) =09at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFCont= ainer.java:134) =09at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Cached= Item.java:222) =09at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800) =09at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303) =09at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContaine= r(BaseDataFileFactory.java:629) =09at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContaine= r(BaseDataFileFactory.java:559) =09at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:128= 3) =09at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readC= onglomerate(HeapConglomerateFactory.java:237) =09at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(= RAMAccessManager.java:482) =09at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglom= erate(RAMTransaction.java:397) =09at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTr= ansaction.java:1664) =09at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostCon= troller(CompilerContextImpl.java:460) =09at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostControlle= r(FromBaseTable.java:4471) =09at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBase= Table.java:946) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(Opt= imizerImpl.java:2623) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimiza= ble(OptimizerImpl.java:2171) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Optim= izerImpl.java:1984) =09at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTa= ble.java:520) =09at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Proj= ectRestrictNode.java:316) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java= :1766) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:894) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :255) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(Ta= bleOperatorNode.java:886) =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java= :249) =09at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Proj= ectRestrictNode.java:316) =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Optim= izerImpl.java:1938) =09at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java= :1766) =09at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(= DMLStatementNode.java:305) =09at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(Cursor= Node.java:515) =09at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatemen= t.java:365) =09at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.j= ava:88) =09at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepa= reInternalStatement(GenericLanguageConnectionContext.java:768) =09at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(EmbedPrepare= dStatement.java:128) =09at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(EmbedPrepa= redStatement20.java:82) =09at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(EmbedPrepa= redStatement30.java:63) =09at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.jav= a:99) =09at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConn= ection.java:1475) =09at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConn= ection.java:1356) =09at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:6= 35) =09at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatemen= t.java:596) =09at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThre= ad.java:3618) =09at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThr= ead.java:789) =09at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278= ) Caused by: java.io.IOException: =ED=8C=8C=EC=9D=BC=EC=9D=B4 =EC=9D=B4=EB=AF= =B8 =EC=9E=88=EC=9C=BC=EB=AF=80=EB=A1=9C =EB=A7=8C=EB=93=A4 =EC=88=98 =EC= =97=86=EC=8A=B5=EB=8B=88=EB=8B=A4 (can not create file) =09at java.io.RandomAccessFile.open(Native Method) =09at java.io.RandomAccessFile.(RandomAccessFile.java:204) =09at org.apache.derby.impl.io.DirRandomAccessFile.(DirRandomAccessFi= le.java:57) =09at org.apache.derby.impl.io.DirRandomAccessFile4.(DirRandomAccessF= ile4.java:57) =09at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:2= 50) =09at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.ja= va:1392) > multiple db instance and ERROR XSDG3: Meta-data for Container org.apache.= derby.impl.store.raw.data.RAFContainer4@d1cfbb could not be accessed > -------------------------------------------------------------------------= -------------------------------------------------------------------- > > Key: DERBY-3688 > URL: https://issues.apache.org/jira/browse/DERBY-3688 > Project: Derby > Issue Type: Bug > Environment: Windows 2000, JDK1.4.2, derby 10.3.3.0,10.4.1.3 and = others > Reporter: Se Youn Ban > Priority: Critical > > I got this error when I took queries for multiple db instances.=20 > I make db instance for every day and access the db instance of the day wh= en I need to query. > The size of one day db instance is about 6G. > When I try to select query for a week, the ERROR XSDG3 occurs and derby i= s goning to be crashed. > Please, check the attached derby log. > -------------------------------- > ERROR XSDG3: Meta-data for Container org.apache.derby.impl.store.raw.data= .RAFContainer4@d1cfbb could not be accessed > =09at org.apache.derby.iapi.error.StandardException.newException(Standard= Exception.java:296) > =09at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.= java:1451) > =09at java.security.AccessController.doPrivileged(Native Method) > =09at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAF= Container.java:854) > =09at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RA= FContainer4.java:146) > =09at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileCon= tainer.java:365) > =09at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFCo= ntainer.java:134) > =09at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(Cach= edItem.java:222) > =09at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800) > =09at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303) > =09at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContai= ner(BaseDataFileFactory.java:629) > =09at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContai= ner(BaseDataFileFactory.java:559) > =09at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1= 283) > =09at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.rea= dConglomerate(HeapConglomerateFactory.java:237) > =09at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFin= d(RAMAccessManager.java:482) > =09at org.apache.derby.impl.store.access.RAMTransaction.findExistingCongl= omerate(RAMTransaction.java:397) > =09at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAM= Transaction.java:1664) > =09at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostC= ontroller(CompilerContextImpl.java:460) > =09at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostControl= ler(FromBaseTable.java:4471) > =09at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBa= seTable.java:946) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(O= ptimizerImpl.java:2623) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimi= zable(OptimizerImpl.java:2171) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(Opt= imizerImpl.java:1984) > =09at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBase= Table.java:520) > =09at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Pr= ojectRestrictNode.java:316) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.ja= va:1766) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:894) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:255) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:886) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:249) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:886) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:249) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:886) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:249) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:886) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:249) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:886) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:249) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:886) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:249) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:886) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:249) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:886) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:249) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:886) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:249) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:886) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:249) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:886) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:249) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(= TableOperatorNode.java:886) > =09at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.ja= va:249) > =09at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(Pr= ojectRestrictNode.java:316) > =09at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(Opt= imizerImpl.java:1938) > =09at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.ja= va:1766) > =09at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatemen= t(DMLStatementNode.java:305) > =09at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(Curs= orNode.java:515) > =09at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatem= ent.java:365) > =09at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement= .java:88) > =09at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.pre= pareInternalStatement(GenericLanguageConnectionContext.java:768) > =09at org.apache.derby.impl.jdbc.EmbedPreparedStatement.(EmbedPrepa= redStatement.java:128) > =09at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.(EmbedPre= paredStatement20.java:82) > =09at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.(EmbedPre= paredStatement30.java:63) > =09at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.j= ava:99) > =09at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedCo= nnection.java:1475) > =09at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedCo= nnection.java:1356) > =09at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java= :635) > =09at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatem= ent.java:596) > =09at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnTh= read.java:3618) > =09at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnT= hread.java:789) > =09at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:2= 78) > Caused by: java.io.IOException: =ED=8C=8C=EC=9D=BC=EC=9D=B4 =EC=9D=B4=EB= =AF=B8 =EC=9E=88=EC=9C=BC=EB=AF=80=EB=A1=9C =EB=A7=8C=EB=93=A4 =EC=88=98 = =EC=97=86=EC=8A=B5=EB=8B=88=EB=8B=A4 (can not create file) > =09at java.io.RandomAccessFile.open(Native Method) > =09at java.io.RandomAccessFile.(RandomAccessFile.java:204) > =09at org.apache.derby.impl.io.DirRandomAccessFile.(DirRandomAccess= File.java:57) > =09at org.apache.derby.impl.io.DirRandomAccessFile4.(DirRandomAcces= sFile4.java:57) > =09at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java= :250) > =09at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.= java:1392) --=20 This message is automatically generated by JIRA. - You can reply to this email to add a comment to the issue online.