← Back to team overview

openstack team mailing list archive

Re: Cleaning nova database

 

I think that the quick solution is set deteled to 1 on the offending
instances

Are u using euca tools ? some inconsistencies are generated by them often

Regards
Lean

On Tue, Mar 20, 2012 at 12:19 PM, David Kranz <david.kranz@xxxxxxxxxx>wrote:

> In a diablo/kvm cluster that has been running for a long time, a user
> reported problems with some vms, tried rebooting them and eventually
> deleted them. I recently noticed messages in the nova compute log like:
> Found 13 in the database and 10 on the hypervisor.
>
> Looking at the source code I understand that this means the instances have
> been deleted as far as the hypervisor is concerned, but nova still thinks
> they are there.
> I found the offending instances in the database and they were still listed
> as in the active state even though they
> had a deletion date recorded. I tried to delete them but was unable due to
> a foreign key error with virtual_interfaces. I could play around with
> deleting various things from the database but there are real users. Is
> their a documented way to "clean up" the state of the nova database in such
> situations? It seems like a bug that the database could get into this state.
>
> Also, it seems that deleted instances are never removed from the database.
> Is that a bug?
>
>  -David
>
> ______________________________**_________________
> Mailing list: https://launchpad.net/~**openstack<https://launchpad.net/~openstack>
> Post to     : openstack@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~**openstack<https://launchpad.net/~openstack>
> More help   : https://help.launchpad.net/**ListHelp<https://help.launchpad.net/ListHelp>
>

Follow ups

References