Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 73148 invoked from network); 12 Jun 2008 07:56:36 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 12 Jun 2008 07:56:36 -0000 Received: (qmail 4319 invoked by uid 500); 12 Jun 2008 07:56:38 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 4286 invoked by uid 500); 12 Jun 2008 07:56: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 4275 invoked by uid 99); 12 Jun 2008 07:56:38 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 12 Jun 2008 00:56: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; Thu, 12 Jun 2008 07:55:57 +0000 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 0F65F234C139 for ; Thu, 12 Jun 2008 00:55:45 -0700 (PDT) Message-ID: <1823123985.1213257345061.JavaMail.jira@brutus> Date: Thu, 12 Jun 2008 00:55:45 -0700 (PDT) From: "Knut Anders Hatlen (JIRA)" To: derby-dev@db.apache.org Subject: [jira] Commented: (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.atlassian= .jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=3D1260= 4439#action_12604439 ]=20 Knut Anders Hatlen commented on DERBY-3688: ------------------------------------------- Thanks! I searched Sun's bug database for information about similar error messages. These bug reports looked relevant: http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=3D4189011 http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=3D4804456 http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=3D4919795 So it seems like the error message is misleading (that call should not fail just because the file exists) and should probably have said "too many open file handles". Also a limitation on the number of open file handles in JDK 1.4.2 on Windows was fixed in JDK 5. This probably means that upgrading to a newer JDK would make your problem go away. However, it still leaves us with the question why there are so many open file handles in your application. One possibility is that Derby by mistake doesn't close file handles all the time. Another possibility is that your application has many open databases, each of which has a number of open files. You said that you have one database for each day. How many databases do you have booted at the same time? > 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 > Attachments: derby.log > > > 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.