Hi
I use H2 with an embeded app, I have a table with 6.000.000, I tried
to delete 300.000 but a got a exception "Java Heap Space", I tried
again deleting records by criteria, and this solve my problem...
BUT, when I make a query for data that a deleted, its show result with
data that already deleted.
I run again my delete query and this show me this exception :
General error: java.lang.RuntimeException: File ID mismatch got=0
expected=47 pos=12838178 true org.h2.store.DiskFile:C:\Historico\bd
\anexoh.data.db blockCount:0 [50000-78] HY000/50000 (Ayuda)
org.h2.jdbc.JdbcSQLException: General error:
java.lang.RuntimeException: File ID mismatch got=0 expected=47
pos=12838178 true org.h2.store.DiskFile:C:\Historico\bd\anexoh.data.db
blockCount:0 [50000-78]
at org.h2.message.Message.getSQLException(Message.java:103)
at org.h2.message.Message.convert(Message.java:257)
at org.h2.command.Command.executeUpdate(Command.java:210)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:163)
at org.h2.server.web.WebThread.getResult(WebThread.java:1712)
at org.h2.server.web.WebThread.query(WebThread.java:1275)
at org.h2.server.web.WebThread.process(WebThread.java:442)
at org.h2.server.web.WebThread.processRequest(WebThread.java:184)
at org.h2.server.web.WebThread.process(WebThread.java:239)
at org.h2.server.web.WebThread.run(WebThread.java:194)
Caused by: java.lang.RuntimeException: File ID mismatch got=0
expected=47 pos=12838178 true org.h2.store.DiskFile:C:\Historico\bd
\anexoh.data.db blockCount:0
at org.h2.message.Message.getInternalError(Message.java:179)
at org.h2.store.DiskFile.getRecord(DiskFile.java:581)
at org.h2.store.Storage.getRecord(Storage.java:94)
at org.h2.index.ScanIndex.getRow(ScanIndex.java:104)
at org.h2.table.TableData.getRow(TableData.java:95)
at org.h2.index.BtreeIndex.getRow(BtreeIndex.java:344)
at org.h2.index.BtreeCursor.get(BtreeCursor.java:78)
at org.h2.table.TableFilter.getValue(TableFilter.java:687)
at
org.h2.expression.ExpressionColumn.getValue(ExpressionColumn.java:170)
at org.h2.expression.Comparison.getValue(Comparison.java:202)
at org.h2.expression.ConditionAndOr.getValue(ConditionAndOr.java:
86)
at org.h2.expression.ConditionAndOr.getValue(ConditionAndOr.java:
93)
at org.h2.expression.ConditionAndOr.getValue(ConditionAndOr.java:
93)
at org.h2.expression.Expression.getBooleanValue(Expression.java:
188)
at org.h2.command.dml.Delete.update(Delete.java:58)
at org.h2.command.CommandContainer.update(CommandContainer.java:
69)
at org.h2.command.Command.executeUpdate(Command.java:205)
... 7 more
Please, I think it's a bug, because a I am using the last version of
H2.
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
-~----------~----~----~----~------~----~------~--~---
