add a way to quickly purge records from an agent DB when we get unique constraint violation