search

doubleSlashde / KeepTime

Application to track your time spent on different projects each day.
GNU General Public License v3.0
8 stars 3 forks source link

IPTE-19: update maven dependencies #78

Closed mplieske closed 3 years ago

mplieske commented 3 years ago

404 of dependency check is gone now. h2 works fine without version tag 😄

Death111 commented 3 years ago

Getting exception on start when existing db is in place:

21:04:45.687 [JavaFX-Launcher] INFO org.flywaydb.core.internal.license.VersionPrinter - Flyway Community Edition 6.4.4 by Redgate 21:04:45.699 [JavaFX-Launcher] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting... 21:04:46.996 [JavaFX-Launcher] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization. org.h2.jdbc.JdbcSQLNonTransientException: Allgemeiner Fehler: "java.lang.IllegalStateException: Unable to read the page at position 2192975941731530 [1.4.200/6]" General error: "java.lang.IllegalStateException: Unable to read the page at position 2192975941731530 [1.4.200/6]" [50000-200] at org.h2.message.DbException.getJdbcSQLException(DbException.java:505) at org.h2.message.DbException.getJdbcSQLException(DbException.java:429) at org.h2.message.DbException.get(DbException.java:194) at org.h2.message.DbException.convert(DbException.java:347) at org.h2.engine.Database.openDatabase(Database.java:333) at org.h2.engine.Database.(Database.java:301) at org.h2.engine.Engine.openSession(Engine.java:74) at org.h2.engine.Engine.openSession(Engine.java:192) at org.h2.engine.Engine.createSessionAndValidate(Engine.java:171) at org.h2.engine.Engine.createSession(Engine.java:166) at org.h2.engine.Engine.createSession(Engine.java:29) at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:340) at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:173) at org.h2.jdbc.JdbcConnection.(JdbcConnection.java:152) at org.h2.Driver.connect(Driver.java:69) at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:358) at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:477) at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:560) at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:115) at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) at org.flywaydb.core.internal.jdbc.JdbcUtils.openConnection(JdbcUtils.java:56) at org.flywaydb.core.internal.jdbc.JdbcConnectionFactory.(JdbcConnectionFactory.java:80) at org.flywaydb.core.Flyway.execute(Flyway.java:456) at org.flywaydb.core.Flyway.migrate(Flyway.java:159) at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:65) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1853) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1790) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:516) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:324) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:311) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1109) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:869) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:551) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:758) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:750) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:405) at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1237) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) at de.doubleslash.keeptime.Main.init(Main.java:88) at com.sun.javafx.application.LauncherImpl.launchApplication1(LauncherImpl.java:841) at com.sun.javafx.application.LauncherImpl.lambda$launchApplication$1(LauncherImpl.java:182) at java.lang.Thread.run(Thread.java:748) Caused by: java.lang.IllegalStateException: Unable to read the page at position 2192975941731530 [1.4.200/6] at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:950) at org.h2.mvstore.MVStore.readPage(MVStore.java:2213) at org.h2.mvstore.MVMap.readPage(MVMap.java:672) at org.h2.mvstore.MVMap.readOrCreateRootPage(MVMap.java:688) at org.h2.mvstore.MVMap.setRootPos(MVMap.java:682) at org.h2.mvstore.MVStore.openMap(MVStore.java:576) at org.h2.mvstore.MVStore.openMap(MVStore.java:535) at org.h2.mvstore.MVStore.openMap(MVStore.java:516) at org.h2.mvstore.MVStore.removeMap(MVStore.java:2742) at org.h2.engine.Database.handleUpgradeIssues(Database.java:866) at org.h2.engine.Database.open(Database.java:742) at org.h2.engine.Database.openDatabase(Database.java:307) ... 45 common frames omitted Caused by: java.lang.IllegalStateException: Unsupported type 17 [1.4.200/3] at org.h2.mvstore.DataUtils.newIllegalStateException(DataUtils.java:950) at org.h2.mvstore.type.ObjectDataType.newType(ObjectDataType.java:165) at org.h2.mvstore.type.ObjectDataType.read(ObjectDataType.java:229) at org.h2.mvstore.type.ObjectDataType.read(ObjectDataType.java:114) at org.h2.mvstore.Page.read(Page.java:605) at org.h2.mvstore.Page.read(Page.java:239) at org.h2.mvstore.MVStore.readPage(MVStore.java:2211) ... 55 common frames omitted

Error happens with my existing db and also when I created a new instance with the current develop (but only in 1 of 2 tries.. 1 time it worked)... Opening the database after this error with the old version does not work as well (fails with another error). So database seems to be corrupted when this happens.

Found: https://github.com/h2database/h2database/issues/2263#issuecomment-555965165 which suggets that upgrading h2 db should be done via sql dump and restore. This is unexpected.

Please have a look I you have an idea to this problem. I guess we need to have some upgrade mechanism to follow the recommended way for h2 upgrades. Not sure if we should create a release with the old h2 version in place - or we need to have the mechanism first.

Death111 commented 3 years ago

works for me now for ~1 week. merging