[Nova] Clean up dead vms entries from DB

Eugen Block eblock at nde.ag
Sun May 7 08:31:27 UTC 2023


Hi,
check out this thread:  
https://lists.openstack.org/pipermail/openstack-discuss/2023-February/032365.html

I had instances in a pending state, Sylvain helped to get rid of  
those. Although it might not be the exact same solution for you it  
could help.

Regards
Eugen

Zitat von Satish Patel <satish.txt at gmail.com>:

> 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 |
> +--------------------------------------+---------+--------+---------------------------------+------------+----------+






More information about the openstack-discuss mailing list