PageStore + MVCC was an easy way to get different problems. Your corruption may be caused by it, but of course I can't be sure.
If you always shutdown your database properly, your code doesn't try to interrupt() threads that work with embedded database and your system has reliable power source MVStore should be stable. If your system or your application may not close database properly, PageStore hypothetically should be safer. It doesn't mean that MVStore will be corrupted on abnormal process termination. Usually database can be opened normally, but it isn't 100% reliable. However, MVStore in 1.4.199 is more stable, than in 1.4.197 and older versions. Note that for PageStore without MVCC you need to lock tables in the same order in all your transactions. Whatever you'll choose you need to perform regular online (or offline) backup procedure. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at https://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
