H2 database exception

[marcverhagen]

The web code broke after merging the rest branch into the main branch:

org.h2.jdbc.JdbcSQLNonTransientException: General error: "The write format 1 is smaller than the supported format 2 [2.1.210/5]" [50000-210]

The H2 version upgrade from 1.4.196 was done in 102cb93 to solve a security vulnerability.

However, the upgrade does require you to migrate your databases, see https://imalsha-sg.medium.com/how-to-migrate-your-h2-databases-to-the-latest-h2-version-14b514ec7577 for a tutorial.

[marcverhagen]

The solution is to simply delete /usr/local/eager/db/ and a new database will be created automatically.

[marcverhagen]

Opening this up again because the next day when I restarted I got this error:

2023-06-08 18:11:02.748 ERROR [o.h.e.j.e.i.JdbcEnvironmentImpl:420] Could not fetch the SequenceInformation from the database
org.h2.jdbc.JdbcSQLSyntaxErrorException: Column "min_value" not found [42122-210]

Deleting the database again fixed this, but that does not make a good solution.