You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Se Youn Ban (JIRA)" <ji...@apache.org> on 2008/05/23 10:11:56 UTC
[jira] Created: (DERBY-3688) ERROR XSDG3: Meta-data for Container
org.apache.derby.impl.store.raw.data.RAFContainer4@d1cfbb could not be
accessed
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
Affects Versions: 10.4.1.3
Environment: Windows 2000, JDK1.4.2
Reporter: Se Youn Ban
I got this error when I took a bulk query on derby.
This error could be similar DERBY-3411.
The difference is that the DERBY-3411 was occured when to backup the derby and this error when to query the derby.
I think this error happens if the client connecting the derby be disconnected suddenly by crash - no disconnet message -
and the thread of the derby could hold the handle of the file while new thread by new query try to open/create the file with same name.
I hope this problem can be fixed. Thank you for the derby .
--------------------------------
ERROR XSDG3: Meta-data for Container org.apache.derby.impl.store.raw.data.RAFContainer4@d1cfbb could not be accessed
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[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
Posted by "Se Youn Ban (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Se Youn Ban updated DERBY-3688:
-------------------------------
Priority: Critical (was: Major)
Description:
I got this error when I took queries for multiple db instances.
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.RAFContainer4@d1cfbb could not be accessed
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
was:
I got this error when I took a bulk query on derby.
This error could be similar DERBY-3411.
The difference is that the DERBY-3411 was occured when to backup the derby and this error when to query the derby.
I think this error happens if the client connecting the derby be disconnected suddenly by crash - no disconnet message -
and the thread of the derby could hold the handle of the file while new thread by new query try to open/create the file with same name.
I hope this problem can be fixed. Thank you for the derby .
--------------------------------
ERROR XSDG3: Meta-data for Container org.apache.derby.impl.store.raw.data.RAFContainer4@d1cfbb could not be accessed
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
Affects Version/s: (was: 10.4.1.3)
10.3.3.0
Summary: multiple db instance and ERROR XSDG3: Meta-data for Container org.apache.derby.impl.store.raw.data.RAFContainer4@d1cfbb could not be accessed (was: ERROR XSDG3: Meta-data for Container org.apache.derby.impl.store.raw.data.RAFContainer4@d1cfbb could not be accessed)
> 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
> Affects Versions: 10.3.3.0
> Environment: Windows 2000, JDK1.4.2
> Reporter: Se Youn Ban
> Priority: Critical
>
> I got this error when I took queries for multiple db instances.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (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
Posted by "Se Youn Ban (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Se Youn Ban closed DERBY-3688.
------------------------------
Derby Categories: [Crash]
The individual database instance without connection does not be released automatically by Derby.
You should shutdown the individual database if you need to boot multiple individual database to
avoid Derby be crashed without resource.
> 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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[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
Posted by "Se Youn Ban (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Se Youn Ban updated DERBY-3688:
-------------------------------
Attachment: derby.log
> 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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Issue Comment Edited: (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
Posted by "Se Youn Ban (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12604390#action_12604390 ]
syban edited comment on DERBY-3688 at 6/11/08 5:19 PM:
-------------------------------------------------------------
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
The above message says "can not create a file because the file exists" in Korean.
>From this message, I guess the file related with db instances is shared and
is not released within a minute after all connections to the db instance are disconnected.
was (Author: syban):
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
The above message says "can not create a file because the file exists" in Korean.
>From this message, I guess the file related with db instances is shared and
is not released within a minute after all collections to the db instance are disconnected.
> 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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[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
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12604488#action_12604488 ]
Knut Anders Hatlen commented on DERBY-3688:
-------------------------------------------
Derby keeps some resources open even after you have closed the last connection to the database. Each open database will have a page cache and a container cache, among other things. The container cache contains the file handles, and by default caches up to 100 handles. So the total number of open files could be quite big if you have loaded many databases.
To shut down a database instance after you are finished with it, you can call:
DriverManager.getConnection("jdbc:derby:name_of_database;shutdown=true");
This will free all the resources that this database instance previously held.
You can find more details about database shutdown here: http://db.apache.org/derby/docs/10.4/devguide/tdevdvlp40464.html
> 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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[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
Posted by "Se Youn Ban (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12604736#action_12604736 ]
Se Youn Ban commented on DERBY-3688:
------------------------------------
Thank you for your advice.
The function,DriverManager.getConnection("jdbc:derby:name_of_database;shutdown=true");, works pretty well.
Is there any way to shutdown the individual database automatiiclay without connection or restrict the number of
booting individual database?
> 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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[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
Posted by "Se Youn Ban (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12604390#action_12604390 ]
Se Youn Ban commented on DERBY-3688:
------------------------------------
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
The above message says "can not create a file because the file exists" in Korean.
>From this message, I guess the file related with db instances is shared and
is not released within a minute after all collections to the db instance are disconnected.
> 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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[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
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12604163#action_12604163 ]
Knut Anders Hatlen commented on DERBY-3688:
-------------------------------------------
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
The underlying IOException must be a FileNotFoundException, as that's
the only checked exception java.io.RandomAccessFile's constructor can
throw. Does the error message "파일이 이미 있으므로 만들 수 없습니다"
say anything more specific than cannot create file?
> 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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[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
Posted by "Se Youn Ban (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[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
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12604439#action_12604439 ]
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=4189011
http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4804456
http://bugs.sun.com/bugdatabase/view_bug.do?bug_id=4919795
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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Issue Comment Edited: (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
Posted by "Se Youn Ban (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12604456#action_12604456 ]
syban edited comment on DERBY-3688 at 6/12/08 2:22 AM:
-------------------------------------------------------------
Thanks for your comment.
My application opens database sequentially.
It makes a new connection after the previous connection is closed.
I have no idea Derby will release instantly the previous db instance which has no connection.
I will test it with JDK5 ASAP.
was (Author: syban):
Thanks for your comment.
My application opens database sequentially.
It makes a connection after the previous connection is closed.
I have no idea Derby will release instantly the previous db instance which has no connection.
I will test it with JDK5 ASAP.
> 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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[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
Posted by "Se Youn Ban (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Se Youn Ban updated DERBY-3688:
-------------------------------
Description:
I got this error when I took queries for multiple db instances.
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.RAFContainer4@d1cfbb could not be accessed
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
was:
I got this error when I took queries for multiple db instances.
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.RAFContainer4@d1cfbb could not be accessed
at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
at java.security.AccessController.doPrivileged(Native Method)
at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
at java.io.RandomAccessFile.open(Native Method)
at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java: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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[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
Posted by "Se Youn Ban (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12604456#action_12604456 ]
Se Youn Ban commented on DERBY-3688:
------------------------------------
Thanks for your comment.
My application opens database sequentially.
It makes a connection after the previous connection is closed.
I have no idea Derby will release instantly the previous db instance which has no connection.
I will test it with JDK5 ASAP.
> 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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (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
Posted by "Se Youn Ban (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3688?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Se Youn Ban resolved DERBY-3688.
--------------------------------
Resolution: Invalid
> 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.
> 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.RAFContainer4@d1cfbb could not be accessed
> at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:296)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1451)
> at java.security.AccessController.doPrivileged(Native Method)
> at org.apache.derby.impl.store.raw.data.RAFContainer.openContainer(RAFContainer.java:854)
> at org.apache.derby.impl.store.raw.data.RAFContainer4.openContainer(RAFContainer4.java:146)
> at org.apache.derby.impl.store.raw.data.FileContainer.setIdent(FileContainer.java:365)
> at org.apache.derby.impl.store.raw.data.RAFContainer.setIdentity(RAFContainer.java:134)
> at org.apache.derby.impl.services.cache.CachedItem.takeOnIdentity(CachedItem.java:222)
> at org.apache.derby.impl.services.cache.Clock.addEntry(Clock.java:800)
> at org.apache.derby.impl.services.cache.Clock.find(Clock.java:303)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:629)
> at org.apache.derby.impl.store.raw.data.BaseDataFileFactory.openContainer(BaseDataFileFactory.java:559)
> at org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java:1283)
> at org.apache.derby.impl.store.access.heap.HeapConglomerateFactory.readConglomerate(HeapConglomerateFactory.java:237)
> at org.apache.derby.impl.store.access.RAMAccessManager.conglomCacheFind(RAMAccessManager.java:482)
> at org.apache.derby.impl.store.access.RAMTransaction.findExistingConglomerate(RAMTransaction.java:397)
> at org.apache.derby.impl.store.access.RAMTransaction.openStoreCost(RAMTransaction.java:1664)
> at org.apache.derby.impl.sql.compile.CompilerContextImpl.getStoreCostController(CompilerContextImpl.java:460)
> at org.apache.derby.impl.sql.compile.FromBaseTable.getStoreCostController(FromBaseTable.java:4471)
> at org.apache.derby.impl.sql.compile.FromBaseTable.estimateCost(FromBaseTable.java:946)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.estimateTotalCost(OptimizerImpl.java:2623)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costBasedCostOptimizable(OptimizerImpl.java:2171)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costOptimizable(OptimizerImpl.java:1984)
> at org.apache.derby.impl.sql.compile.FromBaseTable.optimizeIt(FromBaseTable.java:520)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:894)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:255)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.TableOperatorNode.optimizeSource(TableOperatorNode.java:886)
> at org.apache.derby.impl.sql.compile.UnionNode.optimizeIt(UnionNode.java:249)
> at org.apache.derby.impl.sql.compile.ProjectRestrictNode.optimizeIt(ProjectRestrictNode.java:316)
> at org.apache.derby.impl.sql.compile.OptimizerImpl.costPermutation(OptimizerImpl.java:1938)
> at org.apache.derby.impl.sql.compile.SelectNode.optimize(SelectNode.java:1766)
> at org.apache.derby.impl.sql.compile.DMLStatementNode.optimizeStatement(DMLStatementNode.java:305)
> at org.apache.derby.impl.sql.compile.CursorNode.optimizeStatement(CursorNode.java:515)
> at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:365)
> at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
> at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:768)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(EmbedPreparedStatement.java:128)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(EmbedPreparedStatement20.java:82)
> at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(EmbedPreparedStatement30.java:63)
> at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Driver30.java:99)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1475)
> at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(EmbedConnection.java:1356)
> at org.apache.derby.impl.drda.DRDAStatement.prepare(DRDAStatement.java:635)
> at org.apache.derby.impl.drda.DRDAStatement.explicitPrepare(DRDAStatement.java:596)
> at org.apache.derby.impl.drda.DRDAConnThread.parsePRPSQLSTT(DRDAConnThread.java:3618)
> at org.apache.derby.impl.drda.DRDAConnThread.processCommands(DRDAConnThread.java:789)
> at org.apache.derby.impl.drda.DRDAConnThread.run(DRDAConnThread.java:278)
> Caused by: java.io.IOException: 파일이 이미 있으므로 만들 수 없습니다 (can not create file)
> at java.io.RandomAccessFile.open(Native Method)
> at java.io.RandomAccessFile.<init>(RandomAccessFile.java:204)
> at org.apache.derby.impl.io.DirRandomAccessFile.<init>(DirRandomAccessFile.java:57)
> at org.apache.derby.impl.io.DirRandomAccessFile4.<init>(DirRandomAccessFile4.java:57)
> at org.apache.derby.impl.io.DirFile4.getRandomAccessFile(DirFile4.java:250)
> at org.apache.derby.impl.store.raw.data.RAFContainer.run(RAFContainer.java:1392)
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.