[Archivesspace_Users_Group] trouble deleting some archival objects

[Cobourn, Alston]

Hello,

We've been running into an issue periodically where archival objects won't delete.  AS returns this message: Record deletion failed: Java::JavaSql::SQLIntegrityConstraintViolationException: Cannot delete or update a parent row: a foreign key constraint fails (`archivesspace`.`lang_material`, CONSTRAINT `lang_material_ibfk_1` FOREIGN KEY (`archival_object_id`) REFERENCES `archival_object` (`id`))

Our wonderful IT guy explained it to me as "There's a relationship in the database that ArchivesSpace is (sometimes?) not removing when an archival object is being deleted."  He's not sure if it's an AS issue or a problem with our data.  He has solved the problem each time for us by manually removing the language_and_script object, so he can then remove the lang_material object, so I can then remove the archival_object.
More details:
Table:
    archival_object - objects have an aoID

Table:
    lang_material - objects have a langID and are related to the archival_object table via the aoID

Table:
    language_and_script - objects are related to the lang_material table via the langID

Are others running into this?  I would like to determine if this is an AS bug or something specific with our data.

Thanks,
Alston Cobourn, MLS, CA
Head, University History and Records
East Carolina University
252-328-4090
Cobourna18 at ecu.edu

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lyralists.lyrasis.org/pipermail/archivesspace_users_group/attachments/20230201/e4285ae1/attachment.html>