Hi Jose, Flyway<https://flywaydb.org/> (the system we use to manage migrations) is telling you that it knows it previously ran a migration named "statistics-harvester" with a version number 5.0.2015.06.18. But, now it says that file is missing, so it cannot "validate" your database against the list of known migration files.
This "statistics-harvester" migration is not a standard, out-of-the-box DSpace database migration. Perhaps you created your own migration a while back and didn't move it over during your 6.x upgrade? Here's where DSpace stores it's migration SQL files in DSpace 6.x: https://github.com/DSpace/DSpace/tree/dspace-6_x/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/postgres Essentially, it's telling you that there's no file named "V5.0.2015.06.18__statistics-harvester.sql" in that location. So, if you have that custom migration file, you can move it there and it'll likely stop complaining. Tim ________________________________ From: [email protected] <[email protected]> on behalf of Jose Blanco <[email protected]> Sent: Monday, May 4, 2020 2:24 PM To: DSpace Technical Support <[email protected]> Subject: [dspace-tech] issue upgrading db from 5.1 to 6.3 I'm getting this error: >>> ./dspace database migrate Migrating database to latest version... (Check dspace 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.updateDatabase(DatabaseUtils.java:576) at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:221) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:607) 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: 5.0.2015.06.18 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) >From running "./dspace database info" I see that I have: | 5.0.2015.06.18 | statistics-harvester | 2018-03-08 11:34:55 | Missing | Not sure what to do next. -Jose -- 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]<mailto:[email protected]>. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-vjN3s97ock1h-YF6vK4XyK8%3Dxc7wTbLsosRTK2yo6tXw%40mail.gmail.com<https://groups.google.com/d/msgid/dspace-tech/CAK%3DKc-vjN3s97ock1h-YF6vK4XyK8%3Dxc7wTbLsosRTK2yo6tXw%40mail.gmail.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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/DM5PR2201MB1148AC5B1A7D57E497085E25EDA60%40DM5PR2201MB1148.namprd22.prod.outlook.com.
