Hi, In addition, I'd try to use a Smart-UPS (battery backup), which can shutdown your machine properly after a certain amount of time. Thus, avoiding the corruptions, due to a power failure.
On May 25, 2:59 pm, Thomas Mueller <[email protected]> wrote: > Hi, > > I suggest to upgrade to a newer version of H2. In version 1.1.108, a > bug was fixed that could cause data corruption (see > alsohttp://www.h2database.com/html/changelog.html"When the shutdown hook > closed the database, the last log file was deleted too early. This > could cause uncommitted changes to be persisted. In some cases, this > could cause data corruption."). > > You are right, the recovery tool create the foreign keys before > inserting data. This doesn't work in some cases. I will fix this > problem in the next release. > > > It also fails trying to add the "sa" user, which I also think is a bug. > > This is documented > athttp://www.h2database.com/html/advanced.html#using_recover_tool: "If > you run the script against a database that was created with the same > user, or if there are conflicting users, running the script will fail. > Consider running the script against a database that was created with a > user name that is not in the script." > > Regards, > Thomas > > 2009/5/25 María Arias de Reyna <[email protected]>: > > > > > > >> If I run the recovery tool and then > >> do a runscript, the database will be recovered? > > > Anyway, I tried this and the recovery tool doesn't work well. It > > extracts the data on a wrong order, making the runscript fail because > > it tries to add data before the foreign keys are fully inserted on > > their referenced tables. > > > Table A has a foreign key referencing Table B > > The RunScript tries to add the data on table A before adding the data > > on table B, so it fails (the foreign key doesn't have a proper > > reference).- Hide quoted text - > > - Show quoted text - --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
