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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/dspace-tech/8032094c-494d-434c-81c5-e6e7009c639dn%40googlegroups.com.
