Hi Alex, There are database modifications in every release, but there's no code in DSpace 8.0 which tries to run "ALTER TABLE IF EXISTS ONLY public.item DROP CONSTRAINT IF EXISTS item_uuid_key;" So, the error isn't making sense to me. The only place in DSpace that I see an "item_uuid_key" constraint is here on the new "qaevent_processed" table (newly added in 8.0): https://github.com/DSpace/DSpace/blob/dspace-8_x/dspace-api/src/main/resources/org/dspace/storage/rdbms/sqlmigration/postgres/V8.0_2023.08.07__qaevent_processed.sql#L16 But, in that situation that's a *new* constraint and not one that should be deleted.
You might consider re-trying the data migration, or even using our official migration recommendations in the documentation at https://wiki.lyrasis.org/display/DSDOC8x/Migrating+DSpace+to+a+new+server This guide walks through the recommended way to export data from one DSpace, and then migrate that data into a new instance...and it can be used to upgrade from 7.x to 8.0. Tim On Friday, July 19, 2024 at 7:32:49 AM UTC-5 zxale...@gmail.com wrote: > Dear Colleagues, > tried to transfer the database dump from DSpace 7.6 to DSpace version 8.0: > > pg_restore: dropping CONSTRAINT item item_uuid_key > pg_restore: while PROCESSING TOC: > pg_restore: from TOC entry 3637; 2606 18745 CONSTRAINT item item_uuid_key > dspace > pg_restore: error: could not execute query: ERROR: cannot drop constraint > item_uuid_key on table public.item because other objects depend on it > DETAIL: constraint item_uuid_fkey on table public.qaevent_processed > depends on index public.item_uuid_key > constraint notifypatterns_to_trigger_item_id_fkey on table > public.notifypatterns_to_trigger depends on index public.item_uuid_key > HINT: Use DROP ... CASCADE to drop the dependent objects too. > Command was: ALTER TABLE IF EXISTS ONLY public.item DROP CONSTRAINT IF > EXISTS item_uuid_key; > --------------------------------------- > Сreated the dump with this command: > pg_dump -U postgres -W -h localhost -Fc -v -C -E UTF8 -d dspace -f > dspace.sql > > tried to transfer: > pg_restore -U postgres -W -h localhost -v -e -c --if-exists -d dspace > dspace.sql > > PostgreSQL 15 > ------------------------------------------ > Has the database structure changed in the DSpace 8.0? > Help me fix this error. > > DSpace UI 8 / REST API 8 > > Best regards, > Alex > > > > > > > > -- 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/4f021048-e76f-47b8-bf70-421881a68259n%40googlegroups.com.
