Hi Ben,
This
same V5.7_2017.04.11__DS-3563_Index_metadatavalue_resource_type_id_column.sql
migration error was discussed a few days ago on this mailing list, see
this thread:
https://groups.google.com/g/dspace-tech/c/N24obvE1mVQ/m/CtWTZ3HOAAAJ
It appears you've also hit it. We initially thought this was very rare,
but it sounds like there is some scenario where sites can encounter this
odd migration issue during the 7.x upgrade.
As for any other migration issues you hit later, each migration is
obviously separate...so, you'd need to send along later errors to this
list if you cannot figure them out.
Tim
On Thursday, January 27, 2022 at 1:34:22 PM UTC-6 bens...@gmail.com wrote:
> command dspace database migrate ignored fails:
> SQL State : 42703
> Error Code : 0
> Message : ERROR: column "resource_type_id" does not exist
> Location :
> org/dspace/storage/rdbms/sqlmigration/postgres/V5.7_2017.04.11__DS-3563_Index_metadatavalue_resource_type_id_column.sql
>
> (/var/lib/tomcat9/webapps/file:/opt/dspace-711/lib/dspace-api-7.1.1.jar!/org/dspace/storage/rdbms/sqlmigration/postgres/V5.7_2017.04.11__DS-3563_Index_metadatavalue_resource_type_id_column.sql)
> Line : 16
> Statement : CREATE INDEX metadatavalue_resource_type_id_idx ON
> metadatavalue (resource_type_id)
>
> BUT my table does not have a field resource_type_id
>
> \d+ metadatavalue
> Table
> "public.metadatavalue"
> Column | Type | Collation | Nullable |
> Default | Storage | Stats target |
> Description
>
> -------------------+------------------------+-----------+----------+------------------------------------------------+----------+--------------+-------------
> metadata_value_id | integer | | not null |
> nextval(('metadatavalue_seq'::text)::regclass) | plain | |
> metadata_field_id | integer | | |
> | plain | |
> text_value | text | | |
> | extended | |
> text_lang | character varying(24) | | |
> | extended | |
> place | integer | | |
> | plain | |
> authority | character varying(100) | | |
> | extended | |
> confidence | integer | | |
> '-1'::integer | plain | |
> dspace_object_id | uuid | | |
> | plain | |
> Indexes:
> "metadatavalue_pkey" PRIMARY KEY, btree (metadata_value_id)
>
> Anyways here is:dspace database info
>
> Database Type: postgres
> Database URL: jdbc:postgresql://localhost:5432/dspacemigrated
> Database Schema: public
> Database Username: dspace
> Database Software: PostgreSQL version 11.14 (Ubuntu 11.14-1.pgdg18.04+1)
> Database Driver: PostgreSQL JDBC Driver version 42.2.24
> 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 | | Below Baseline |
> | Versioned | 1.2 | Upgrade to DSpace 1.2 schema
> | SQL | | Below Baseline |
> | Versioned | 1.3 | Upgrade to DSpace 1.3 schema
> | SQL | | Below Baseline |
> | Versioned | 1.3.9 | Drop constraint for DSpace 1 4 schema
> | JDBC | | Below Baseline |
> | Versioned | 1.4 | Upgrade to DSpace 1.4 schema
> | SQL | | Below Baseline |
> | Versioned | 1.5 | Upgrade to DSpace 1.5 schema
> | SQL | | Below Baseline |
> | Versioned | 1.5.9 | Drop constraint for DSpace 1 6 schema
> | JDBC | | Below Baseline |
> | Versioned | 1.6 | Upgrade to DSpace 1.6 schema
> | SQL | | Below Baseline |
> | Versioned | 1.7 | Upgrade to DSpace 1.7 schema
> | SQL | | Below Baseline |
> | Versioned | 1.8 | Upgrade to DSpace 1.8 schema
> | SQL | | Below Baseline |
> | Versioned | 3.0 | Upgrade to DSpace 3.x schema
> | SQL | | Below Baseline |
> | | 4.0 | Initializing from DSpace 4.0 database
> schema | BASELINE | 2017-07-04 13:07:46 | Baseline |
> | Versioned | 4.9.2015.10.26 | DS-2818 registry update
> | SQL | 2017-07-04 13:07:46 | Success |
> | Versioned | 5.0.2014.08.08 | DS-1945 Helpdesk Request a Copy
> | SQL | 2017-07-04 13:07:46 | Success |
> | Versioned | 5.0.2014.09.25 | DS 1582 Metadata For All Objects drop
> constraint | JDBC | 2017-07-04 13:07:46 | Success |
> | Versioned | 5.0.2014.09.26 | DS-1582 Metadata For All Objects
> | SQL | 2017-07-04 13:07:46 | Success |
> | Versioned | 5.0.2014.11.04 | Enable XMLWorkflow Migration
> | JDBC | | Ignored |
> | Versioned | 5.6.2016.08.23 | DS-3097
> | SQL | 2017-07-04 13:07:55 | Success |
> | Versioned | 5.7.2017.04.11 | DS-3563 Index metadatavalue resource type
> id column | SQL | | Ignored |
> | Versioned | 5.7.2017.05.05 | DS 3431 Add Policies for BasicWorkflow
> | JDBC | | Ignored |
> | Versioned | 6.0.2015.03.06 | DS 2701 Dso Uuid Migration
> | JDBC | 2017-07-04 13:07:55 | Success |
> | Versioned | 6.0.2015.03.07 | DS-2701 Hibernate migration
> | SQL | 2017-07-04 13:07:55 | Success |
> | Versioned | 6.0.2015.08.31 | DS 2701 Hibernate Workflow Migration
> | JDBC | 2017-07-04 13:09:41 | Success |
> | Versioned | 6.0.2015.09.01 | DS 2701 Enable XMLWorkflow Migration
> | JDBC | | Ignored |
> | Versioned | 6.0.2016.01.03 | DS-3024
> | SQL | 2017-07-04 13:09:41 | Success |
> | Versioned | 6.0.2016.01.26 | DS 2188 Remove DBMS Browse Tables
> | JDBC | 2017-07-04 13:09:41 | Success |
> | Versioned | 6.0.2016.02.25 | DS-3004-slow-searching-as-admin
> | SQL | 2017-07-04 13:09:41 | Success |
> | Versioned | 6.0.2016.04.01 | DS-1955 Increase embargo reason
> | SQL | 2017-07-04 13:09:42 | Success |
> | Versioned | 6.0.2016.04.04 | DS-3086-OAI-Performance-fix
> | SQL | 2017-07-04 13:09:42 | Success |
> | Versioned | 6.0.2016.04.14 | DS-3125-fix-bundle-bitstream-delete-rights
> | SQL | 2017-07-04 13:09:43 | Success |
> | Versioned | 6.0.2016.05.10 | DS-3168-fix-requestitem item id column
> | SQL | 2017-07-04 13:09:44 | Success |
> | Versioned | 6.0.2016.07.21 | DS-2775
> | SQL | 2017-07-04 13:09:44 | Success |
> | Versioned | 6.0.2016.07.26 | DS-3277 fix handle assignment
> | SQL | 2017-07-04 13:09:44 | Success |
> | Versioned | 6.0.2016.08.23 | DS-3097
> | SQL | 2017-07-04 13:09:44 | Success |
> | Versioned | 6.1.2017.01.03 | DS 3431 Add Policies for BasicWorkflow
> | JDBC | 2017-07-14 13:14:20 | Success |
> | 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 |
>
> +-----------+----------------+-----------------------------------------------------+----------+---------------------+----------------+
>
> This is not the only error. When I delete the step
>
> org/dspace/storage/rdbms/sqlmigration/postgres/V5.7_2017.04.11__DS-3563_Index_metadatavalue_resource_type_id_column.sql
> It still did not work because another migration error occurred.
>
> Thanks,
> Ben Sheaff
>
--
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/a9acc707-96d3-4122-9ead-d3b21c5fcdaan%40googlegroups.com.
