I have a small environment where controllers and computers run on the same nodes and yes that is a bad idea. But now what happened the machine got OOM out and crashed and stuck somewhere in Zombie stat. I have deleted all vms but it didn't work. Later I used the "virsh destroy" command to delete those vms and everything recovered but my openstack hypervisor state show" command still says you have 91 VMs hanging in DB. 

How do i clean up vms entered from nova DB which doesn't exist at all. 

I have tried the command "nova-manage db archive_deleted_rows" but it didn't help. How does nova sync DB with current stat? 

# openstack hypervisor stats show
This command is deprecated.
+----------------------+--------+
| Field                | Value  |
+----------------------+--------+
| count                | 3      |
| current_workload     | 11     |
| disk_available_least | 15452  |
| free_disk_gb         | 48375  |
| free_ram_mb          | 192464 |
| local_gb             | 50286  |
| local_gb_used        | 1911   |
| memory_mb            | 386570 |
| memory_mb_used       | 194106 |
| running_vms          | 91     |
| vcpus                | 144    |
| vcpus_used           | 184    |
+----------------------+--------+

Technically I have only single VM

# openstack server list --all
+--------------------------------------+---------+--------+---------------------------------+------------+----------+
| ID                                   | Name    | Status | Networks                        | Image      | Flavor   |
+--------------------------------------+---------+--------+---------------------------------+------------+----------+
| b33fd79d-2b90-41dd-a070-29f92ce205e7 | foo1 | ACTIVE | 1=100.100.75.22, 192.168.1.139 | ubuntu2204 | m1.small |
+--------------------------------------+---------+--------+---------------------------------+------------+----------+