Apologies, my fingers outpaced my reading and I sent this to the general list before reading the banner suggesting these kinds of questions come here.
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 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/c2f7eefa-ad37-40f2-81d6-1f61dea51493n%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 | +-----------+----------------+------------------------------------------------------+----------+---------------------+--------------+