Hi, I'm sorry, but I'm afraid you need to upgrade to a more recent version of H2. It looks like the database file is corrupt. If you need to recover the data, use the Recover tool of version 1.0.60 or (probably better) of version 1.1.119 - download from http://code.google.com/p/h2database/downloads/list - After that, you need to create a new database. I suggest to use version 1.2.147, it is known to be more stable than version 1.0.60. See also http://h2database.com/html/advanced.html#using_recover_tool
Regards, Thomas > H2 info.BUILD_ID : 60 > JDBC URL : jdbc:h2:tcp://localhost:9009/examples > DB size : about128 MB > I'm using the web inteface and DB seems working perfect (I can run > queries without issues) > > > When I try to run script to 'backup.sql' I got following java stack > error: > > General error: java.lang.Error: File ID mismatch got=0 expected=925 > pos=219042 true org.h2.store.diskf...@86e817 blockCount:0 [HY000-60] > org.h2.jdbc.JdbcSQLException: General error: java.lang.Error: File ID > mismatch got=0 expected=925 pos=219042 true > org.h2.store.diskf...@86e817 blockCount:0 [HY000-60] > at org.h2.message.Message.getSQLException(Message.java:84) > at org.h2.message.Message.convert(Message.java:169) > at org.h2.command.Command.executeQueryLocal(Command.java:73) > at org.h2.server.TcpServerThread.process(TcpServerThread.java:220) > at org.h2.server.TcpServerThread.run(TcpServerThread.java:97) > at java.lang.Thread.run(Thread.java:619) > Caused by: java.lang.Error: File ID mismatch got=0 expected=925 > pos=219042 true org.h2.store.diskf...@86e817 blockCount:0 > at org.h2.message.Message.getInternalError(Message.java:121) > at org.h2.store.DiskFile.getRecord(DiskFile.java:429) > at org.h2.store.Storage.getRecord(Storage.java:65) > at org.h2.index.ScanIndex.getNextRow(ScanIndex.java:238) > at org.h2.index.ScanCursor.next(ScanCursor.java:71) > at org.h2.command.dml.ScriptCommand.query(ScriptCommand.java:239) > at org.h2.command.CommandContainer.query(CommandContainer.java:73) > at org.h2.command.Command.executeQueryLocal(Command.java:71) > ... 3 more > > at org.h2.engine.SessionRemote.done(SessionRemote.java:298) > at org.h2.command.CommandRemote.executeQuery(CommandRemote.java: > 130) > at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152) > at org.h2.server.web.WebThread.getResult(WebThread.java:1387) > at org.h2.server.web.WebThread.query(WebThread.java:1049) > at org.h2.server.web.WebThread.process(WebThread.java:375) > at org.h2.server.web.WebThread.processRequest(WebThread.java:131) > at org.h2.server.web.WebThread.run(WebThread.java:158) > > What's wrong ? I did the same sript to on a same H2 version installed > on win XP (my dev machine) and it works just fine ! > > Thanks > > -- > 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. > > -- 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.
