SQLSTATE[23503]: Foreign key violation: 7 ERROR: update or delete on table "sp_co_people" violates foreign key constraint

in deleting a number of people the SQL provisioner seems to kick out this error (which causes the provisioner job to requeue seemingly forever).  This needs some quick attention, please.  We track the develop branch so a quick fix can be deployed quickly.  I suppose we could delete all the SP tables and the SP provisioner would recreate them (i think) but this seems drastic.
SQLSTATE[23503]: Foreign key violation: 7 ERROR: update or delete on table "sp_co_people" violates foreign key constraint "sp_names_co_person_id_fkey" on table "sp_names"
DETAIL: Key (id)=(51293) is still referenced from table "sp_names".
We had 67K records loaded in from a file using FileSource.  We have a pipeline with sync strategy to sync on delete and Role Status on Delete set to deleted.  There are now 67K jobs with the above error being requeued about every minute.