[Nova] Clean up dead vms entries from DB

Satish Patel satish.txt at gmail.com
Fri May 5 19:14:18 UTC 2023


Folks,

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 |
+--------------------------------------+---------+--------+---------------------------------+------------+----------+
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.openstack.org/pipermail/openstack-discuss/attachments/20230505/529f5c69/attachment.htm>


More information about the openstack-discuss mailing list