Hi, You have sent the same question to http://stackoverflow.com/questions/17488935/continuous-increase-in-h2-db-size-after-dropping-and-loading-same-data-repeatedl
Please don't use _both_ the Google Group and StackOverflow at the same time for the same question. Use one or the other. Did you run the recover tool _before_ you restored it? To find out what is using the disk space you would need to run it _before_ that (when the database file is large). Regards, Thomas On Mon, Jul 8, 2013 at 8:53 AM, Noel Grandin <[email protected]<javascript:_e({}, 'cvml', '[email protected]');> > wrote: > This is pretty much guaranteed to be because of open transactions. > Unfortunately there is no easy way of finding them, short of monitoring > your own code to check that it is either using AutoCommit or calling > commit()/rollback() timeously. > > > On 2013-07-08 07:31, [email protected] <javascript:_e({}, 'cvml', > '[email protected]');> wrote: > > I have an H2 db named temp.h2.db which is accessed by two applications. > The first one accesses it through embedded mode and the second one through > server mode. Through the second application I load data into the database. > But even when I drop the previous values and load the same data repeatedly, > the db size increases. From about 200mb, it increased to about 2Gb. This > happens even when I drop all tables and load a fresh set of data (which is > almost of the same size as the previous set of data). Is this a bug? > > > -- > 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] <javascript:_e({}, > 'cvml', 'h2-database%[email protected]');>. > To post to this group, send email to > [email protected]<javascript:_e({}, 'cvml', > '[email protected]');> > . > Visit this group at http://groups.google.com/group/h2-database. > For more options, visit https://groups.google.com/groups/opt_out. > > > -- 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.
