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 dspace-tech+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/dspace-tech/f20cf849-cca8-4387-9d4b-6d23741bed5bn%40googlegroups.com.
