Hi Sven, We have a migration guide here which should walk you through the proper steps when moving data from one server (or an old Postgres) to another (or a new Postgres). I know this guide has worked for many others (as we've received small improvements from community members over time), so hopefully it'll help you out as well.
https://wiki.lyrasis.org/display/DSDOC7x/Migrating+DSpace+to+a+new+server If it continues to fail, you may also want to check your dspace.log immediately *after* running "./dspace database info" to see if more details are shown there regarding the error message. Sometimes dspace.log will provide important details like the exact database table or column which it's having problems with. Tim On Friday, September 1, 2023 at 7:38:10 AM UTC-5 kos...@ethz.ch wrote: > 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/eef7c87b-2f01-4013-85eb-f2b47dd0cc04n%40googlegroups.com.
