Hi, Mark was replying to my post then. While cleaning I had the same one case as yours. Since you got to know Mark's method, I'm throwing you my "procedure" without comment:
*ERROR: update or delete on table "bitstream" violates foreign key constraint "requestitem_bitstream_id_fkey" on table "requestitem"* * Szczegóły: Key (uuid)=(e2f6374b-f2ff-435c-9940-f37adc6250aa) is still referenced from table "requestitem".* *\set a e2f6374b-f2ff-435c-9940-f37adc6250aa* *SELECT item_id AS b FROM requestitem WHERE bitstream_id = :'a';* *b* *--------------------------------------* * db43aa8e-855d-42b9-b82c-57c3d469e4f7* db43aa8e-855d-42b9-b82c-57c3d469e4f7 (2 rows) *SELECT deleted FROM bitstream WHERE uuid = :'a';* deleted --------- t (1 row) *\set b* *db43aa8e-855d-42b9-b82c-57c3d469e4f7* *UPDATE requestitem SET bitstream_id = null WHERE item_id = :'b';* UPDATE 2 \q Regards, Mariusz poniedziałek, 3 lipca 2023 o 20:08:03 UTC+2 Wally Grotophorst napisał(a): > 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 dspace-tech+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/78de1b32-b0ae-40d3-9549-96478288bb3dn%40googlegroups.com.
