For clarity, the error is *Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "bitstream" violates foreign key constraint "requestitem_bitstream_id_fkey" on table "requestitem"*
* Detail: Key (uuid)=(15b3ebc4-ae05-461e-ab9d-3a39bdb1bb50) is still referenced from table "requestitem".* неділю, 17 березня 2024 р. о 16:07:38 UTC+2 Andrew K пише: Hi! I have the same error on cleanup. Trying to use this method to fix it. But I receive 2 empty rows here instead of some uuids *\set a 15b3ebc4-ae05-461e-ab9d-3a39bdb1bb50 dspace=# SELECT item_id AS b FROM requestitem WHERE bitstream_id = :'a';*b - - - (2 rows) This looks OK though *dspace=# SELECT deleted FROM bitstream WHERE uuid = :'a';* deleted --------- t (1 row) What do I do next? Thanks, Andrew -- 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/d1c689e1-4080-4dc3-8fde-9a3739af0fe8n%40googlegroups.com.
