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.
