Hi, We have been using H2 as an embedded database in one of our java applications and have been experiencing some database corruption issues with some of our users. We do not disable the transaction log, or the file locking as I know these can potentially cause corruption of the database but we still occasionally receive complaints of corrupted databases. As the issues have been occurring on the client’s machines it has been hard for us to track down what is causing them. The exception messages we receive when opening the H2 database also appear to vary. The most recent exception, which we had this morning, was:
org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: rowCount expected 51427 got 51390 T154.I178" [50000-175]org.h2.jdbc.JdbcSQLException: General error: "java.lang.RuntimeException: rowCount expected 51427 got 51390 T154.I178" [50000-175] In the past we have attempted to use the recovery tool to restore a database but so far we have been unable to recover a single one. I'm not sure if this is due to the process that we go through or the corruption of the database but the recovery tool never appears to work successfully. The connection string we use to the database is: "jdbc:h2:split:31:" + DBFILE + ";PAGE_SIZE=8192;CACHE_SIZE=524288;CACHE_TYPE=SOFT_LRU;database_event_listener='" + H2EventListener.class.getName() + "';USER=" + dbusername + ";PASSWORD=" + dbpassword; We have, up until last week, been using version 1-3-169.jar but have now moved to 1.3.175.jar Thanks, David -- 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 http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
