Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 13925 invoked from network); 11 Jun 2008 08:09:36 -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:36 -0000 Received: (qmail 81337 invoked by uid 500); 11 Jun 2008 08:09:38 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 81303 invoked by uid 500); 11 Jun 2008 08:09: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 81292 invoked by uid 99); 11 Jun 2008 08:09:38 -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:38 -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 04EF5234C138 for ; Wed, 11 Jun 2008 01:08:45 -0700 (PDT) Message-ID: <1826285942.1213171725019.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: ------------------------------- Environment: Windows 2000, JDK1.4.2, derby 10.3.3.0,10.4.1.3 and = others (was: Windows 2000, JDK1.4.2) Affects Version/s: (was: 10.3.3.0) > 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. > -------------------------------- > 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.