将数据库从Dspace 4迁移到Dspace 6

Question

我正在尝试将数据库从DSpace 4迁移到DSpace 6。我导出了DSpace 4数据库，并将其本地导入到我的DSpace 6.3安装中。数据库信息如下

database information

然后我就做了：

/dspace/bin/dspace database repair
/dspace/bin/dspace database migrate

Database URL: jdbc:postgresql://172.18.0.2:5432/dspace
Migrating database to latest version AND running previously "Ignored" migrations... (Check logs for details)
Migration exception:
java.sql.SQLException: Flyway migration error occurred
    at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:673)
    at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:187)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    at java.lang.reflect.Method.invoke(Method.java:498)
    at org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:229)
    at org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:81)
Caused by: org.flywaydb.core.api.FlywayException: Validate failed: Detected applied migration not resolved locally: 4.1
    at org.flywaydb.core.Flyway.doValidate(Flyway.java:1008)
    at org.flywaydb.core.Flyway.access$100(Flyway.java:72)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:921)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
    at org.flywaydb.core.Flyway.execute(Flyway.java:1373)
    at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
    at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:662)
    ... 7 more

有什么帮助吗？提前谢谢。

Answer 1

这可能会对你有所帮助，这似乎是一个外键命名的问题。http://dspace.2283337.n4.nabble.com/Flyway-Migration-Error-td4677061.html