Problem with DataFileCache.get

Hello,

we have a site where HSQL is installed and since some days HSQL keeps consuming more and more RAM. The log shows the error message below that occurs very often like 50'000 times a day. From searching the Internet it seems that this is a problem with a corrupted database file.

Could anyone confirm this or give a hint what the problem could be? If it is a currption problem, is there a way to repair the database file? We might clear the HSQL database and restart the application to see whether the problem goes away. Before doing that I wold like to checkout whether there is a way to repair the database without having to clear it.

Thanks for any help or hints.

at org.hsqldb.persist.Cache$CachedObjectComparator.longKey(Unknown Source)

at org.hsqldb.map.BaseHashMap.getObjectLookup(Unknown Source)

at org.hsqldb.persist.Cache.get(Unknown Source)

at org.hsqldb.persist.DataFileCache.get(Unknown Source)

at org.hsqldb.persist.RowStoreAVLDisk.get(Unknown Source)

at org.hsqldb.index.NodeAVLDisk.findNode(Unknown Source)

at org.hsqldb.index.NodeAVLDisk.getLeft(Unknown Source)

at org.hsqldb.index.NodeAVLDisk.child(Unknown Source)

at org.hsqldb.index.IndexAVL.insert(Unknown Source)

at org.hsqldb.persist.RowStoreAVL.indexRow(Unknown Source)

at org.hsqldb.persist.RowStoreAVLDisk.indexRow(Unknown Source)

at org.hsqldb.TransactionManager2PL.addInsertAction(Unknown Source)

at org.hsqldb.Session.addInsertAction(Unknown Source)

at org.hsqldb.Table.insertSingleRow(Unknown Source)

at org.hsqldb.StatementDML.insertSingleRow(Unknown Source)

at org.hsqldb.StatementInsert.getResult(Unknown Source)

at org.hsqldb.StatementDMQL.execute(Unknown Source)

at org.hsqldb.Session.executeCompiledStatement(Unknown Source)

at org.hsqldb.Session.executeCompiledBatchStatement(Unknown Source)

at org.hsqldb.Session.execute(Unknown Source)

at org.hsqldb.jdbc.JDBCPreparedStatement.executeBatch(Unknown Source)

at com.zaxxer.hikari.pool.ProxyStatement.executeBatch(ProxyStatement.java:128)

at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeBatch(HikariProxyPreparedStatement.java)

at io.vertx.ext.jdbc.impl.actions.JDBCBatch.execute(JDBCBatch.java:92)

at io.vertx.ext.jdbc.impl.actions.JDBCBatch.execute(JDBCBatch.java:32)

at io.vertx.ext.jdbc.impl.actions.AbstractJDBCAction.handle(AbstractJDBCAction.java:58)

at io.vertx.ext.jdbc.impl.actions.AbstractJDBCAction.lambda$execute$0(AbstractJDBCAction.java:66)

at io.vertx.ext.jdbc.impl.actions.AbstractJDBCAction$$Lambda$744/24848340.handle(Unknown Source)

at io.vertx.core.impl.ContextImpl.lambda$executeBlocking$1(ContextImpl.java:273)

at io.vertx.core.impl.ContextImpl$$Lambda$28/4410568.run(Unknown Source)

at io.vertx.core.impl.TaskQueue.run(TaskQueue.java:76)

at io.vertx.core.impl.TaskQueue$$Lambda$8/30398763.run(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)

at io.netty.util.concurrent.FastThreadLocalRunnable.run(FastThreadLocalRunnable.java:30)

at java.lang.Thread.run(Unknown Source)

_______________________________________________
Hsqldb-user mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hsqldb-user