El 31/01/10 05:46, Thomas Mueller escribió: >> I am curious of the maturity and stability of page store. >> > I think it is stable now. Future versions will not be able to create > databases in the old format (converting will still be supported). > >> when a user's computer unexpectedly loses power, >> the database tends to become corrupted. >> Are you working with a journaling files-system ?
Windows or Linux ? > I ran an automated test for this case (using an old computer and a > timer). So far I only tested some simple operations > (org.h2.test.poweroff.TestRecover). My results so far are that > databases can become corrupt in some cases with or without the page > store. With recent versions (with page store; version 1.2.127 I > believe) the risk was less than 1:20 (the test ran over the weekend > without a corrupt database). Some time ago, I also tested other Java > databases, and they did also become corrupt sometimes. I'm using a > Linux kernel, I think the file system is ext2. My plan is to extend > the test case (use different operations, indexes, larger rows). I'm > not sure if it's possible to solve all problems, because in some cases > it didn't look like a database problem. But I will try. Do not know if there was pure luck, but can't remember last time we found a corrupted database. I work with various linux versions (new and old) with filesystems : reiserfs, ext3 and ext4 (all of this are journaling file systems). Many times in applications testing I use: " sudo killall -9 java" that is the worst case you can generate without power-off , to see if something goes wrong, but this don't seems to corrupt database. I know that this is different in many ways to power loss , but maybe used filesystem can make less probable that situation. -- 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.
