Hi, I have a user that constantly experiences a problem with their database. The error they are getting is the following:
org.h2.jdbc.JdbcSQLException: General error: java.lang.RuntimeException: File ID mismatch got=0 expected=110 pos=11712 false org.h2.store.DiskFile:C:\Window Cleaner Pro\db \wcp.index.db blockCount:0 [50000-111] at org.h2.message.Message.getSQLException(Message.java:107) at org.h2.message.Message.convert(Message.java:279) at org.h2.table.TableData.addRow(TableData.java:137) at org.h2.log.UndoLogRecord.undo(UndoLogRecord.java:118) at org.h2.engine.Session.rollbackTo(Session.java:526) at org.h2.command.Command.executeUpdate(Command.java:254) at org.h2.server.TcpServerThread.process(TcpServerThread.java:297) at org.h2.server.TcpServerThread.run(TcpServerThread.java:136) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.RuntimeException: File ID mismatch got=0 expected=110 pos=11712 false org.h2.store.DiskFile:C:\Window Cleaner Pro\db\wcp.index.db blockCount:0 at org.h2.message.Message.throwInternalError(Message.java:187) at org.h2.store.DiskFile.getRecord(DiskFile.java:579) at org.h2.store.Storage.getRecord(Storage.java:94) at org.h2.index.BtreeIndex.getPage(BtreeIndex.java:181) at org.h2.index.BtreeNode.add(BtreeNode.java:104) at org.h2.index.BtreeIndex.add(BtreeIndex.java:223) at org.h2.table.TableData.addRow(TableData.java:119) ... 6 more at org.h2.engine.SessionRemote.done(SessionRemote.java:525) at org.h2.command.CommandRemote.executeUpdate(CommandRemote.java:193) at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:164) at snaq.db.CachedStatement.execute(CachedStatement.java:201) I have tried to rebuild the database from scratch using SQL statements but the problem still occurs. It seems to be very intimitent. I have also tried deleting the index and log files to no avail. Here is another sample of the kind of errors this user gets: com.truecommerce.exceptions.unchecked.UncheckedException: com.truecommerce.exceptions.checked.FailedException: org.h2.jdbc.JdbcSQLException: General error: java.lang.Error: File ID mismatch got=0 expected=172 pos=11520 false org.h2.store.DiskFile:C: \Window Cleaner Pro\db\wcp.index.db blockCount:0 [50000-72] at org.h2.message.Message.getSQLException(Message.java:92) at org.h2.message.Message.convert(Message.java:175) at org.h2.table.TableData.addRow(TableData.java:116) at org.h2.command.dml.Insert.update(Insert.java:96) at org.h2.command.CommandContainer.update(CommandContainer.java:69) at org.h2.command.Command.executeUpdate(Command.java:198) at org.h2.server.TcpServerThread.process(TcpServerThread.java:279) at org.h2.server.TcpServerThread.run(TcpServerThread.java:126) at java.lang.Thread.run(Unknown Source) Caused by: java.lang.Error: File ID mismatch got=0 expected=172 pos=11520 false! org.h2.store.DiskFile:C:\Window Cleaner Pro\db \wcp.index.db blockCount:0 at org.h2.message.Message.getInternalError(Message.java:129) at org.h2.store.DiskFile.getRecord(DiskFile.java:507) at org.h2.store.Storage.getRecord(Storage.java:66) at org.h2.index.BtreeIndex.getPage(BtreeIndex.java:142) at org.h2.index.BtreeNode.add(BtreeNode.java:99) at org.h2.index.BtreeNode.add(BtreeNode.java:100) at org.h2.index.BtreeIndex.add(BtreeIndex.java:179) at org.h2.table.TableData.addRow(TableData.java:98) Any help or advice would be most appreciated. Thanks Ian --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
