Thanks for reply! On Fri, Mar 20, 2015 at 9:20 PM, Fred&Dani&Pandora&Aquiles < [email protected]> wrote:
> Hi, > > I think the version 1.4.186 had some improvements in this area ( > http://www.h2database.com/html/changelog.html). I can't remember now if > there's some protocol to follow when upgrading the version, but one > alternative that you could try, is to test again with latest version. > I guess the improvement you are saying is: > MVStore: orphaned lob objects were not correctly removed in some cases, making the database grow unnecessarily. But I disabled MVSTORE and MVCC by "MVSTORE=FALSE;MVCC=FALSE". Does the improvement help me? > > Regards, > > Fred > > 2015-03-20 7:27 GMT-03:00 Yi, EungJun <[email protected]>: > >> >> >> On Fri, Mar 20, 2015 at 7:01 PM, EungJun Yi <[email protected]> wrote: >> >>> Hello.https://code.google.com/p/h2database/source/detail?r=5936 >>> >>> I am using H2 database in embeded mode. >>> >>> After upgrading to 1.4.184 from 1.3.176, INFORMATION_SCHEMA.lobs table >>> grows rapidly. It takes only a week to grow from 140k records to 36million >>> records.When I try to shutdown my app, it takes two hours to clean the >>> table. >>> >>> I have found the most of the records have "-3" in "table" field as >>> follows: >>> >>> ID | BYTE_COUNT | TABLE >>> ... >>> 765194 | 12707 | -3 >>> 765195 | 1670 | -3 >>> 765196 | 1314 | -3 >>> 765197 | 1276 | -3 >>> 765198 | 382 | -3 >>> 765199 | 382 | -3 >>> 765200 | 434 | -3 >>> 765201 | 1299 | -3 >>> 765202 | 353 | -3 >>> 765203 | 277 | -3 >>> ... >>> >>> As my reading of H2 source code, the record is for result set, created >>> by LocalResult.cloneLobs method added at r5942. >>> >> >> Oops, the record is created ValueLobDb.copyToResult() method added at >> r5436. >> >> >>> It seems that H2 cleans the blobs only when the database is closed. You >>> may think it is fine because the database seems to be closed automatically >>> after closeDelay since there is no user session, but it is a problem for me >>> because there are always some user sessions in my application. >>> >>> I tested it with 1.4.182, 1.4.183, 1.4.184 and 1.4.186 and only 1.4.182 >>> works fine. >>> >>> Thanks for reading. >>> >>> -- >>> You received this message because you are subscribed to a topic in the >>> Google Groups "H2 Database" group. >>> To unsubscribe from this topic, visit >>> https://groups.google.com/d/topic/h2-database/WoFDlotV7fo/unsubscribe. >>> To unsubscribe from this group and all its topics, 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. >>> >> >> -- >> 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. >> > > -- > You received this message because you are subscribed to a topic in the > Google Groups "H2 Database" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/h2-database/WoFDlotV7fo/unsubscribe. > To unsubscribe from this group and all its topics, 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. > -- 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.
