Hi, This problem should be fixed in a later release.
> I want to know the cause of this problem As described in http://www.mail-archive.com/[email protected]/msg00870.html : If the latest row of a table is removed in a table, the index is truncated, but the space is not re-used in this case. Therefore, each time all rows of a table are updated, or all rows are deleted and new rows are inserted, the index.db file grows. Regards, Thomas On Fri, Apr 22, 2011 at 5:48 AM, A.I <[email protected]> wrote: > Hello, everyone. > > First, I'm Japanese. I'm not very good at English. Please forgive the > poor is a sentence. > > I made the past system(approximate 800 terminals), H2 Database(ver > 1.1.117) I am using. > About once a month, "index" is broken, "index" and "data" is causing a > mismatch, a problem that has become impossible to view the data. > Every time this happens, index to recreate. > > -- Questions -- > In the past, in this version, index mismatch causes the problem for? > The fact that been resolved now available? > Someone on this problem, please tell me the article or cause. > --------------------- > > I want to know the cause of this problem. And I if you know that the > latest version resolved the problem, upgrade to consider. > (Because it is difficult to system-tests, not easy to upgrade...) > > -- > 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. > > -- 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.
