Hello I'm using h2 embedded within smartfoxserver (a game server). My
DB is running on Linux CentOS.
H2 version : 1.0.60
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.
