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 at > http://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.
