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
This sounds like a bug. Unfortunately I can't reproduce the problem so far. I have a few questions: I am very interested in analyzing and solving this problem. Corruption problems have top priority for me. I have a few question: - What is your database URL? - What version H2 are you using? - With which version of H2 was this database created? You can find it out using: select * from information_schema.settings where name='CREATE_BUILD' - Did you use multiple connections? - Do you use any settings or special features (for example, the setting LOG=0, or two phase commit, linked tables, cache settings)? - Is the application multi-threaded? - On what operating system, file system, and virtual machine (java -version)? - How big is the database (file sizes)? - Is it possible to reproduce this problem using a fresh database (sometimes, or always)? - Are there any other exceptions (maybe in the .trace.db file)? Could you send them please? - Do you still have any .trace.db files, and if yes could you send them? Regards, Thomas --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
