After some investigation the issue was a field added to local types which relied on the relation schema (a custom relation) and the schema was not added in the local file.
Steve On Friday, May 19, 2023 at 2:53:01 PM UTC-4 Stephen Brush wrote: > Hi, > > I'm getting the error below when running "database migrate" on a clean > schema in postgres. All of the migrations have "success=true". > > The metadataschemaregistry table has only 4 entries in it (dc, dspace, > eperson, dcterms). On previous DB setups I believe there were almost 20 > entries in that table. The "missing" ones are local, relation, all of the > schema.org ones and a couple others. I don't see any of the missing > schemas in the migration scripts so I'm not sure how they were added in > previous initial DB setups. I'm not sure but I assume the are supposed to > be present currently as the callback obviously is expecting one of the > values that don't seem to exist. > > ** I believe my previously successful initial DB setups were done in v7.2 > > Help, suggestions or explanations appreciated. > > Steve > > 2023-05-19 17:38:52,884 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:785) > ~[dspace-api-7.3.jar:7.3] > > at > org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:672) > ~[dspace-api-7.3.jar:7.3] > > at > org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:647) > ~[dspace-api-7.3.jar:7.3] > > at > org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:626) > ~[dspace-api-7.3.jar:7.3] > > at org.dspace.core.Context.updateDatabase(Context.java:214) > [dspace-api-7.3.jar:7.3] > > at org.dspace.core.Context.init(Context.java:167) > [dspace-api-7.3.jar:7.3] > > at org.dspace.core.Context.<init>(Context.java:149) > [dspace-api-7.3.jar:7.3] > > at > org.dspace.administer.CreateAdministrator.<init>(CreateAdministrator.java:95) > [dspace-api-7.3.jar:7.3] > > at > org.dspace.administer.CreateAdministrator.main(CreateAdministrator.java:68) > [dspace-api-7.3.jar:7.3] > > at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) ~[?:?] > > at > jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > > ~[?:?] > > at > jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > > ~[?:?] > > at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] > > at > org.dspace.app.launcher.ScriptLauncher.runOneCommand(ScriptLauncher.java:277) > [dspace-api-7.3.jar:7.3] > > at > org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:133) > [dspace-api-7.3.jar:7.3] > > at > org.dspace.app.launcher.ScriptLauncher.main(ScriptLauncher.java:98) > [dspace-api-7.3.jar:7.3] > > Caused by: org.flywaydb.core.api.FlywayException: Error while executing > afterMigrate callback: Error attempting to update Bitstream Format and/or > Metadata Registries > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.handleEvent(DefaultCallbackExecutor.java:136) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.execute(DefaultCallbackExecutor.java:129) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.lambda$execute$0(DefaultCallbackExecutor.java:116) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:55) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.execute(DefaultCallbackExecutor.java:114) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.onMigrateOrUndoEvent(DefaultCallbackExecutor.java:70) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:114) > ~[flyway-core-8.4.4.jar:?] > > at org.flywaydb.core.Flyway$1.execute(Flyway.java:173) > ~[flyway-core-8.4.4.jar:?] > > at org.flywaydb.core.Flyway$1.execute(Flyway.java:124) > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:214) > ~[flyway-core-8.4.4.jar:?] > > at org.flywaydb.core.Flyway.migrate(Flyway.java:124) > ~[flyway-core-8.4.4.jar:?] > > at > org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:772) > ~[dspace-api-7.3.jar:7.3] > > ... 15 more > > Caused by: java.lang.RuntimeException: Error attempting to update > Bitstream Format and/or Metadata Registries > > at > org.dspace.storage.rdbms.RegistryUpdater.updateRegistries(RegistryUpdater.java:95) > > ~[dspace-api-7.3.jar:7.3] > > at > org.dspace.storage.rdbms.RegistryUpdater.handle(RegistryUpdater.java:146) > ~[dspace-api-7.3.jar:7.3] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.handleEvent(DefaultCallbackExecutor.java:134) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.execute(DefaultCallbackExecutor.java:129) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.lambda$execute$0(DefaultCallbackExecutor.java:116) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:55) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.execute(DefaultCallbackExecutor.java:114) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.onMigrateOrUndoEvent(DefaultCallbackExecutor.java:70) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:114) > ~[flyway-core-8.4.4.jar:?] > > at org.flywaydb.core.Flyway$1.execute(Flyway.java:173) > ~[flyway-core-8.4.4.jar:?] > > at org.flywaydb.core.Flyway$1.execute(Flyway.java:124) > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:214) > ~[flyway-core-8.4.4.jar:?] > > at org.flywaydb.core.Flyway.migrate(Flyway.java:124) > ~[flyway-core-8.4.4.jar:?] > > at > org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:772) > ~[dspace-api-7.3.jar:7.3] > > ... 15 more > > Caused by: org.dspace.administer.RegistryImportException: Schema > 'relation' is not registered and does not exist. > > at > org.dspace.administer.MetadataImporter.loadType(MetadataImporter.java:263) > ~[dspace-api-7.3.jar:7.3] > > at > org.dspace.administer.MetadataImporter.loadRegistry(MetadataImporter.java:160) > > ~[dspace-api-7.3.jar:7.3] > > at > org.dspace.storage.rdbms.RegistryUpdater.updateRegistries(RegistryUpdater.java:79) > > ~[dspace-api-7.3.jar:7.3] > > at > org.dspace.storage.rdbms.RegistryUpdater.handle(RegistryUpdater.java:146) > ~[dspace-api-7.3.jar:7.3] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.handleEvent(DefaultCallbackExecutor.java:134) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.execute(DefaultCallbackExecutor.java:129) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.lambda$execute$0(DefaultCallbackExecutor.java:116) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:55) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.execute(DefaultCallbackExecutor.java:114) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.callback.DefaultCallbackExecutor.onMigrateOrUndoEvent(DefaultCallbackExecutor.java:70) > > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:114) > ~[flyway-core-8.4.4.jar:?] > > at org.flywaydb.core.Flyway$1.execute(Flyway.java:173) > ~[flyway-core-8.4.4.jar:?] > > at org.flywaydb.core.Flyway$1.execute(Flyway.java:124) > ~[flyway-core-8.4.4.jar:?] > > at > org.flywaydb.core.FlywayExecutor.execute(FlywayExecutor.java:214) > ~[flyway-core-8.4.4.jar:?] > > at org.flywaydb.core.Flyway.migrate(Flyway.java:124) > ~[flyway-core-8.4.4.jar:?] > > at > org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:772) > ~[dspace-api-7.3.jar:7.3] > > ... 15 more > -- 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/170c6699-006e-4dda-a310-9d140649a926n%40googlegroups.com.
