DSpace 7 upgrade migration issues

[Ed Hill]

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

[Tim Donohue]

This question was answered on dspace-tech: https://groups.google.com/g/dspace-tech/c/F6ztOrBjXBA/m/fe3UP0_KAgAJ

---

From: dspace-c...@googlegroups.com <dspace-c...@googlegroups.com> on behalf of Ed Hill <ed....@colostate.edu>
Sent: Monday, October 10, 2022 3:56 PM
To: DSpace Community <dspace-c...@googlegroups.com>
Subject: [dspace-community] DSpace 7 upgrade migration issues

 

--
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 dspace-communi...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-community/b8f64865-bde9-4f9b-94bd-93e8c1a7a100n%40googlegroups.com.