Thank you very much, Tim. The first part is fixed. I replaced the 7.2 update-sequences.sql by the dspace-4.x version and now it works great:
*$ ./dspace database update-sequences* Running org/dspace/storage/rdbms/sqlmigration/postgres/update-sequences.sql update-sequences complete ========================================== As to the $./dspace database migrate ignored part, I checked the metadatafieldregistry table and it had 2 rows for title: metadata_field_id metadata_schema_id element qualifier scope_note 76 1 title [null] A name given to the resource 77 1 title alternative An alternate name given to the resource I wasn't sure which to delete, so I tried to delete the alternative one: *delete from metadatafieldregistry * *where metadata_field_id = 77; * and got this: ERROR: update or delete on table "metadatafieldregistry" violates foreign key constraint "metadatavalue_metadata_field_id_fkey" on table "metadatavalue" DETAIL: Key (metadata_field_id)=(77) is still referenced from table "metadatavalue". SQL state: 23503 Then I looked at the metadatavalue table and it has 1500 rows with metadata_field_id = 76 and only 28 rows with 77. I decided to delete these 28 rows, after which I was able to delete metadata_field_id = 77 in the metadatafieldregistry. However, when I try to run *$ ./dspace database migrate ignored*, I get the exact same errors as before. The dspace.log this time collected more info, and I am attaching it here. What else could I try? On Monday, February 28, 2022 at 12:22:13 p.m. UTC-4 Tim Donohue wrote: > Hi, > > Unfortunately, since you are on such an old version of DSpace (v4), the > newer DSpace 7 "update-sequences" scripts *will not work on your database > until you successfully upgrade. *Instead, to update sequences on a > database that's currently compatible with DSpace 4.x, you would need to > manually run the *older* "update-sequences.sql" that came with DSpace 4.x. > Here it is: > https://github.com/DSpace/DSpace/blob/dspace-4_x/dspace/etc/postgres/update-sequences.sql > > With the migration that is failing...it looks like this is the SQL > statement that is failing with "ERROR: more than one row returned by a > subquery used as an expression": > https://github.com/DSpace/DSpace/blob/dspace-7.2/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/postgres/V5.0_2014.09.26__DS-1582_Metadata_For_All_Objects.sql#L74-L82 > > (As you may notice the error says it's the statement starting on line 74) > > Based on the error, it appears to me that the problem is that the internal > SELECT on line 78 is returning *multiple values* instead of the expected > *single value*. This would mean that somehow your DSpace 4.x database has > **two different** "dc.title" fields in the "metadatafieldregistry" table. > You would need to remove one of them, as *every field must be uniquely > named* in the "metadatafieldregistry". > > Once you remove the duplicate field and run the old > "update-sequences.sql", hopefully the migration to DSpace 7.x will > succeed. > > If you run into any other issues, let us know on this list. > > Tim > > > > > On Tuesday, February 22, 2022 at 11:20:31 PM UTC-6 Night Librarian wrote: > >> Sorry for the lengthy post! >> >> I'm trying to migrate from 4.0 on Windows to 7.2 on Ubuntu 20.04.3 LTS. >> I created a virtual machine and followed the instructions from >> https://wiki.lyrasis.org/display/DSDOC7x/Upgrading+DSpace, only to get >> stuck at the database update step :( >> >> First, I imported the pg_dump from the old machine: >> >> *$psql --set ON_ERROR_STOP=on dspace < /temp/dspace.sql* >> ==================================================================== >> >> Then: >> >> *$ ./dspace database info * >> >> Database Type: postgres >> >> Database URL: jdbc:postgresql://localhost:5432/dspace >> >> Database Schema: public >> >> Database Username: dspace >> >> Database Software: PostgreSQL version 12.9 (Ubuntu 12.9-0ubuntu0.20.04.1) >> >> Database Driver: PostgreSQL JDBC Driver version 42.2.25 >> >> PostgreSQL 'pgcrypto' extension installed/up-to-date? true (version=1.3) >> >> FlywayDB Version: 6.5.7 >> >> >> >> >> +-----------+----------------+-----------------------------------------------------+------+--------------+---------+ >> >> >> | Category | Version | >> Description | Type | Installed On | >> State | >> >> >> +-----------+----------------+-----------------------------------------------------+------+--------------+---------+ >> >> >> | Versioned | 1.1 | Initial DSpace 1.1 database >> schema | SQL | | Pending | >> >> | Versioned | 1.2 | Upgrade to DSpace 1.2 >> schema | SQL | | Pending | >> >> | Versioned | 1.3 | Upgrade to DSpace 1.3 >> schema | SQL | | Pending | >> >> | Versioned | 1.3.9 | Drop constraint for DSpace 1 4 >> schema | JDBC | | Pending | >> >> | Versioned | 1.4 | Upgrade to DSpace 1.4 >> schema | SQL | | Pending | >> >> | Versioned | 1.5 | Upgrade to DSpace 1.5 >> schema | SQL | | Pending | >> >> | Versioned | 1.5.9 | Drop constraint for DSpace 1 6 >> schema | JDBC | | Pending | >> >> | Versioned | 1.6 | Upgrade to DSpace 1.6 >> schema | SQL | | Pending | >> >> | Versioned | 1.7 | Upgrade to DSpace 1.7 >> schema | SQL | | Pending | >> >> | Versioned | 1.8 | Upgrade to DSpace 1.8 >> schema | SQL | | Pending | >> >> | Versioned | 3.0 | Upgrade to DSpace 3.x >> schema | SQL | | Pending | >> >> | Versioned | 4.0 | Upgrade to DSpace 4.x >> schema | SQL | | Pending | >> >> | Versioned | 4.9.2015.10.26 | DS-2818 registry >> update | SQL | | Pending | >> >> | Versioned | 5.0.2014.08.08 | DS-1945 Helpdesk Request a >> Copy | SQL | | Pending | >> >> | Versioned | 5.0.2014.09.25 | DS 1582 Metadata For All Objects drop >> constraint | JDBC | | Pending | >> >> | Versioned | 5.0.2014.09.26 | DS-1582 Metadata For All >> Objects | SQL | | Pending | >> >> | Versioned | 5.0.2014.11.04 | Enable XMLWorkflow >> Migration | JDBC | | Pending | >> >> | Versioned | 5.6.2016.08.23 | >> DS-3097 | SQL | | >> Pending | >> >> | Versioned | 5.7.2017.04.11 | DS-3563 Index metadatavalue resource type >> id column | SQL | | Pending | >> >> | Versioned | 5.7.2017.05.05 | DS 3431 Add Policies for >> BasicWorkflow | JDBC | | Pending | >> >> | Versioned | 6.0.2015.03.06 | DS 2701 Dso Uuid >> Migration | JDBC | | Pending | >> >> | Versioned | 6.0.2015.03.07 | DS-2701 Hibernate >> migration | SQL | | Pending | >> >> | Versioned | 6.0.2015.08.31 | DS 2701 Hibernate Workflow >> Migration | JDBC | | Pending | >> >> | Versioned | 6.0.2015.09.01 | DS 2701 Enable XMLWorkflow >> Migration | JDBC | | Pending | >> >> | Versioned | 6.0.2016.01.03 | >> DS-3024 | SQL | | >> Pending | >> >> | Versioned | 6.0.2016.01.26 | DS 2188 Remove DBMS Browse >> Tables | JDBC | | Pending | >> >> | Versioned | 6.0.2016.02.25 | >> DS-3004-slow-searching-as-admin | SQL | | >> Pending | >> >> | Versioned | 6.0.2016.04.01 | DS-1955 Increase embargo >> reason | SQL | | Pending | >> >> | Versioned | 6.0.2016.04.04 | >> DS-3086-OAI-Performance-fix | SQL | | >> Pending | >> >> | Versioned | 6.0.2016.04.14 | >> DS-3125-fix-bundle-bitstream-delete-rights | SQL | | >> Pending | >> >> | Versioned | 6.0.2016.05.10 | DS-3168-fix-requestitem item id >> column | SQL | | Pending | >> >> | Versioned | 6.0.2016.07.21 | >> DS-2775 | SQL | | >> Pending | >> >> | Versioned | 6.0.2016.07.26 | DS-3277 fix handle >> assignment | SQL | | Pending | >> >> | Versioned | 6.0.2016.08.23 | >> DS-3097 | SQL | | >> Pending | >> >> | Versioned | 6.1.2017.01.03 | DS 3431 Add Policies for >> BasicWorkflow | JDBC | | Pending | >> >> | Versioned | 7.0.2017.10.12 | >> DS-3542-stateless-sessions | SQL | | >> Pending | >> >> | Versioned | 7.0.2018.04.03 | Upgrade Workflow >> Policy | JDBC | | Pending | >> >> | Versioned | 7.0.2018.04.16 | >> dspace-entities | SQL | | >> Pending | >> >> | Versioned | 7.0.2018.06.07 | >> DS-3851-permission | SQL | | >> Pending | >> >> | Versioned | 7.0.2019.05.02 | >> DS-4239-workflow-xml-migration | SQL | | >> Pending | >> >> | Versioned | 7.0.2019.06.14 | >> scripts-and-process | SQL | | >> Pending | >> >> | Versioned | 7.0.2019.07.31 | Retrieval of name >> variant | SQL | | Pending | >> >> | Versioned | 7.0.2019.11.13 | relationship type copy left >> right | SQL | | Pending | >> >> | Versioned | 7.0.2020.01.08 | >> DS-626-statistics-tracker | SQL | | >> Pending | >> >> | Versioned | 7.0.2020.10.31 | CollectionCommunity Metadata >> Handle | JDBC | | Pending | >> >> | Versioned | 7.0.2021.01.22 | Remove basic >> workflow | SQL | | Pending | >> >> | Versioned | 7.0.2021.02.08 | tilted >> rels | SQL | | >> Pending | >> >> | Versioned | 7.0.2021.03.18 | Move entity type to dspace >> schema | SQL | | Pending | >> >> | Versioned | 7.0.2021.09.24 | Move entity type from item template to >> collection | SQL | | Pending | >> >> | Versioned | 7.0.2021.10.04 | alter collection table drop workflow stem >> columns | SQL | | Pending | >> >> | Versioned | 7.1.2021.10.18 | Fix MDV place after migrating from DSpace >> 5 | SQL | | Pending | >> >> >> +-----------+----------------+-----------------------------------------------------+------+--------------+---------+ >> >> >> NOTE: This database is NOT yet initialized for auto-migrations (via >> Flyway). >> >> Your database looks to be compatible with DSpace version 4.0 >> >> All upgrades *after* version 4.0 will be run during the next migration. >> >> If you'd like to upgrade now, simply run 'dspace database migrate'. >> ==================================================================== >> >> Then, got an error after trying to update sequences: >> >> *$psql -U dspace -f >> /temp/DSpace-dspace-7.2/dspace-api/target/classes/org/dspace/storage/rdbms/sqlmigration/postgres/update-sequences.sql >> >> dspace * >> >> <...> >> psql:/temp/DSpace-dspace-7.2/dspace-api/target/classes/org/dspace/storage/rdbms/sqlmigration/postgres/update-sequences.sql:36: >> >> ERROR: relation "handle_id_seq" does not exist >> >> LINE 1: SELECT setval('handle_id_seq', max(handle_id)) FROM handle; >> <...> >> >> ==================================================================== >> >> Then, tried update-sequences in a different way: >> >> *$./dspace database update-sequences * >> >> Running >> org/dspace/storage/rdbms/sqlmigration/postgres/update-sequences.sql >> >> Caught exception: >> >> org.postgresql.util.PSQLException: ERROR: relation "handle_id_seq" does >> not exist >> >> Position: 16 >> >> at >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2565) >> >> >> >> at >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2297) >> >> >> >> at >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322) >> >> >> at >> org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) >> >> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) >> >> at >> org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322) >> >> at >> org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308) >> >> at >> org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284) >> >> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279) >> >> at >> org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) >> >> >> >> at >> org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) >> >> >> >> at >> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:353) >> >> 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) >> >> ==================================================================== >> >> The last thing I did was: >> >> *$ ./dspace database migrate ignored * >> >> Database URL: jdbc:postgresql://localhost: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:775) >> >> >> >> at >> org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:662) >> >> >> >> at >> org.dspace.storage.rdbms.DatabaseUtils.main(DatabaseUtils.java:195) >> >> 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.internal.command.DbMigrate$FlywayMigrateException: >> >> Migration V5.0_2014.09.26__DS-1582_Metadata_For_All_Objects.sql failed >> >> ---------------------------------------------------------------------- >> >> SQL State : 21000 >> >> Error Code : 0 >> >> Message : ERROR: more than one row returned by a subquery used as an >> expression >> >> Location : >> org/dspace/storage/rdbms/sqlmigration/postgres/V5.0_2014.09.26__DS-1582_Metadata_For_All_Objects.sql >> >> (/dspace/bin/file:/dspace/lib/dspace-api-7.2.jar!/org/dspace/storage/rdbms/sqlmigration/postgres/V5.0_2014.09.26__DS-1582_Metadata_For_All_Objects.sql) >> >> >> >> Line : 74 >> >> Statement : INSERT INTO metadatavalue (resource_id, resource_type_id, >> metadata_field_id, text_value, text_lang, place) >> >> SELECT >> >> community_id AS resource_id, >> >> 4 AS resource_type_id, >> >> (select metadata_field_id from metadatafieldregistry where >> metadata_schema_id=(select metadata_schema_id from metadataschemaregistry >> where short_id='dc') and element = 'title' and qualifier is null) AS >> metadata_field_id, >> >> name AS text_value, >> >> null AS text_lang, >> >> 0 AS place >> >> FROM community where not name is null >> >> >> >> at >> org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:369) >> >> >> >> at >> org.flywaydb.core.internal.command.DbMigrate.access$200(DbMigrate.java:54) >> >> at >> org.flywaydb.core.internal.command.DbMigrate$3.call(DbMigrate.java:282) >> >> at >> org.flywaydb.core.internal.jdbc.TransactionalExecutionTemplate.execute(TransactionalExecutionTemplate.java:66) >> >> >> >> at >> org.flywaydb.core.internal.command.DbMigrate.applyMigrations(DbMigrate.java:279) >> >> >> >> at >> org.flywaydb.core.internal.command.DbMigrate.migrateGroup(DbMigrate.java:244) >> >> >> >> at >> org.flywaydb.core.internal.command.DbMigrate.access$100(DbMigrate.java:54) >> >> at >> org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:162) >> >> at >> org.flywaydb.core.internal.command.DbMigrate$2.call(DbMigrate.java:159) >> >> at >> org.flywaydb.core.internal.database.postgresql.PostgreSQLAdvisoryLockTemplate.execute(PostgreSQLAdvisoryLockTemplate.java:71) >> >> >> >> at >> org.flywaydb.core.internal.database.postgresql.PostgreSQLConnection.lock(PostgreSQLConnection.java:99) >> >> >> >> at >> org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory.lock(JdbcTableSchemaHistory.java:140) >> >> >> >> at >> org.flywaydb.core.internal.command.DbMigrate.migrateAll(DbMigrate.java:159) >> >> at >> org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:137) >> >> at org.flywaydb.core.Flyway$1.execute(Flyway.java:206) >> >> 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) >> >> >> >> ... 9 more >> >> Caused by: org.flywaydb.core.internal.sqlscript.FlywaySqlScriptException: >> >> >> Migration V5.0_2014.09.26__DS-1582_Metadata_For_All_Objects.sql failed >> >> ---------------------------------------------------------------------- >> >> SQL State : 21000 >> >> Error Code : 0 >> >> Message : ERROR: more than one row returned by a subquery used as an >> expression >> >> Location : >> org/dspace/storage/rdbms/sqlmigration/postgres/V5.0_2014.09.26__DS-1582_Metadata_For_All_Objects.sql >> >> (/dspace/bin/file:/dspace/lib/dspace-api-7.2.jar!/org/dspace/storage/rdbms/sqlmigration/postgres/V5.0_2014.09.26__DS-1582_Metadata_For_All_Objects.sql) >> >> >> >> Line : 74 >> >> Statement : INSERT INTO metadatavalue (resource_id, resource_type_id, >> metadata_field_id, text_value, text_lang, place) >> >> SELECT >> >> community_id AS resource_id, >> >> 4 AS resource_type_id, >> >> (select metadata_field_id from metadatafieldregistry where >> metadata_schema_id=(select metadata_schema_id from metadataschemaregistry >> where short_id='dc') and element = 'title' and qualifier is null) AS >> metadata_field_id, >> >> name AS text_value, >> >> null AS text_lang, >> >> 0 AS place >> >> FROM community where not name is null >> >> >> >> at >> org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.handleException(DefaultSqlScriptExecutor.java:274) >> >> >> >> at >> org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:219) >> >> >> >> at >> org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.execute(DefaultSqlScriptExecutor.java:127) >> >> >> >> at >> org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.executeOnce(SqlMigrationExecutor.java:88) >> >> >> >> at >> org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.access$000(SqlMigrationExecutor.java:33) >> >> >> >> at >> org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor$1.call(SqlMigrationExecutor.java:77) >> >> >> >> at >> org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor$1.call(SqlMigrationExecutor.java:74) >> >> >> >> at >> org.flywaydb.core.internal.database.DefaultExecutionStrategy.execute(DefaultExecutionStrategy.java:28) >> >> >> >> at >> org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(SqlMigrationExecutor.java:74) >> >> >> >> at >> org.flywaydb.core.internal.command.DbMigrate.doMigrateGroup(DbMigrate.java:366) >> >> >> >> ... 27 more >> >> Caused by: org.postgresql.util.PSQLException: ERROR: more than one row >> returned by a subquery used as an expression >> >> at >> org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2565) >> >> >> >> at >> org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2297) >> >> >> >> at >> org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:322) >> >> >> at >> org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:481) >> >> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:401) >> >> at >> org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:322) >> >> at >> org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:308) >> >> at >> org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:284) >> >> at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:279) >> >> at >> org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) >> >> >> >> at >> org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatement.java:194) >> >> >> >> at >> org.flywaydb.core.internal.jdbc.JdbcTemplate.executeStatement(JdbcTemplate.java:244) >> >> >> >> at >> org.flywaydb.core.internal.sqlscript.ParsedSqlStatement.execute(ParsedSqlStatement.java:111) >> >> >> >> at >> org.flywaydb.core.internal.sqlscript.DefaultSqlScriptExecutor.executeStatement(DefaultSqlScriptExecutor.java:207) >> >> >> >> ... 35 more >> >> ==================================================================== >> >> Dspace.log after migration attempt shows this: >> >> 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 >> >> INFO unknown unknown org.flywaydb.core.internal.database.DatabaseFactory >> @ Database: jdbc:postgresql://localhost:5432/dspace (PostgreSQL 12.9) >> >> INFO unknown unknown >> org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory @ Creating >> Schema History table "public"."schema_version" with baseline ... >> >> INFO unknown unknown org.flywaydb.core.internal.command.DbBaseline @ >> Successfully baselined schema with version: 4.0 >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ Pending >> DSpace database schema migrations: >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 4.9.2015.10.26 DS-2818 registry update SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 5.0.2014.08.08 DS-1945 Helpdesk Request a Copy SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 5.0.2014.09.25 DS 1582 Metadata For All Objects drop constraint JDBC >> PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 5.0.2014.09.26 DS-1582 Metadata For All Objects SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 5.0.2014.11.04 Enable XMLWorkflow Migration JDBC PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 5.6.2016.08.23 DS-3097 SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 5.7.2017.04.11 DS-3563 Index metadatavalue resource type id column SQL >> PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 5.7.2017.05.05 DS 3431 Add Policies for BasicWorkflow JDBC PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2015.03.06 DS 2701 Dso Uuid Migration JDBC PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2015.03.07 DS-2701 Hibernate migration SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2015.08.31 DS 2701 Hibernate Workflow Migration JDBC PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2015.09.01 DS 2701 Enable XMLWorkflow Migration JDBC PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2016.01.03 DS-3024 SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2016.01.26 DS 2188 Remove DBMS Browse Tables JDBC PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2016.02.25 DS-3004-slow-searching-as-admin SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2016.04.01 DS-1955 Increase embargo reason SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2016.04.04 DS-3086-OAI-Performance-fix SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2016.04.14 DS-3125-fix-bundle-bitstream-delete-rights SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2016.05.10 DS-3168-fix-requestitem item id column SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2016.07.21 DS-2775 SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2016.07.26 DS-3277 fix handle assignment SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.0.2016.08.23 DS-3097 SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 6.1.2017.01.03 DS 3431 Add Policies for BasicWorkflow JDBC PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2017.10.12 DS-3542-stateless-sessions SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2018.04.03 Upgrade Workflow Policy JDBC PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2018.04.16 dspace-entities SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2018.06.07 DS-3851-permission SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2019.05.02 DS-4239-workflow-xml-migration SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2019.06.14 scripts-and-process SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2019.07.31 Retrieval of name variant SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2019.11.13 relationship type copy left right SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2020.01.08 DS-626-statistics-tracker SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2020.10.31 CollectionCommunity Metadata Handle JDBC PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2021.01.22 Remove basic workflow SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2021.02.08 tilted rels SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2021.03.18 Move entity type to dspace schema SQL PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2021.09.24 Move entity type from item template to collection SQL >> PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.0.2021.10.04 alter collection table drop workflow stem columns SQL >> PENDING >> >> INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ >> 7.1.2021.10.18 Fix MDV place after migrating from DSpace 5 SQL PENDING >> >> INFO unknown unknown org.flywaydb.core.internal.command.DbValidate @ >> Successfully validated 51 migrations (execution time 00:00.119s) >> >> INFO unknown unknown org.flywaydb.core.internal.command.DbMigrate @ >> Current version of schema "public": 4.0 >> >> WARN unknown unknown org.flywaydb.core.internal.command.DbMigrate @ >> outOfOrder mode is active. Migration of schema "public" may not be >> reproducible. >> >> INFO unknown unknown org.flywaydb.core.internal.command.DbMigrate @ >> Migrating schema "public" to version 4.9.2015.10.26 - DS-2818 registry >> update >> >> INFO unknown unknown org.flywaydb.core.internal.command.DbMigrate @ >> Migrating schema "public" to version 5.0.2014.08.08 - DS-1945 Helpdesk >> Request a Copy >> >> INFO unknown unknown org.flywaydb.core.internal.command.DbMigrate @ >> Migrating schema "public" to version 5.0.2014.09.25 - DS 1582 Metadata For >> All Objects drop constraint >> >> INFO unknown unknown org.flywaydb.core.internal.command.DbMigrate @ >> Migrating schema "public" to version 5.0.2014.09.26 - DS-1582 Metadata For >> All Objects >> >> ERROR unknown unknown org.flywaydb.core.internal.command.DbMigrate @ >> Migration of schema "public" to version 5.0.2014.09.26 - DS-1582 Metadata >> For All Objects failed! Changes successfully rolled >> >> INFO unknown unknown >> org.springframework.cache.ehcache.EhCacheManagerFactoryBean @ Shutting down >> EhCache CacheManager 'org.dspace.services' >> ==================================================================== >> I read previous posts about both "*Migration >> V5.0_2014.09.26__DS-1582_Metadata_For_All_Objects.sql failed*" and >> "*relation >> "handle_id_seq*" does not exist" errors, but reverting to previous >> snapshots and retrying the database migration still doesn't work for me >> yet. Your suggestions will be most welcome! >> > -- 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/daab6ed8-6440-48df-80e5-8a0bd7dfb6a7n%40googlegroups.com.
2022-02-28 23:26:01,006 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:26:02,483 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:26:02,553 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:26:02,560 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:26:02,577 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:26:02,612 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:26:11,423 INFO unknown unknown org.eclipse.jetty.util.log @ Logging initialized @34477ms to org.eclipse.jetty.util.log.Slf4jLog 2022-02-28 23:26:12,719 INFO unknown unknown org.springframework.cache.ehcache.EhCacheManagerFactoryBean @ Initializing EhCache CacheManager 'org.dspace.services' 2022-02-28 23:26:15,621 INFO unknown unknown org.dspace.importer.external.service.ImportService @ Loading 6 import sources. 2022-02-28 23:26:16,255 INFO unknown unknown org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor @ Autowired annotation is not supported on static methods: public static void org.dspace.rdf.storage.DOIURIGenerator.setFallback(org.dspace.rdf.storage.URIGenerator) 2022-02-28 23:26:16,273 INFO unknown unknown org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor @ Autowired annotation is not supported on static methods: public static void org.dspace.rdf.storage.DOIHandleURIGenerator.setFallback(org.dspace.rdf.storage.URIGenerator) 2022-02-28 23:26:17,070 WARN unknown unknown org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by name or id=database. Will try to look up bean by type next. org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'database' available at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:808) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1279) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1114) ~[spring-context-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426) [dspace-services-7.2.jar:7.2] at org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:33) [dspace-api-7.2.jar:7.2] at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125) [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-02-28 23:26:18,339 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-02-28 23:26:18,370 INFO unknown unknown org.flywaydb.core.internal.license.VersionPrinter @ Flyway Community Edition 6.5.7 by Redgate 2022-02-28 23:26:18,615 INFO unknown unknown org.flywaydb.core.internal.database.DatabaseFactory @ Database: jdbc:postgresql://localhost:5432/dspace (PostgreSQL 12.9) 2022-02-28 23:26:19,494 INFO unknown unknown org.springframework.cache.ehcache.EhCacheManagerFactoryBean @ Shutting down EhCache CacheManager 'org.dspace.services' 2022-02-28 23:31:57,177 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:31:58,158 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:31:58,232 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:31:58,244 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:31:58,258 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:31:58,307 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:32:05,275 INFO unknown unknown org.eclipse.jetty.util.log @ Logging initialized @12392ms to org.eclipse.jetty.util.log.Slf4jLog 2022-02-28 23:32:06,255 INFO unknown unknown org.springframework.cache.ehcache.EhCacheManagerFactoryBean @ Initializing EhCache CacheManager 'org.dspace.services' 2022-02-28 23:32:08,809 INFO unknown unknown org.dspace.importer.external.service.ImportService @ Loading 6 import sources. 2022-02-28 23:32:09,227 INFO unknown unknown org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor @ Autowired annotation is not supported on static methods: public static void org.dspace.rdf.storage.DOIURIGenerator.setFallback(org.dspace.rdf.storage.URIGenerator) 2022-02-28 23:32:09,272 INFO unknown unknown org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor @ Autowired annotation is not supported on static methods: public static void org.dspace.rdf.storage.DOIHandleURIGenerator.setFallback(org.dspace.rdf.storage.URIGenerator) 2022-02-28 23:32:10,197 WARN unknown unknown org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by name or id=database. Will try to look up bean by type next. org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'database' available at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:808) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1279) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1114) ~[spring-context-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426) [dspace-services-7.2.jar:7.2] at org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:33) [dspace-api-7.2.jar:7.2] at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125) [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-02-28 23:32:11,192 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-02-28 23:32:11,213 INFO unknown unknown org.flywaydb.core.internal.license.VersionPrinter @ Flyway Community Edition 6.5.7 by Redgate 2022-02-28 23:32:11,475 INFO unknown unknown org.flywaydb.core.internal.database.DatabaseFactory @ Database: jdbc:postgresql://localhost:5432/dspace (PostgreSQL 12.9) 2022-02-28 23:32:12,157 INFO unknown unknown org.springframework.cache.ehcache.EhCacheManagerFactoryBean @ Shutting down EhCache CacheManager 'org.dspace.services' 2022-02-28 23:38:02,920 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:38:04,353 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:38:04,465 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:38:04,489 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:38:04,530 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:38:04,587 INFO unknown unknown org.apache.commons.beanutils.FluentPropertyBeanIntrospector @ Error when creating PropertyDescriptor for public final void org.apache.commons.configuration2.AbstractConfiguration.setProperty(java.lang.String,java.lang.Object)! Ignoring this property. 2022-02-28 23:38:14,582 INFO unknown unknown org.eclipse.jetty.util.log @ Logging initialized @19080ms to org.eclipse.jetty.util.log.Slf4jLog 2022-02-28 23:38:15,521 INFO unknown unknown org.springframework.cache.ehcache.EhCacheManagerFactoryBean @ Initializing EhCache CacheManager 'org.dspace.services' 2022-02-28 23:38:18,136 INFO unknown unknown org.dspace.importer.external.service.ImportService @ Loading 6 import sources. 2022-02-28 23:38:18,686 INFO unknown unknown org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor @ Autowired annotation is not supported on static methods: public static void org.dspace.rdf.storage.DOIURIGenerator.setFallback(org.dspace.rdf.storage.URIGenerator) 2022-02-28 23:38:18,714 INFO unknown unknown org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor @ Autowired annotation is not supported on static methods: public static void org.dspace.rdf.storage.DOIHandleURIGenerator.setFallback(org.dspace.rdf.storage.URIGenerator) 2022-02-28 23:38:19,549 WARN unknown unknown org.dspace.servicemanager.DSpaceServiceManager @ Unable to locate bean by name or id=database. Will try to look up bean by type next. org.springframework.beans.factory.NoSuchBeanDefinitionException: No bean named 'database' available at org.springframework.beans.factory.support.DefaultListableBeanFactory.getBeanDefinition(DefaultListableBeanFactory.java:808) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getMergedLocalBeanDefinition(AbstractBeanFactory.java:1279) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:297) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:207) ~[spring-beans-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1114) ~[spring-context-5.2.5.RELEASE.jar:5.2.5.RELEASE] at org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:426) [dspace-services-7.2.jar:7.2] at org.dspace.scripts.ScriptServiceImpl.getScriptConfiguration(ScriptServiceImpl.java:33) [dspace-api-7.2.jar:7.2] at org.dspace.app.launcher.ScriptLauncher.handleScript(ScriptLauncher.java:125) [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-02-28 23:38:20,891 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-02-28 23:38:20,922 INFO unknown unknown org.flywaydb.core.internal.license.VersionPrinter @ Flyway Community Edition 6.5.7 by Redgate 2022-02-28 23:38:21,159 INFO unknown unknown org.flywaydb.core.internal.database.DatabaseFactory @ Database: jdbc:postgresql://localhost:5432/dspace (PostgreSQL 12.9) 2022-02-28 23:38:21,565 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-02-28 23:38:21,631 INFO unknown unknown org.flywaydb.core.internal.database.DatabaseFactory @ Database: jdbc:postgresql://localhost:5432/dspace (PostgreSQL 12.9) 2022-02-28 23:38:21,798 INFO unknown unknown org.flywaydb.core.internal.schemahistory.JdbcTableSchemaHistory @ Creating Schema History table "public"."schema_version" with baseline ... 2022-02-28 23:38:21,974 INFO unknown unknown org.flywaydb.core.internal.command.DbBaseline @ Successfully baselined schema with version: 4.0 2022-02-28 23:38:22,126 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ Pending DSpace database schema migrations: 2022-02-28 23:38:22,163 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 4.9.2015.10.26 DS-2818 registry update SQL PENDING 2022-02-28 23:38:22,163 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 5.0.2014.08.08 DS-1945 Helpdesk Request a Copy SQL PENDING 2022-02-28 23:38:22,163 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 5.0.2014.09.25 DS 1582 Metadata For All Objects drop constraint JDBC PENDING 2022-02-28 23:38:22,163 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 5.0.2014.09.26 DS-1582 Metadata For All Objects SQL PENDING 2022-02-28 23:38:22,163 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 5.0.2014.11.04 Enable XMLWorkflow Migration JDBC PENDING 2022-02-28 23:38:22,163 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 5.6.2016.08.23 DS-3097 SQL PENDING 2022-02-28 23:38:22,164 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 5.7.2017.04.11 DS-3563 Index metadatavalue resource type id column SQL PENDING 2022-02-28 23:38:22,164 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 5.7.2017.05.05 DS 3431 Add Policies for BasicWorkflow JDBC PENDING 2022-02-28 23:38:22,164 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2015.03.06 DS 2701 Dso Uuid Migration JDBC PENDING 2022-02-28 23:38:22,164 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2015.03.07 DS-2701 Hibernate migration SQL PENDING 2022-02-28 23:38:22,164 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2015.08.31 DS 2701 Hibernate Workflow Migration JDBC PENDING 2022-02-28 23:38:22,165 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2015.09.01 DS 2701 Enable XMLWorkflow Migration JDBC PENDING 2022-02-28 23:38:22,165 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.01.03 DS-3024 SQL PENDING 2022-02-28 23:38:22,165 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.01.26 DS 2188 Remove DBMS Browse Tables JDBC PENDING 2022-02-28 23:38:22,165 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.02.25 DS-3004-slow-searching-as-admin SQL PENDING 2022-02-28 23:38:22,165 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.04.01 DS-1955 Increase embargo reason SQL PENDING 2022-02-28 23:38:22,165 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.04.04 DS-3086-OAI-Performance-fix SQL PENDING 2022-02-28 23:38:22,165 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.04.14 DS-3125-fix-bundle-bitstream-delete-rights SQL PENDING 2022-02-28 23:38:22,166 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.05.10 DS-3168-fix-requestitem item id column SQL PENDING 2022-02-28 23:38:22,166 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.07.21 DS-2775 SQL PENDING 2022-02-28 23:38:22,166 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.07.26 DS-3277 fix handle assignment SQL PENDING 2022-02-28 23:38:22,166 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.0.2016.08.23 DS-3097 SQL PENDING 2022-02-28 23:38:22,166 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 6.1.2017.01.03 DS 3431 Add Policies for BasicWorkflow JDBC PENDING 2022-02-28 23:38:22,166 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2017.10.12 DS-3542-stateless-sessions SQL PENDING 2022-02-28 23:38:22,166 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2018.04.03 Upgrade Workflow Policy JDBC PENDING 2022-02-28 23:38:22,166 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2018.04.16 dspace-entities SQL PENDING 2022-02-28 23:38:22,166 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2018.06.07 DS-3851-permission SQL PENDING 2022-02-28 23:38:22,167 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2019.05.02 DS-4239-workflow-xml-migration SQL PENDING 2022-02-28 23:38:22,167 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2019.06.14 scripts-and-process SQL PENDING 2022-02-28 23:38:22,167 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2019.07.31 Retrieval of name variant SQL PENDING 2022-02-28 23:38:22,167 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2019.11.13 relationship type copy left right SQL PENDING 2022-02-28 23:38:22,167 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2020.01.08 DS-626-statistics-tracker SQL PENDING 2022-02-28 23:38:22,167 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2020.10.31 CollectionCommunity Metadata Handle JDBC PENDING 2022-02-28 23:38:22,168 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2021.01.22 Remove basic workflow SQL PENDING 2022-02-28 23:38:22,168 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2021.02.08 tilted rels SQL PENDING 2022-02-28 23:38:22,168 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2021.03.18 Move entity type to dspace schema SQL PENDING 2022-02-28 23:38:22,168 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2021.09.24 Move entity type from item template to collection SQL PENDING 2022-02-28 23:38:22,168 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.0.2021.10.04 alter collection table drop workflow stem columns SQL PENDING 2022-02-28 23:38:22,168 INFO unknown unknown org.dspace.storage.rdbms.DatabaseUtils @ 7.1.2021.10.18 Fix MDV place after migrating from DSpace 5 SQL PENDING 2022-02-28 23:38:22,297 INFO unknown unknown org.flywaydb.core.internal.command.DbValidate @ Successfully validated 51 migrations (execution time 00:00.089s) 2022-02-28 23:38:22,379 INFO unknown unknown org.flywaydb.core.internal.command.DbMigrate @ Current version of schema "public": 4.0 2022-02-28 23:38:22,380 WARN unknown unknown org.flywaydb.core.internal.command.DbMigrate @ outOfOrder mode is active. Migration of schema "public" may not be reproducible. 2022-02-28 23:38:22,411 INFO unknown unknown org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 4.9.2015.10.26 - DS-2818 registry update 2022-02-28 23:38:22,560 INFO unknown unknown org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 5.0.2014.08.08 - DS-1945 Helpdesk Request a Copy 2022-02-28 23:38:22,606 INFO unknown unknown org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 5.0.2014.09.25 - DS 1582 Metadata For All Objects drop constraint 2022-02-28 23:38:22,720 INFO unknown unknown org.flywaydb.core.internal.command.DbMigrate @ Migrating schema "public" to version 5.0.2014.09.26 - DS-1582 Metadata For All Objects 2022-02-28 23:38:23,938 ERROR unknown unknown org.flywaydb.core.internal.command.DbMigrate @ Migration of schema "public" to version 5.0.2014.09.26 - DS-1582 Metadata For All Objects failed! Changes successfully rolled back. 2022-02-28 23:38:24,348 INFO unknown unknown org.springframework.cache.ehcache.EhCacheManagerFactoryBean @ Shutting down EhCache CacheManager 'org.dspace.services'
