[
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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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 [EMAIL PROTECTED] could not be accessed (was: ERROR XSDG3: Meta-data
for Container [EMAIL PROTECTED] could not be accessed)
> multiple db instance and ERROR XSDG3: Meta-data for Container [EMAIL
> PROTECTED] 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 [EMAIL PROTECTED] 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.
