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.
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 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.
