We're having some trouble testing out DSpace 7.3 coming from 6.2,
specifically the database migrations. We seemed to run into the same issue
referenced at https://groups.google.com/g/dspace-tech/c/N24obvE1mVQ and
https://groups.google.com/g/dspace-tech/c/enhTBvnQm68/m/WnEgFm2-AwAJ and
were able to remove that specific migration, but then the next migration,
V5_7_2017_05_05__DS_3431_Add_Policies_for_BasicWorkflow, threw errors
referencing "Caused by: org.postgresql.util.PSQLException: ERROR: operator
does not exist: integer = uuid".
I'm attaching the output of our ./dspace database info below, but it shows
that prior to our upgrade attempt the last successful migration was
6.1.2017.01.03 in 2017, and 4.9.2015.10.26, 5.0.2014.11.04, 5.7.2017.05.05,
and 6.0.2015.09.01 had been Ignored.
I have a theory, and if anybody can tell me if it seems to be on the right
track (or way off), what else we should be looking at, or anything else I
would be very grateful. the 5.7.2017.05.05 migration that is failing is to
Add Policies for BasicWorkflow, and one of the migrations that had been
skipped (but ran successful as an Out of Order migration as we tried to
update) was 5.0.2014.11.04, Enable XMLWorkflow Migration. Combined with the
error returned about types not matching, it seems possible we did not run
the 5.0.2014.11.04 migration and have since ingested a lot of data into our
database with a field of type int when it should have been changed to type
uuid. Now, since the migrations have been ignored for a mighty long time,
it's causing this trouble when trying to upgrade.
If anybody has any input or suggestions, or ideas for more data or other
places to look that might be helpful, we would be most appreciative.
Ed Hill
Developer and Applications Administrator
Colorado State University Libraries
--
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 Community" 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-community/b8f64865-bde9-4f9b-94bd-93e8c1a7a100n%40googlegroups.com.
Database Type: postgres
Database URL: jdbc:postgresql://localhost:5432/dspace
Database Schema: public
Database Username: dspace
Database Software: PostgreSQL version 13.8 (Ubuntu 13.8-1.pgdg20.04+1)
Database Driver: PostgreSQL JDBC Driver version 42.3.3
PostgreSQL 'pgcrypto' extension installed/up-to-date? true (version=1.3)
FlywayDB Version: 8.4.4
+-----------+----------------+------------------------------------------------------+----------+---------------------+--------------+
| Category | Version | Description
| Type | Installed On | State |
+-----------+----------------+------------------------------------------------------+----------+---------------------+--------------+
| | 1 | << Flyway Init >>
| BASELINE | 2015-06-16 15:49:59 | Baseline |
| Versioned | 1.1 | Initial DSpace 1.1 database schema
| SQL | 2015-06-16 15:49:59 | Success |
| Versioned | 1.2 | Upgrade to DSpace 1.2 schema
| SQL | 2015-06-16 15:49:59 | Success |
| Versioned | 1.3 | Upgrade to DSpace 1.3 schema
| SQL | 2015-06-16 15:49:59 | Success |
| Versioned | 1.3.9 | Drop constraint for DSpace 1 4 schema
| JDBC | 2015-06-16 15:49:59 | Success |
| Versioned | 1.4 | Upgrade to DSpace 1.4 schema
| SQL | 2015-06-16 15:49:59 | Success |
| Versioned | 1.5 | Upgrade to DSpace 1.5 schema
| SQL | 2015-06-16 15:49:59 | Success |
| Versioned | 1.5.9 | Drop constraint for DSpace 1 6 schema
| JDBC | 2015-06-16 15:50:00 | Success |
| Versioned | 1.6 | Upgrade to DSpace 1.6 schema
| SQL | 2015-06-16 15:50:00 | Success |
| Versioned | 1.7 | Upgrade to DSpace 1.7 schema
| SQL | 2015-06-16 15:50:00 | Success |
| Versioned | 1.8 | Upgrade to DSpace 1.8 schema
| SQL | 2015-06-16 15:50:00 | Success |
| Versioned | 3.0 | Upgrade to DSpace 3.x schema
| SQL | 2015-06-16 15:50:00 | Success |
| Versioned | 4.0 | Upgrade to DSpace 4.x schema
| SQL | 2015-06-16 15:50:00 | Success |
| Versioned | 5.0.2014.08.08 | DS-1945 Helpdesk Request a Copy
| SQL | 2015-06-16 15:50:00 | Success |
| Versioned | 5.0.2014.09.25 | DS 1582 Metadata For All Objects drop constraint
| JDBC | 2015-06-16 15:50:00 | Success |
| Versioned | 5.0.2014.09.26 | DS-1582 Metadata For All Objects
| SQL | 2015-06-16 15:50:00 | Success |
| Versioned | 5.6.2016.08.23 | DS-3097
| SQL | 2017-06-26 07:02:08 | Success |
| Versioned | 6.0.2015.03.06 | DS 2701 Dso Uuid Migration
| JDBC | 2017-06-26 07:02:08 | Success |
| Versioned | 6.0.2015.03.07 | DS-2701 Hibernate migration
| SQL | 2017-06-26 07:02:08 | Success |
| Versioned | 6.0.2015.08.31 | DS 2701 Hibernate Workflow Migration
| JDBC | 2017-06-26 07:05:18 | Success |
| Versioned | 6.0.2016.01.03 | DS-3024
| SQL | 2017-06-26 07:05:18 | Success |
| Versioned | 6.0.2016.01.26 | DS 2188 Remove DBMS Browse Tables
| JDBC | 2017-06-26 07:05:18 | Success |
| Versioned | 6.0.2016.02.25 | DS-3004-slow-searching-as-admin
| SQL | 2017-06-26 07:05:18 | Success |
| Versioned | 6.0.2016.04.01 | DS-1955 Increase embargo reason
| SQL | 2017-06-26 07:05:18 | Success |
| Versioned | 6.0.2016.04.04 | DS-3086-OAI-Performance-fix
| SQL | 2017-06-26 07:05:18 | Success |
| Versioned | 6.0.2016.04.14 | DS-3125-fix-bundle-bitstream-delete-rights
| SQL | 2017-06-26 07:05:20 | Success |
| Versioned | 6.0.2016.05.10 | DS-3168-fix-requestitem item id column
| SQL | 2017-06-26 07:05:21 | Success |
| Versioned | 6.0.2016.07.21 | DS-2775
| SQL | 2017-06-26 07:05:21 | Success |
| Versioned | 6.0.2016.07.26 | DS-3277 fix handle assignment
| SQL | 2017-06-26 07:05:21 | Success |
| Versioned | 6.0.2016.08.23 | DS-3097
| SQL | 2017-06-26 07:05:21 | Success |
| Versioned | 6.1.2017.01.03 | DS 3431 Add Policies for BasicWorkflow
| JDBC | 2017-10-08 21:21:34 | Success |
| Versioned | 4.9.2015.10.26 | DS-2818 registry update
| SQL | 2022-10-07 11:44:48 | Out of Order |
| Versioned | 5.0.2014.11.04 | Enable XMLWorkflow Migration
| JDBC | 2022-10-07 11:44:48 | Out of Order |
| Versioned | 5.7.2017.05.05 | DS 3431 Add Policies for BasicWorkflow
| JDBC | | Ignored |
| Versioned | 6.0.2015.09.01 | DS 2701 Enable XMLWorkflow Migration
| JDBC | | Ignored |
| 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 |
| Versioned | 7.3.2022.04.29 | orcid queue and history
| SQL | | Pending |
| Versioned | 7.3.2022.05.16 | Orcid token table
| SQL | | Pending |
| Versioned | 7.3.2022.06.16 | process to group
| SQL | | Pending |
| Versioned | 7.3.2022.06.20 | add last version status column to relationship
table | SQL | | Pending |
+-----------+----------------+------------------------------------------------------+----------+---------------------+--------------+
