I saw the earlier posting on a problem with cleanup that stopped running with a message like this one:
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on > table "bitstream" violates foreign key constraint > "bundle_primary_bitstream_id_fkey" on table "bundle" > Detail: Key (uuid)=(02caead4-de93-4011-8105-0e6921f286d8) is still > referenced from table "bundle". I have the same issue with 7.6 and the suggestions Mark Wood included in response on June 12 has been working for me. Well, sort of. I fixed 9 or 10 using Mark's method and then cleanup died with this error message: 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)=(ca1a4a1e-5fd0-418e-96f6-6911475a8b2f) is still referenced from table "requestitem". Mark's suggestion does not work for this table but I wonder if someone else has encountered this issue and has the SQL that might fix it? Thanks. - Wally Grotophorst George Mason University -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/84f8e203-e881-4559-b440-bc667e27edffn%40googlegroups.com.
