Hi Thomas, Thanks for your reply. Here is the stack trace. It is happending during insert statement. The table size is not that big also. It is about 20k+ and the disk space we have is 60TB and it is NFS mounted.
We really don't know what is the problem. Thanks for helping us. ts=2011-12-01T21:35:27.376Z level=Excep class=gov.lbl.bdm.gsiftp.GsiFTPParallelBrowsing IO Exception: "java.io.IOException: Bad file number"; "/export/home/dean/.bdm/bdmDB.f062c268ab6e375a.17.temp.db" [90031-159] org.h2.message.DbException.getJdbcSQLException(DbException.java:329) org.h2.message.DbException.get(DbException.java:158) org.h2.message.DbException.convertIOException(DbException.java:315) org.h2.store.FileStore.readFully(FileStore.java:287) org.h2.result.ResultDiskBuffer.readRow(ResultDiskBuffer.java:198) org.h2.result.ResultDiskBuffer.nextUnsorted(ResultDiskBuffer.java:216) org.h2.result.ResultDiskBuffer.next(ResultDiskBuffer.java:209)org.h2.result.LocalResult.next(LocalResult.java:229) org.h2.jdbc.JdbcResultSet.nextRow(JdbcResultSet.java:2986)org.h2.jdbc.JdbcResultSet.next(JdbcResultSet.java:116) gov.lbl.bdm.BDM_DB.insertIntoDirectory(BDM_DB.java:787) gov.lbl.bdm.gsiftp.GsiFTPParallelBrowsing.parseListingsAndTransferFileForGet(GsiFTPParallelBrowsing.java:914) gov.lbl.bdm.gsiftp.GsiFTPParallelBrowsing.browseDirsNow(GsiFTPParallelBrowsing.java:666) Thanks. Viji On Sat, Dec 3, 2011 at 9:48 AM, Thomas Mueller <[email protected] > wrote: > Hi, > > It looks like a temporary file was closed too early. Could you post > the complete stack trace please, and tell us what statement(s) you > ran? > > Regards, > Thomas > > -- > You received this message because you are subscribed to the Google Groups > "H2 Database" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/h2-database?hl=en. > h > -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
