Hi Juan, As it sounds like you discovered, that migration is NOT one that comes with DSpace "out of the box". It looks like you added something custom at one point, and now Flyway (which DSpace uses to manage these migrations) is trying to find the old migration script and cannot find it. There's a few possible options here..
1. You could find that old migration script and put it somewhere where Flyway is looking for it...mainly under dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/postgres/ This will stop Flyway from complaining 2. You could try running a Flyway "repair" on the database. I think this will mark "missing" migrations as deleted. Run "./dspace database repair" 3. If neither of those work you could manually modify the "schema_version" table in your database to remove that row. This is the database table where Flyway manages all the migrations, so removing it from the table will make Flyway "forget" about it. However, be VERY careful to only remove that row... You may want to backup before touching this table, as there's no easy way to revert a mistake if you remove too much. (As a sidenote, if you know what this old migration modified in your DSpace database, you might want to also "undo" those changes if possible. There's always a chance that custom changes to your database could impact future DSpace upgrades. So, I generally recommend to never customize your DSpace database unless you know what you are doing...as there's always a chance that even small customizations can result in database migration errors in the future.) Good luck, Tim On Wednesday, March 30, 2022 at 2:49:00 PM UTC-5 juanlop...@gmail.com wrote: > Forgot to mention! > > When I try to run a bin/dspace database migrate to fix the "pending" > migration steps, I get a similar error: > > bin/dspace database migrate > > Database URL: jdbc:postgresql://localhost:5432/prodDB > 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:775) > at > org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:662) > at > org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:637) > at org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:233) > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.base/java.lang.reflect.Method.invoke(Method.java:566) > 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) > > Caused by: org.flywaydb.core.api.FlywayException: Validate failed: > Detected applied migration not resolved locally: 6.0.2017.05.15 > > at org.flywaydb.core.Flyway.doValidate(Flyway.java:292) > at org.flywaydb.core.Flyway.access$100(Flyway.java:73) > at org.flywaydb.core.Flyway$1.execute(Flyway.java:166) > at org.flywaydb.core.Flyway$1.execute(Flyway.java:158) > at org.flywaydb.core.Flyway.execute(Flyway.java:527) > at org.flywaydb.core.Flyway.migrate(Flyway.java:158) > at > org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:762) > ... 10 more > > El miércoles, 30 de marzo de 2022 a las 14:34:52 UTC-5, Juan López > escribió: > >> Hi! >> >> I've set a test environment for dspace 7 and ran a successfull migration >> from 6.3 to 7.0, however, now that I'm upgrading from 7 to 7.2 I've noticed >> that some error are thrown when I execute an "index-discover -b". >> >> Here's the error: >> >> 2022-03-30 14:26:35,118 INFO unknown unknown >> org.dspace.discovery.indexobject.ItemIndexFactoryImpl @ Wrote Item: >> c3ec783f-517d-456b-b90b-50303f4e1bf2 to Index >> 2022-03-30 14:26:35,126 INFO unknown unknown >> org.dspace.discovery.SolrServiceImpl @ >> anonymous::indexed_object:Item-c3ec783f-517d-456b-b90b-50303f4e1bf2 >> 2022-03-30 14:26:35,128 INFO unknown unknown >> org.dspace.storage.rdbms.DatabaseUtils @ Loading Flyway DB migrations from: >> classpath:org/dspace/storage/rdbms/sqlmigration/postgres, >> classpath:org/dspace/storage/rdbms/migration, >> classpath:org/dspace/storage/rdbms/xmlworkflow >> 2022-03-30 14:26:35,131 INFO unknown unknown >> org.flywaydb.core.internal.database.DatabaseFactory @ Database: >> jdbc:postgresql://localhost:5432/prodDB (PostgreSQL 13.2) >> 2022-03-30 14:26:35,132 WARN unknown unknown >> org.flywaydb.core.internal.database.base.Database @ Flyway upgrade >> recommended: PostgreSQL 13.2 is newer than this version of Flyway and >> support has not been tested. The latest supported version of PostgreSQL is >> 12. >> 2022-03-30 14:26:35,140 WARN unknown unknown >> org.flywaydb.core.internal.database.base.Database @ Flyway upgrade >> recommended: PostgreSQL 13.2 is newer than this version of Flyway and >> support has not been tested. The latest supported version of PostgreSQL is >> 12. >> 2022-03-30 14:26:35,148 INFO unknown unknown >> org.dspace.storage.rdbms.DatabaseUtils @ Pending DSpace database schema >> migrations: >> 2022-03-30 14:26:35,148 INFO unknown unknown >> *org.dspace.storage.rdbms.DatabaseUtils >> @ 7.0.2021.09.24 Move entity type from item template to collection SQL >> PENDING* >> *2022-03-30 14:26:35,148 INFO unknown unknown >> org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2021.10.04 alter collection >> table drop workflow stem columns SQL PENDING* >> *2022-03-30 14:26:35,148 INFO unknown unknown >> org.dspace.storage.rdbms.DatabaseUtils @ 7.1.2021.10.18 Fix MDV place >> after migrating from DSpace 5 SQL PENDING* >> 2022-03-30 14:26:35,150 WARN unknown unknown >> org.flywaydb.core.internal.database.base.Database @ Flyway upgrade >> recommended: PostgreSQL 13.2 is newer than this version of Flyway and >> support has not been tested. The latest supported version of PostgreSQL is >> 12. >> 2022-03-30 14:26:35,157 FATAL unknown unknown org.dspace.core.Context @ >> Cannot update or initialize database via Flyway! >> java.sql.SQLException: Flyway migration error occurred >> at >> org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:775) >> >> ~[dspace-api-7.2.jar:7.2] >> at >> org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:662) >> >> ~[dspace-api-7.2.jar:7.2] >> at >> org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:637) >> >> ~[dspace-api-7.2.jar:7.2] >> at >> org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:616) >> >> ~[dspace-api-7.2.jar:7.2] >> at org.dspace.core.Context.updateDatabase(Context.java:213) >> [dspace-api-7.2.jar:7.2] >> at org.dspace.core.Context.init(Context.java:166) >> [dspace-api-7.2.jar:7.2] >> at org.dspace.core.Context.<init>(Context.java:148) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.content.RelationshipMetadataServiceImpl.getRelationshipMetadata(RelationshipMetadataServiceImpl.java:44) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.content.ItemServiceImpl.getMetadata(ItemServiceImpl.java:1445) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.content.ItemServiceImpl.getMetadata(ItemServiceImpl.java:1429) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.content.ItemServiceImpl.getMetadata(ItemServiceImpl.java:72) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceSpellIndexingPlugin.additionalIndex(SolrServiceSpellIndexingPlugin.java:36) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.indexobject.IndexFactoryImpl.buildDocument(IndexFactoryImpl.java:67) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.indexobject.DSpaceObjectIndexFactoryImpl.buildDocument(DSpaceObjectIndexFactoryImpl.java:30) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.indexobject.ItemIndexFactoryImpl.buildDocument(ItemIndexFactoryImpl.java:134) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.indexobject.ItemIndexFactoryImpl.buildDocument(ItemIndexFactoryImpl.java:75) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.update(SolrServiceImpl.java:165) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.indexContent(SolrServiceImpl.java:155) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:322) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:309) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.createIndex(SolrServiceImpl.java:277) >> [dspace-api-7.2.jar:7.2] >> at org.dspace.discovery.IndexClient.internalRun(IndexClient.java:72) >> [dspace-api-7.2.jar:7.2] >> at org.dspace.scripts.DSpaceRunnable.run(DSpaceRunnable.java:104) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.app.launcher.ScriptLauncher.executeScript(ScriptLauncher.java:149) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:131) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) >> [dspace-api-7.2.jar:7.2] >> Caused by: org.flywaydb.core.api.FlywayException: Validate failed: >> Detected applied migration not resolved locally: 6.0.2017.05.15 >> >> at org.flywaydb.core.Flyway.doValidate(Flyway.java:292) >> ~[flyway-core-6.5.7.jar:?] >> at org.flywaydb.core.Flyway.access$100(Flyway.java:73) >> ~[flyway-core-6.5.7.jar:?] >> at org.flywaydb.core.Flyway$1.execute(Flyway.java:166) >> ~[flyway-core-6.5.7.jar:?] >> at org.flywaydb.core.Flyway$1.execute(Flyway.java:158) >> ~[flyway-core-6.5.7.jar:?] >> at org.flywaydb.core.Flyway.execute(Flyway.java:527) >> ~[flyway-core-6.5.7.jar:?] >> at org.flywaydb.core.Flyway.migrate(Flyway.java:158) >> ~[flyway-core-6.5.7.jar:?] >> at >> org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:762) >> >> ~[dspace-api-7.2.jar:7.2] >> ... 25 more >> 2022-03-30 14:26:35,161 INFO unknown unknown >> org.dspace.discovery.indexobject.ItemIndexFactoryImpl @ Wrote Item: >> c3efadf9-0db4-4315-a888-8835736d5fae to Index >> 2022-03-30 14:26:35,163 ERROR unknown unknown >> org.dspace.storage.bitstore.DSBitStoreService @ >> get(49805720241401011117589566281106930828) >> java.io.FileNotFoundException: >> /dspace/assetstore/49/80/57/49805720241401011117589566281106930828 (No such >> file or directory) >> at java.io.FileInputStream.open0(Native Method) ~[?:?] >> at java.io.FileInputStream.open(FileInputStream.java:219) ~[?:?] >> at java.io.FileInputStream.<init>(FileInputStream.java:157) ~[?:?] >> at >> org.dspace.storage.bitstore.DSBitStoreService.get(DSBitStoreService.java:90) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.storage.bitstore.BitstreamStorageServiceImpl.retrieve(BitstreamStorageServiceImpl.java:220) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.content.BitstreamServiceImpl.retrieve(BitstreamServiceImpl.java:300) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.FullTextContentStreams$FullTextBitstream.getInputStream(FullTextContentStreams.java:174) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.FullTextContentStreams$FullTextEnumeration.nextElement(FullTextContentStreams.java:207) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.FullTextContentStreams$FullTextEnumeration.nextElement(FullTextContentStreams.java:186) >> >> [dspace-api-7.2.jar:7.2] >> at >> java.io.SequenceInputStream.peekNextStream(SequenceInputStream.java:102) >> [?:?] >> at java.io.SequenceInputStream.<init>(SequenceInputStream.java:68) >> [?:?] >> at >> org.dspace.discovery.FullTextContentStreams.getStream(FullTextContentStreams.java:133) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.indexobject.IndexFactoryImpl.writeDocument(IndexFactoryImpl.java:105) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.indexobject.ItemIndexFactoryImpl.writeDocument(ItemIndexFactoryImpl.java:662) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.indexobject.ItemIndexFactoryImpl.writeDocument(ItemIndexFactoryImpl.java:75) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.update(SolrServiceImpl.java:166) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.indexContent(SolrServiceImpl.java:155) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:322) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:309) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.createIndex(SolrServiceImpl.java:277) >> [dspace-api-7.2.jar:7.2] >> at org.dspace.discovery.IndexClient.internalRun(IndexClient.java:72) >> [dspace-api-7.2.jar:7.2] >> at org.dspace.scripts.DSpaceRunnable.run(DSpaceRunnable.java:104) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.app.launcher.ScriptLauncher.executeScript(ScriptLauncher.java:149) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:131) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) >> [dspace-api-7.2.jar:7.2] >> 2022-03-30 14:26:35,163 WARN unknown unknown >> org.dspace.discovery.FullTextContentStreams @ Unable to add full text >> bitstream caja7folio293.pdf.txt for item 10336/11739 to >> SOLR:java.io.FileNotFoundException: >> /dspace/assetstore/49/80/57/49805720241401011117589566281106930828 (No such >> file or directory) >> java.io.IOException: java.io.FileNotFoundException: >> /dspace/assetstore/49/80/57/49805720241401011117589566281106930828 (No such >> file or directory) >> at >> org.dspace.storage.bitstore.DSBitStoreService.get(DSBitStoreService.java:93) >> ~[dspace-api-7.2.jar:7.2] >> at >> org.dspace.storage.bitstore.BitstreamStorageServiceImpl.retrieve(BitstreamStorageServiceImpl.java:220) >> >> ~[dspace-api-7.2.jar:7.2] >> at >> org.dspace.content.BitstreamServiceImpl.retrieve(BitstreamServiceImpl.java:300) >> >> ~[dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.FullTextContentStreams$FullTextBitstream.getInputStream(FullTextContentStreams.java:174) >> >> ~[dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.FullTextContentStreams$FullTextEnumeration.nextElement(FullTextContentStreams.java:207) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.FullTextContentStreams$FullTextEnumeration.nextElement(FullTextContentStreams.java:186) >> >> [dspace-api-7.2.jar:7.2] >> at >> java.io.SequenceInputStream.peekNextStream(SequenceInputStream.java:102) >> [?:?] >> at java.io.SequenceInputStream.<init>(SequenceInputStream.java:68) >> [?:?] >> at >> org.dspace.discovery.FullTextContentStreams.getStream(FullTextContentStreams.java:133) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.indexobject.IndexFactoryImpl.writeDocument(IndexFactoryImpl.java:105) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.indexobject.ItemIndexFactoryImpl.writeDocument(ItemIndexFactoryImpl.java:662) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.indexobject.ItemIndexFactoryImpl.writeDocument(ItemIndexFactoryImpl.java:75) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.update(SolrServiceImpl.java:166) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.indexContent(SolrServiceImpl.java:155) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:322) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.updateIndex(SolrServiceImpl.java:309) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.discovery.SolrServiceImpl.createIndex(SolrServiceImpl.java:277) >> [dspace-api-7.2.jar:7.2] >> at org.dspace.discovery.IndexClient.internalRun(IndexClient.java:72) >> [dspace-api-7.2.jar:7.2] >> at org.dspace.scripts.DSpaceRunnable.run(DSpaceRunnable.java:104) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.app.launcher.ScriptLauncher.executeScript(ScriptLauncher.java:149) >> >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:131) >> [dspace-api-7.2.jar:7.2] >> at >> org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) >> [dspace-api-7.2.jar:7.2] >> Caused by: java.io.FileNotFoundException: >> /dspace/assetstore/49/80/57/49805720241401011117589566281106930828 (No such >> file or directory) >> at java.io.FileInputStream.open0(Native Method) ~[?:?] >> at java.io.FileInputStream.open(FileInputStream.java:219) ~[?:?] >> at java.io.FileInputStream.<init>(FileInputStream.java:157) ~[?:?] >> at >> org.dspace.storage.bitstore.DSBitStoreService.get(DSBitStoreService.java:90) >> ~[dspace-api-7.2.jar:7.2] >> ... 21 more >> >> >> The Fatal error highlited is a development that we do not wish to >> implement in dspace 7. >> >> Is there a way to delete this "missing" migration from my database:[image: >> imagen_2022-03-30_143404.png] >> >> Best regards, >> >> Juan. >> >> -- 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/33d5f7c0-a365-41fd-b051-22f5dd373082n%40googlegroups.com.
