Metacat

During DataONE CN replication testing, Chris was seeing delete/archive actions fail due to dangling FKs in the xml_index table. I theory is that the asynchronous indexing queue is inserting this entry after the delete action has tried to remove FK references but before the actual xml_documents removal is performed.

I think the long-term solution should be to inspect the index queue during a delete() action and remove the docid from the queue if it is present.