Details
-
Bug
-
Status: Closed
-
Critical
-
Resolution: Invalid
-
None
-
None
-
None
-
None
-
Windows 2000, JDK1.4.2, derby 10.3.3.0,10.4.1.3 and others
-
Crash
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)