Comment 4 for bug 1817833

The docs explicitly say that the nova-compute service needs to be stopped before you delete the resource:

https://developer.openstack.org/api-ref/compute/?expanded=delete-compute-service-detail#delete-compute-service

Otherwise the running compute service will try to recreate the compute_nodes table and resource providers records.