Hi, I installed DSpace 7.5 on a new server and am now trying to migrate the database comming from dspace 5 (postgresql 9). After db_restore flyway always throws an error:
[dspace@dev_server DSpace-Backend]$ bin/dspace database info Caught exception: java.lang.IllegalArgumentException: No enum constant org.flywaydb.core.api.MigrationType.INIT at java.base/java.lang.Enum.valueOf(Enum.java:273) at org.flywaydb.core.api.MigrationType.valueOf(MigrationType.java:21) at org.flywaydb.core.api.MigrationType.fromString(MigrationType.java:112) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory$2.mapRow(JdbcTableSchemaHistory.java:212) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory$2.mapRow(JdbcTableSchemaHistory.java:197) at org.flywaydb.core.internal.jdbc.JdbcTemplate.query(JdbcTemplate.java:344) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.refreshCache(JdbcTableSchemaHistory.java:197) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.allAppliedMigrations(JdbcTableSchemaHistory.java:187) at org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.removeFailedMigrations(JdbcTableSchemaHistory.java:247) at org.flywaydb.core.internal.command.DbRepair$1.call(DbRepair.java:121) at org.flywaydb.core.internal.command.DbRepair$1.call(DbRepair.java:117) at org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:55) at org.flywaydb.core.internal.command.DbRepair.repair(DbRepair.java:117) at org.flywaydb.core.Flyway$7.execute(Flyway.java:339) at org.flywaydb.core.Flyway$7.execute(Flyway.java:335) at org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:214) at org.flywaydb.core.Flyway.repair(Flyway.java:335) at org.dspace.storage.rdbms.FlywayUpgradeUtils.upgradeFlywayTable(FlywayUpgradeUtils.java:114) at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:114) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:277) at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:133) at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) I tried several migration ways: 1. restore to pg 9.6.24, upgrade to pg13, dump dspace db, restore to dev-Server a) keep existing tables b) delete and create all tables, views etc. 2. restore to pg 9.6.24, upgrade to pg13, dump only dspace-db`s data, restore to dev-Server 3. directly restore the original dump to dev-server. I tried all six ways with `psql -f etc/postgres/update-sequences.sql` and without. I created pg_crypto (dspace=# CREATE EXTENSION pgcrypto;). Does anybody have a hint for me, who to track this down? Thanks in advance, Sven -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/4b4588a6-71bb-4359-b25e-c3a4507d26e4n%40googlegroups.com.
