H2 database corrupted: Chunk 1689 not found [2.1.214/9] #27
Description
Got the following error when starting KeepTask: Exception during pool initialization. org.h2.jdbc.JdbcSQLNonTransientException: Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]
As a google search reveals this means the db is corrupt I tried using the H2 Recover Tool java -cp h2-2.1.214.jar org.h2.tools.Recover but the resulting files did not contain my data.
In H2 changelog I found that in 2.2.222 an issue Fixed race condition in MVStore causing database corruption "File corrupted in chunk ###" was fixed changelog - not sure if it is the issue as the error message is different.
Not sure how it got to this state. The log of the day before nothing interesting is logged. The day after it started with the error.
I could only start with a fresh database for now..
KeepTask Log
20:31:06.623 [JavaFX-Launcher] INFO de.doubleslash.keeptask.App - Starting KeepTask.
20:31:07.207 [JavaFX-Launcher] INFO org.springframework.boot.SpringApplication - Starting application using Java 11.0.17 on DESKTOP-4K2M8DQ with PID 20016 (keeptask-0.0.52-SNAPSHOT.jar started by Death in xxx)
20:31:07.207 [JavaFX-Launcher] INFO org.springframework.boot.SpringApplication - No active profile set, falling back to 1 default profile: "default"
20:31:07.780 [JavaFX-Launcher] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Bootstrapping Spring Data JPA repositories in DEFAULT mode.
20:31:07.839 [JavaFX-Launcher] INFO o.s.d.r.config.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 48 ms. Found 1 JPA repository interfaces.
20:31:08.359 [JavaFX-Launcher] INFO org.flywaydb.core.internal.license.VersionPrinter - Flyway Community Edition 8.5.13 by Redgate
20:31:08.360 [JavaFX-Launcher] INFO org.flywaydb.core.internal.license.VersionPrinter - See what's new here: https://flywaydb.org/documentation/learnmore/releaseNotes#8.5.13
20:31:08.360 [JavaFX-Launcher] INFO org.flywaydb.core.internal.license.VersionPrinter -
20:31:08.385 [JavaFX-Launcher] INFO com.zaxxer.hikari.HikariDataSource - HikariPool-1 - Starting...
20:31:09.754 [JavaFX-Launcher] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
org.h2.jdbc.JdbcSQLNonTransientException: Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:554)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.get(DbException.java:212)
at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:173)
at org.h2.mvstore.db.Store.createTable(Store.java:223)
at org.h2.schema.Schema.createTable(Schema.java:776)
at org.h2.command.ddl.CreateTable.update(CreateTable.java:112)
at org.h2.engine.MetaRecord.prepareAndExecute(MetaRecord.java:77)
at org.h2.engine.Database.executeMeta(Database.java:660)
at org.h2.engine.Database.executeMeta(Database.java:634)
at org.h2.engine.Database.<init>(Database.java:357)
at org.h2.engine.Engine.openSession(Engine.java:92)
at org.h2.engine.Engine.openSession(Engine.java:222)
at org.h2.engine.Engine.createSession(Engine.java:201)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
at org.h2.Driver.connect(Driver.java:59)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at org.flywaydb.core.internal.jdbc.JdbcUtils.openConnection(JdbcUtils.java:48)
at org.flywaydb.core.internal.jdbc.JdbcConnectionFactory.<init>(JdbcConnectionFactory.java:75)
at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:147)
at org.flywaydb.core.Flyway.migrate(Flyway.java:124)
at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
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.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1156)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:910)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:731)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:408)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:307)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292)
at de.doubleslash.keeptask.App.init(App.java:70)
at com.sun.javafx.application.LauncherImpl.launchApplication1(LauncherImpl.java:825)
at com.sun.javafx.application.LauncherImpl.lambda$launchApplication$2(LauncherImpl.java:196)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.h2.mvstore.MVStoreException: Chunk 1689 not found [2.1.214/9]
at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
at org.h2.mvstore.MVStore.getChunk(MVStore.java:1384)
at org.h2.mvstore.MVStore.readPage(MVStore.java:2566)
at org.h2.mvstore.MVMap.readPage(MVMap.java:633)
at org.h2.mvstore.MVMap.readOrCreateRootPage(MVMap.java:658)
at org.h2.mvstore.MVMap.setRootPos(MVMap.java:643)
at org.h2.mvstore.MVStore.openMap(MVStore.java:702)
at org.h2.mvstore.MVStore.openMap(MVStore.java:648)
at org.h2.mvstore.tx.TransactionStore.openMap(TransactionStore.java:564)
at org.h2.mvstore.tx.TransactionStore.openVersionedMap(TransactionStore.java:550)
at org.h2.mvstore.tx.Transaction.openMap(Transaction.java:456)
at org.h2.mvstore.db.MVPrimaryIndex.<init>(MVPrimaryIndex.java:53)
at org.h2.mvstore.db.MVTable.<init>(MVTable.java:156)
at org.h2.mvstore.db.Store.createTable(Store.java:219)
... 46 common frames omitted
20:31:09.756 [JavaFX-Launcher] WARN o.s.c.a.AnnotationConfigApplicationContext - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.exception.FlywaySqlException: Unable to obtain connection from database: Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL State : HY000
Error Code : 50000
Message : Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
20:31:09.763 [JavaFX-Launcher] INFO o.s.b.a.l.ConditionEvaluationReportLoggingListener -
Error starting ApplicationContext. To display the conditions report re-run your application with 'debug' enabled.
20:31:09.784 [JavaFX-Launcher] ERROR org.springframework.boot.SpringApplication - Application run failed
org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.exception.FlywaySqlException: Unable to obtain connection from database: Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL State : HY000
Error Code : 50000
Message : Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
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.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1156)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:910)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:731)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:408)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:307)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292)
at de.doubleslash.keeptask.App.init(App.java:70)
at com.sun.javafx.application.LauncherImpl.launchApplication1(LauncherImpl.java:825)
at com.sun.javafx.application.LauncherImpl.lambda$launchApplication$2(LauncherImpl.java:196)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.flywaydb.core.internal.exception.FlywaySqlException: Unable to obtain connection from database: Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL State : HY000
Error Code : 50000
Message : Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
at org.flywaydb.core.internal.jdbc.JdbcUtils.openConnection(JdbcUtils.java:60)
at org.flywaydb.core.internal.jdbc.JdbcConnectionFactory.<init>(JdbcConnectionFactory.java:75)
at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:147)
at org.flywaydb.core.Flyway.migrate(Flyway.java:124)
at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)
... 20 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLNonTransientException: Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:554)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.get(DbException.java:212)
at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:173)
at org.h2.mvstore.db.Store.createTable(Store.java:223)
at org.h2.schema.Schema.createTable(Schema.java:776)
at org.h2.command.ddl.CreateTable.update(CreateTable.java:112)
at org.h2.engine.MetaRecord.prepareAndExecute(MetaRecord.java:77)
at org.h2.engine.Database.executeMeta(Database.java:660)
at org.h2.engine.Database.executeMeta(Database.java:634)
at org.h2.engine.Database.<init>(Database.java:357)
at org.h2.engine.Engine.openSession(Engine.java:92)
at org.h2.engine.Engine.openSession(Engine.java:222)
at org.h2.engine.Engine.createSession(Engine.java:201)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
at org.h2.Driver.connect(Driver.java:59)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at org.flywaydb.core.internal.jdbc.JdbcUtils.openConnection(JdbcUtils.java:48)
... 26 common frames omitted
Caused by: org.h2.mvstore.MVStoreException: Chunk 1689 not found [2.1.214/9]
at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
at org.h2.mvstore.MVStore.getChunk(MVStore.java:1384)
at org.h2.mvstore.MVStore.readPage(MVStore.java:2566)
at org.h2.mvstore.MVMap.readPage(MVMap.java:633)
at org.h2.mvstore.MVMap.readOrCreateRootPage(MVMap.java:658)
at org.h2.mvstore.MVMap.setRootPos(MVMap.java:643)
at org.h2.mvstore.MVStore.openMap(MVStore.java:702)
at org.h2.mvstore.MVStore.openMap(MVStore.java:648)
at org.h2.mvstore.tx.TransactionStore.openMap(TransactionStore.java:564)
at org.h2.mvstore.tx.TransactionStore.openVersionedMap(TransactionStore.java:550)
at org.h2.mvstore.tx.Transaction.openMap(Transaction.java:456)
at org.h2.mvstore.db.MVPrimaryIndex.<init>(MVPrimaryIndex.java:53)
at org.h2.mvstore.db.MVTable.<init>(MVTable.java:156)
at org.h2.mvstore.db.Store.createTable(Store.java:219)
... 46 common frames omitted
20:31:09.805 [main] ERROR de.doubleslash.keeptask.DefaultExceptionHandler - Uncaught exception on thread 'Thread[main,5,main]'.
java.lang.reflect.InvocationTargetException: null
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.base/java.lang.reflect.Method.invoke(Method.java:566)
at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:108)
at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:65)
Caused by: java.lang.RuntimeException: Exception in Application init method
at com.sun.javafx.application.LauncherImpl.launchApplication1(LauncherImpl.java:896)
at com.sun.javafx.application.LauncherImpl.lambda$launchApplication$2(LauncherImpl.java:196)
at java.base/java.lang.Thread.run(Thread.java:829)
Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'flywayInitializer' defined in class path resource [org/springframework/boot/autoconfigure/flyway/FlywayAutoConfiguration$FlywayConfiguration.class]: Invocation of init method failed; nested exception is org.flywaydb.core.internal.exception.FlywaySqlException: Unable to obtain connection from database: Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL State : HY000
Error Code : 50000
Message : Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1804)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:620)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:542)
at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335)
at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234)
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.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:322)
at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208)
at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1156)
at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:910)
at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:583)
at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:731)
at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:408)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:307)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1303)
at org.springframework.boot.SpringApplication.run(SpringApplication.java:1292)
at de.doubleslash.keeptask.App.init(App.java:70)
at com.sun.javafx.application.LauncherImpl.launchApplication1(LauncherImpl.java:825)
... 2 common frames omitted
Caused by: org.flywaydb.core.internal.exception.FlywaySqlException: Unable to obtain connection from database: Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL State : HY000
Error Code : 50000
Message : Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
at org.flywaydb.core.internal.jdbc.JdbcUtils.openConnection(JdbcUtils.java:60)
at org.flywaydb.core.internal.jdbc.JdbcConnectionFactory.<init>(JdbcConnectionFactory.java:75)
at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:147)
at org.flywaydb.core.Flyway.migrate(Flyway.java:124)
at org.springframework.boot.autoconfigure.flyway.FlywayMigrationInitializer.afterPropertiesSet(FlywayMigrationInitializer.java:66)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863)
at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800)
... 20 common frames omitted
Caused by: org.h2.jdbc.JdbcSQLNonTransientException: Allgemeiner Fehler: "Chunk 1689 not found [2.1.214/9]"
General error: "Chunk 1689 not found [2.1.214/9]"; SQL statement:
CREATE CACHED TABLE "PUBLIC"."WORK_ITEM"(
"ID" BIGINT GENERATED BY DEFAULT AS IDENTITY SEQUENCE "PUBLIC"."SYSTEM_SEQUENCE_9450382C_B246_456D_BC48_BBEFE7F46B04" NOT NULL,
"COMPLETED_DATE_TIME" TIMESTAMP,
"CREATED_DATE_TIME" TIMESTAMP,
"DUE_DATE_TIME" TIMESTAMP,
"FINISHED" BOOLEAN NOT NULL,
"NOTE" CHARACTER LARGE OBJECT NOT NULL,
"PRIORITY" CHARACTER VARYING(255) NOT NULL,
"PROJECT" CHARACTER LARGE OBJECT NOT NULL,
"TODO" CHARACTER LARGE OBJECT NOT NULL
) [50000-214]
at org.h2.message.DbException.getJdbcSQLException(DbException.java:554)
at org.h2.message.DbException.getJdbcSQLException(DbException.java:477)
at org.h2.message.DbException.get(DbException.java:212)
at org.h2.mvstore.db.Store.convertMVStoreException(Store.java:173)
at org.h2.mvstore.db.Store.createTable(Store.java:223)
at org.h2.schema.Schema.createTable(Schema.java:776)
at org.h2.command.ddl.CreateTable.update(CreateTable.java:112)
at org.h2.engine.MetaRecord.prepareAndExecute(MetaRecord.java:77)
at org.h2.engine.Database.executeMeta(Database.java:660)
at org.h2.engine.Database.executeMeta(Database.java:634)
at org.h2.engine.Database.<init>(Database.java:357)
at org.h2.engine.Engine.openSession(Engine.java:92)
at org.h2.engine.Engine.openSession(Engine.java:222)
at org.h2.engine.Engine.createSession(Engine.java:201)
at org.h2.engine.SessionRemote.connectEmbeddedOrServer(SessionRemote.java:338)
at org.h2.jdbc.JdbcConnection.<init>(JdbcConnection.java:122)
at org.h2.Driver.connect(Driver.java:59)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at org.flywaydb.core.internal.jdbc.JdbcUtils.openConnection(JdbcUtils.java:48)
... 26 common frames omitted
Caused by: org.h2.mvstore.MVStoreException: Chunk 1689 not found [2.1.214/9]
at org.h2.mvstore.DataUtils.newMVStoreException(DataUtils.java:1004)
at org.h2.mvstore.MVStore.getChunk(MVStore.java:1384)
at org.h2.mvstore.MVStore.readPage(MVStore.java:2566)
at org.h2.mvstore.MVMap.readPage(MVMap.java:633)
at org.h2.mvstore.MVMap.readOrCreateRootPage(MVMap.java:658)
at org.h2.mvstore.MVMap.setRootPos(MVMap.java:643)
at org.h2.mvstore.MVStore.openMap(MVStore.java:702)
at org.h2.mvstore.MVStore.openMap(MVStore.java:648)
at org.h2.mvstore.tx.TransactionStore.openMap(TransactionStore.java:564)
at org.h2.mvstore.tx.TransactionStore.openVersionedMap(TransactionStore.java:550)
at org.h2.mvstore.tx.Transaction.openMap(Transaction.java:456)
at org.h2.mvstore.db.MVPrimaryIndex.<init>(MVPrimaryIndex.java:53)
at org.h2.mvstore.db.MVTable.<init>(MVTable.java:156)
at org.h2.mvstore.db.Store.createTable(Store.java:219)
... 46 common frames omitted