db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris <ch...@visual-i.co.uk>
Subject error when turning off auto commit
Date Thu, 12 May 2005 09:31:29 GMT
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<div class="moz-text-flowed"
 style="font-family: -moz-fixed; font-size: 13px;" lang="x-western">Hi,
<br>
<br>
i think i've found a bug in derby.&nbsp; i'm following the guidelines from
the website and posting it here before reporting it just to make sure
it <b class="moz-txt-star"><span class="moz-txt-tag">*</span>is<span
 class="moz-txt-tag">*</span></b> a bug!
<br>
<br>
I'm running a set of ~50000 queries on one table, using inserts and
updates, and i want to be able to roll them back so i turned off
autocommit using setAutoCommit(false).&nbsp; As the update runs, the memory
used by the JVM increases continually until i get the following
exception about 20% of the way through:
<br>
<br>
ERROR 40XT0: An internal error was identified by RawStore module.
<br>
&nbsp;&nbsp; at
org.apache.derby.iapi.error.StandardException.newException(StandardException.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.store.raw.xact.Xact.setActiveState(Xact.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.store.raw.xact.Xact.openContainer(Xact.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.store.access.conglomerate.OpenConglomerate.init(OpenConglomerate.java)
<br>
&nbsp;&nbsp; at org.apache.derby.impl.store.access.heap.Heap.open(Heap.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(RAMTransaction.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.store.access.RAMTransaction.openConglomerate(RAMTransaction.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getDescriptorViaIndex(DataDictionaryImpl.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.locateSchemaRow(DataDictionaryImpl.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(DataDictionaryImpl.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(QueryTreeNode.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(QueryTreeNode.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(FromBaseTable.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(FromBaseTable.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.compile.FromList.bindTables(FromList.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(SelectNode.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(DMLStatementNode.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.compile.DMLStatementNode.bind(DMLStatementNode.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.compile.ReadCursorNode.bind(ReadCursorNode.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.compile.CursorNode.bind(CursorNode.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java)
<br>
&nbsp;&nbsp; at
org.apache.derby.impl.jdbc.EmbedStatement.executeQuery(EmbedStatement.java)
<br>
&nbsp;&nbsp; at vi.hotspot.database.DataInterface._query(DataInterface.java:181)
<br>
&nbsp;&nbsp; at vi.hotspot.database.DataInterface.query(DataInterface.java:160)
<br>
&nbsp;&nbsp; at
vi.hotspot.database.UpdateManager.updatePartialTable(UpdateManager.java:518)
<br>
&nbsp;&nbsp; at
vi.hotspot.database.UpdateManager.updatePartialTables(UpdateManager.java:619)
<br>
&nbsp;&nbsp; at vi.hotspot.database.UpdateManager.run(UpdateManager.java:924)
<br>
&nbsp;&nbsp; at java.lang.Thread.run(Thread.java:534)
<br>
vi.hotspot.exception.ServerTransactionException
<br>
&nbsp;&nbsp; at
vi.hotspot.database.UpdateManager.updatePartialTable(UpdateManager.java:555)
<br>
&nbsp;&nbsp; at
vi.hotspot.database.UpdateManager.updatePartialTables(UpdateManager.java:619)
<br>
&nbsp;&nbsp; at vi.hotspot.database.UpdateManager.run(UpdateManager.java:924)
<br>
&nbsp;&nbsp; at java.lang.Thread.run(Thread.java:534)
<br>
<br>
Derby is running in standalone mode.
<br>
<br>
Cheers,
<br>
<br>
Chris
<br>
<br>
<br>
<br>
</div>
</body>
</html>

Mime
View raw message