Ziheng Sun

h2 mv.db file is locked

1

``` 2024-09-07 22:07:25.602671-04:00 database: flush org.h2.message.DbException: General error: "org.h2.mvstore.MVStoreException: The file is locked: /ho$ at org.h2.message.DbException.get(DbException.java:212) at org.h2.message.DbException.convert(DbException.java:407) at org.h2.mvstore.db.Store.lambda$new$0(Store.java:122) at org.h2.mvstore.MVStore.handleException(MVStore.java:1546) at org.h2.mvstore.MVStore.panic(MVStore.java:371) at org.h2.mvstore.MVStore.(MVStore.java:291) at org.h2.mvstore.MVStore$Builder.open(MVStore.java:2035) at org.h2.mvstore.db.Store.(Store.java:133)...

need to add the shutdown compact into the preloading or make it automatic

1

This H2 giant mv.db file is a very annoying issue https://geoweaver.dev/blog/h2_database_cleanup/ Should add it into the predestroy step or automatically compact the database every n times of database queries, especially...

``` (base) [zsun@hop-amd-1 ~]$ tail -300 geoweaver.log at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:330) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:113) at org.springframework.beans.factory.support.ConstructorResolver.resolveConstructorArguments(ConstructorResolver.java:684) at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:501) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1352) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1195) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:582) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542) at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveInnerBean(BeanDefinitionValueResolver.java:374) at...