As of DSpace 5 (and above) the DSpace code will automatically upgrade your database. By default, this will occur AUTOMATICALLY when you restart Tomcat. So, the steps to manually upgrade the database by running commands on the command-line are not needed.
1) Shut down Tomcat 2) Import your database. 3) If using postgres, make sure you run the following command after importing the database: CREATE EXTENSION pgcrypto; 4) Then restart Tomcat back on (the database will be upgraded automatically). On Wed, Dec 4, 2019 at 10:19 AM Jose Javier Hernández < [email protected]> wrote: > I am trying to migrate a database from DSpace 4 to DSpace 6. I exported > the DSpace 4 database and imported it locally in my DSpace 6.3 > installation. The database information is as follows > > database information <https://pastebin.com/raw/VmEd9xZn> > > > Then I do: > > /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 > > > Any help? Thanks in advance. > > -- > All messages to this mailing list should adhere to the DuraSpace Code of > Conduct: https://duraspace.org/about/policies/code-of-conduct/ > --- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/dspace-tech/5b196f92-d3fb-4e97-bae0-c31411abbd87%40googlegroups.com > <https://groups.google.com/d/msgid/dspace-tech/5b196f92-d3fb-4e97-bae0-c31411abbd87%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- Carolyn Brown Ray Web Architect Office of Information Technology Muhlenberg College 484-664-3646 -- All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/ --- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CALY1WGmsscU4b7XkXACTFu6HVkLyctsOv-7uwSuui3R4U9wZKA%40mail.gmail.com.
