Just another note, you aren't getting Out of Memory Errors are you?. The
docs say the Soft LRU cache is experimental and has been known to cause OOM?
On 3/04/2014 10:29 PM, Steve McLeod wrote:
Hi David,
I use H2 as an embedded database in desktop software with a
substantial user base. I also occasionally get crash reports with
similar errors. A few years ago this was frequent, but year after year
these have been been becoming infrequent.
As far as I can tell, it happens sporadically when someone suddenly
loses power while H2 is writing.
I minimised this problem by reducing my use of long-running
transactions. As much as possible I use auto-commit on every write.
On Wednesday, 2 April 2014 12:47:57 UTC+2, David Anstee wrote:
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]
<mailto:[email protected]>.
To post to this group, send email to [email protected]
<mailto:[email protected]>.
Visit this group at http://groups.google.com/group/h2-database.
For more options, visit https://groups.google.com/d/optout.
--
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.
