Comment 6 for bug 1964137

I finally solved it manually editing the database. I will publish my solution just in case somebody falls in the same problem.

1. Do ssh to the controller node and launch mariadb

2. Remove entries in the database "nova_api", table "host_mappings"

   USE nova_api;
   DELETE FROM host_mappings WHERE host='catgpa01';
   USE nova;

   USE placement;
   SELECT id FROM resource_providers WHERE name="catgpa01"; /* got 17 */
   DELETE FROM resource_provider_traits WHERE resource_provider_id=17; /* 17, from prev query */
   SET FOREIGN_KEY_CHECKS=0;
   DELETE FROM resource_providers WHERE name='catgpa01';
   SET FOREIGN_KEY_CHECKS=1;

   USE nova;
   SELECT id FROM compute_nodes WHERE hypervisor_hostname="catgpa01" AND deleted_at=NULL; /* got 17*/
   DELETE FROM pci_devices WHERE compute_node_id=17; /* 17, from prev query */
   DELETE FROM compute_nodes WHERE id=17; /* 17, from prev query */
   DELETE FROM services WHERE host="catgpa01" AND deleted_at=NULL;