Are you using two-phase commit? If yes then have a look at this post: https://groups.google.com/group/h2-database/browse_thread/thread/2fb61bd17fb8dad9
wburzyns On Apr 22, 5:52 pm, Noel Grandin <[email protected]> wrote: > You probably have an open transaction that causes the transaction log > to grow and grow. > > > > > > > > On Sun, Apr 22, 2012 at 14:45, Michael Spector <[email protected]> wrote: > > Hello, > > > We're stuck on the following problem. Sometimes, the database enters > > such a state, so it starts growing to an enormous size (several gigs) > > without control. I tried to see whether there's a bug in my code, > > which leads to wrong insertions to the database, but the data itself > > takes only 5% of the database file size. > > > Below are my actions: > > > # ls -lsh > > 7.0G -rw-r--r-- 1 michael michael 7.2G 2012-04-22 10:34 mydb.h2.db > > > I tried to connect to the database, and dump it to an SQL file: > > > # java -cp org.h2_1.3.163.jar org.h2.tools.Shell -url > > "jdbc:h2:mydb;CIPHER=AES" -user test -password "test test" -driver > > org.h2.Driver > > sql> EXPORT TO '/tmp/test.sql' > > > # ls -lsh /tmp/dump.sql > > 340M -rw-r--r-- 1 michael michael 340M 2012-04-22 10:35 > > test.sql > > > I tried to defragment the database, and I've got this error: > > > sql> SHUTDOWN DEFRAG; > > Error: org.h2.jdbc.JdbcSQLException: Database is already closed (to > > disable automatic closing at VM shutdown, add > > ";DB_CLOSE_ON_EXIT=FALSE" to the db URL) [90121-163] > > > Then I looked at the database size, it has grown to 8G! > > > # ls -lsh > > 7.9G -rw-r--r-- 1 michael michael 8.0G 2012-04-22 10:47 mydb.h2.db > > > Any help will be appreciated! > > > -- > > Michael > > > -- > > 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 > > athttp://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.
