Today I tried to compact a quite large database (~55GB) but that
failed with an exception in the db trace file.
At that point of time there has been around 8GB of free space on the
database partition.
H2 version is 1.2.147

Is this a known problem and has it been fixed in the latest release?

04-05 12:57:51 database: close
java.lang.RuntimeException: not free: [20145254] stream data key:75441
pos:11 remaining:0
        at
org.h2.message.DbException.throwInternalError(DbException.java:226)
        at org.h2.store.PageStore.compact(PageStore.java:665)
        at org.h2.store.PageStore.compact(PageStore.java:499)
        at
org.h2.engine.Database.closeOpenFilesAndUnlock(Database.java:1123)
        at org.h2.engine.Database.close(Database.java:1074)
        at org.h2.engine.Database.removeSession(Database.java:953)
        at org.h2.engine.Session.close(Session.java:571)
        at
org.h2.command.dml.TransactionCommand.update(TransactionCommand.java:
110)
        at
org.h2.command.CommandContainer.update(CommandContainer.java:69)
        at org.h2.command.Command.executeUpdate(Command.java:201)
        at
org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:178)
        at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:153)
        at org.h2.server.web.WebApp.getResult(WebApp.java:1316)
        at org.h2.server.web.WebApp.query(WebApp.java:1004)
        at org.h2.server.web.WebApp$1.next(WebApp.java:967)
        at org.h2.server.web.WebApp$1.next(WebApp.java:970)
        at org.h2.server.web.WebThread.process(WebThread.java:166)
        at org.h2.server.web.WebThread.run(WebThread.java:93)
        at java.lang.Thread.run(Thread.java:662)


Thanks!
Uli

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

Reply via email to