Also, another information.
I added DEFRAG_ALWAYS=TRUE and now when I shutdow compact the
database, I have the following error:
first time
java.lang.RuntimeException: Undo entry not written
at org.h2.message.DbException.throwInternalError(DbException.java:
228)
at org.h2.store.PageLog.addUndo(PageLog.java:486)
at org.h2.store.PageStore.free(PageStore.java:1211)
at org.h2.store.PageStore.free(PageStore.java:1194)
at org.h2.store.PageStore.swap(PageStore.java:675)
at org.h2.store.PageStore.compact(PageStore.java:586)
at org.h2.engine.Database.closeOpenFilesAndUnlock(Database.java:1198)
at org.h2.engine.Database.close(Database.java:1148)
at org.h2.engine.Database.removeSession(Database.java:1027)
at org.h2.engine.Session.close(Session.java:563)
at
org.h2.command.dml.TransactionCommand.update(TransactionCommand.java:
110)
at org.h2.command.CommandContainer.update(CommandContainer.java:73)
at org.h2.command.Command.executeUpdate(Command.java:226)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:177)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)
second time
java.lang.RuntimeException: not free: [399989] stream data key:75832
pos:11 remaining:0
at org.h2.message.DbException.throwInternalError(DbException.java:
228)
at org.h2.store.PageStore.compact(PageStore.java:693)
at org.h2.store.PageStore.compact(PageStore.java:523)
at org.h2.engine.Database.closeOpenFilesAndUnlock(Database.java:1198)
at org.h2.engine.Database.close(Database.java:1148)
at org.h2.engine.Database.removeSession(Database.java:1027)
at org.h2.engine.Session.close(Session.java:563)
at
org.h2.command.dml.TransactionCommand.update(TransactionCommand.java:
110)
at org.h2.command.CommandContainer.update(CommandContainer.java:73)
at org.h2.command.Command.executeUpdate(Command.java:226)
at org.h2.jdbc.JdbcStatement.executeInternal(JdbcStatement.java:177)
at org.h2.jdbc.JdbcStatement.execute(JdbcStatement.java:152)
at
com.infovista.mserver.actions.OJBLaunchForH2$OJBRun.stopNow(OJBLaunchForH2.java:
116)
at
com.infovista.mserver.actions.OJBLaunch.actionPerformed(OJBLaunch.java:
256)
at com.infovista.mserver.ManagementServer.stop(ManagementServer.java:
2545)
at
com.infovista.mserver.ManagementServerSvc.stop(ManagementServerSvc.java:
79)
at org.tanukisoftware.wrapper.WrapperManager
$13.run(WrapperManager.java:4255)
If I removed the option, no error.
On 20 fév, 19:49, Thomas Mueller <[email protected]> wrote:
> Hi,
>
> If you want, I have some code that could be used as a starting point.
> It's work in progress.
>
> Warning: I havent test it; I didn't run it at all. It could be
> completely wrong, and possibly corrupt the database. Also, the term
> "TRANSACTION_TIMEOUT" is misleading and has to be changed (it should
> be something like "really maximum transaction log size; if the
> transaction log is larger than this then the transaction of the
> session with the oldest open transaction is rolled back").
>
> http://h2database.com/p.html#29e32a33bca7541cb70ea3cc9d483814
>
> Regards,
> Thomas
--
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.
