Jose, SQL migrations in DSpace 6.x are stored under the [src]/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/postgres/ directory:
https://github.com/DSpace/DSpace/tree/dspace-6_x/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/postgres That error seems to saying that you previously ran a custom migration from that folder which started with "V4.1". I do not know what that migration is, or what it does, as it is *not* an out-of-the-box DSpace migration. Therefore, your first step should be to try to find that migration file that was previously run (maybe it is in your old codebase?). It probably will be named something like "V4.1__Upgrade_to_Dspace_Vlir_schema.sql" based on what your "./dspace database info" command is returning. If you can find this SQL file and place it in the above directory alongside your other migrations, then this will fix the error. This is the best solution, as it will ensure Flyway is working properly & is able to validate your database table against *all* the migrations previously run on this table. The odd thing to me here is that you said you are upgrading from DSpace 4 to 6. So, I don't understand how you have old DSpace 4.x Flyway migrations (as DSpace 4 didn't use Flyway *at all*, that wasn't introduced until DSpace 5). Are you *sure* this is a DSpace 4 installation? It seems to be acting more like a DSpace 5.0 installation -- which would imply your old code should have that migrations folder above, and you can simply move your custom migration to the 6.x source code and rebuild. Tim ________________________________ From: dspace-tech@googlegroups.com <dspace-tech@googlegroups.com> on behalf of Jose Javier Hernández <jjbenitez...@gmail.com> Sent: Wednesday, December 4, 2019 10:46 AM To: DSpace Technical Support <dspace-tech@googlegroups.com> Subject: Re: [dspace-tech] Migrate database from Dspace 4 to Dspace 6 Hi Tim, thanks for your answer. What can I do to solve this? Is this lost migration in the DSpace installer or only in the old codebase dspace? Is it possible to skip that migration and then do it manually? El miércoles, 4 de diciembre de 2019, 10:44:28 (UTC-5), Tim Donohue escribió: Hi Jose, That error is FlywayDB.org (the system we use to update the DSpace Database) telling you that the migration named "4.1" is not found. In your pastebin, it looks like that "4.1" migration is a custom migration called "Upgrade to Dspace Vlir schema" and is listed as "Missing". My guess is you added a custom database migration to your codebase at some point (it says it ran July 1, 2016), and this custom migration has not been copied over into your DSpace 6 codebase. Good luck, Tim ________________________________ From: dspac...@googlegroups.com <dspac...@googlegroups.com> on behalf of Jose Javier Hernández <jjbeni...@gmail.com> Sent: Wednesday, December 4, 2019 9:19 AM To: DSpace Technical Support <dspac...@googlegroups.com> Subject: [dspace-tech] Migrate database from Dspace 4 to Dspace 6 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<http://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 dspac...@googlegroups.com. 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>. -- 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 dspace-tech+unsubscr...@googlegroups.com<mailto:dspace-tech+unsubscr...@googlegroups.com>. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/f0f6b455-fa20-429e-b4d0-2c161144d9e6%40googlegroups.com<https://groups.google.com/d/msgid/dspace-tech/f0f6b455-fa20-429e-b4d0-2c161144d9e6%40googlegroups.com?utm_medium=email&utm_source=footer>. -- 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 dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/DM5PR2201MB11482C61E39036DF48C1BBCFED5D0%40DM5PR2201MB1148.namprd22.prod.outlook.com.
