Hi all,
I have a table which contains around 60,000 rows and I am trying to delete
the rows from the table.While executing the delete operation I end up with
the following exception and
the rows are not deleted from the table.
The H2 version we are using is 1.3.168.
Do we know the cause of this exception and the solution to this problem?
org.h2.jdbc.JdbcSQLException: IO Exception: "java.io.IOException: Stream
Closed";
"/u/users/nikeadm/chorus/database/h2/chorus.1d38546ab7e30ab4.1.temp.db"
[90031-168]
at
org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
at org.h2.message.DbException.get(DbException.java:158)
at
org.h2.message.DbException.convertIOException(DbException.java:315)
at org.h2.store.FileStore.setLength(FileStore.java:359)
at org.h2.engine.UndoLog.getLast(UndoLog.java:97)
at org.h2.engine.Session.rollbackTo(Session.java:529)
at org.h2.command.Command.executeUpdate(Command.java:253)
at
org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:177)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)
at
org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:157)
at
com.ca.chorus.teiid.translator.h2util.H2UtilityFunExecution.getMetadata(H2UtilityFunExecution.java:110)
at
com.ca.chorus.teiid.translator.h2util.H2UtilityFunExecution.getMetadata(H2UtilityFunExecution.java:22)
at
org.teiid.translator.BaseDelegatingExecutionFactory.getMetadata(BaseDelegatingExecutionFactory.java:127)
[teiid-api-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]
at
com.ca.chorus.teiid.safety.SafetyHarnessExecutionFactory.getMetadata(SafetyHarnessExecutionFactory.java:189)
at
org.teiid.query.metadata.NativeMetadataRepository.loadMetadata(NativeMetadataRepository.java:73)
[teiid-engine-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]
at
org.teiid.query.metadata.ChainingMetadataRepository.loadMetadata(ChainingMetadataRepository.java:55)
[teiid-engine-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]
at org.teiid.jboss.VDBService$6.run(VDBService.java:395)
[teiid-jboss-integration-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]
at org.teiid.jboss.VDBService$7.run(VDBService.java:442)
[teiid-jboss-integration-8.7.0.FinalCAFix-SNAPSHOT.jar:8.7.0.FinalCAFix-SNAPSHOT]
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
[rt.jar:1.7.0]
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
[rt.jar:1.7.0]
at java.lang.Thread.run(Thread.java:781) [vm.jar:1.7.0]
at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: java.io.IOException: Stream Closed
at java.io.RandomAccessFile.lngth(Native Method)
[rt.jar:1.7.0]
at org.h2.store.fs.FileDisk.truncate(FilePathDisk.java:400)
at org.h2.store.FileStore.setLength(FileStore.java:354)
... 18 more
--
You received this message because you are subscribed to the Google Groups "H2
Database" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
