Hi Thomas,
I'd like to let you know that version 1.117 using MVCC still results
in a corrupted database sometimes. From a user's crash report:
...
Caused by: org.h2.jdbc.JdbcSQLException: General error:
java.lang.RuntimeException: File ID mismatch got=0 expected=111
pos=2904429 true org.h2.store.DiskFile:/Users/BassW/Library/
Application Support/Poker Copilot/database/pokercopilot.data.db
blockCount:0; SQL statement:
select top 10000 g.gameid, downcard1, downcard2, flop1, flop2, flop3,
turn, river, g.startTime, takeInCents, takeInBigBlinds from game g
join gameplayersummary gps on g.gameid = gps.gameid and g.heroPlayerId
= gps.playerid where ishero=true and isplaymoney=? and
istournament=? and gps.startTime>=? order by g.startTime desc
[50000-117]
at org.h2.message.Message.getSQLException(Message.java:105)
at org.h2.message.Message.convert(Message.java:274)
at org.h2.message.Message.convert(Message.java:243)
at org.h2.command.Command.executeQueryLocal(Command.java:144)
at org.h2.command.Command.executeQuery(Command.java:123)
at org.h2.jdbc.JdbcPreparedStatement.executeQuery
(JdbcPreparedStatement.java:99)
This is happening less frequently that in earlier versions. Once in
the last week out of thousands of user sessions.
I'm afraid I don't have repro steps. This is really just an FYI.
Regards,
Steve McLeod
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
