Hello, I get very often corrupted H2 databases, I'm able to recover them with the recovery tool but this is getting annoying because while the database is corrupt all insertions fail.
I'm using one of the latest H2 stable releases "h2-1.3.172.jar" yet the database gets corrupt, by analysing the database I realize somehow more than one row with the same unique id is inserted in a table with several thousands rows. Hence further insertions in the table fail. The database is shared between 2 windows machines running Java with the connection String "jdbc:h2:C:\HomeDir\db\mydb;create=true;AUTO_SERVER=TRUE;AUTO_RECONNECT=TRUE;TRACE_MAX_FILE_SIZE=3" The database would work well if it weren't for these sporadic corruptions which happen regularly every month or so. Thank you for your help. -- 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.
