Thank you you response. There are three things you could try (1) upgrade to the latest version - We might not be able to do this immediately as this would require good testing of the application as it is already running in the production environment.
(2) turn off MVCC - Would it cause the read/write to the database to become noticeably slow? (3) see if you reproduce the problem and then generate a standalone test case - Right now we don't have a standalone test case to reproduce that as we don't know under what circumstance it occurs. It just occurred once and a JBoss restart could recover from the problem. Regards- Sanjeev. On Fri, Sep 6, 2013 at 2:48 PM, Noel Grandin <[email protected]> wrote: > There are three things you could try > (1) upgrade to the latest version > (2) turn off MVCC > (3) see if you reproduce the problem and then generate a standalone test > case > > In particular, MVCC is still a little bit experimental. > It works for some people, but not for others, and we're no longer actively > working on the feature, so your chances of a bugfix are slim. > > > On 2013-09-06 09:26, Sanjeev Gour wrote: > > Update: We are using version 1.3.168. > > On Friday, 6 September 2013 12:51:20 UTC+5:30, Sanjeev Gour wrote: >> >> Recently we saw the "data leaf table" related error in our environment >> and not sure what could have cause it. We are using the following options- >> >> *DB_CLOSE_ON_EXIT=FALSE;LOCK_TIMEOUT=10000;CACHE_SIZE= >> 131072;CACHE_TYPE=SOFT_LRU;MVCC=TRUE* >> >> We are using it under JBoss and due to this error the JBoss data source >> was unable to connect to this DB. Here is the complete stack trace taken >> from the trace file- >> > > -- 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/groups/opt_out.
