圣诞快乐——向Google致敬——向linux致敬——向stackoverflow致敬——向openStack 致敬——永不退缩

浏览数：51 / 时间：2015年06月20日

Openstack can not delete instance from dashboard

There are 66 instances in Openstack Havana. I think these instances are zombies instance. Dashboard displays Terminate Success info when I click Terminate Instance. But the instance still exists on dashboard and its status is Running. I have already kill all qemu-kvm program on server.

In Mysql, database nova remains a lot of data. I don‘t know where to start to delete these data. Could someone give me some advice ?? Thanks a lot.

asked Mar 5 at 10:25

changzhi
307217

add a comment

2 Answers

active oldest votes

up vote 2 down vote accepted

I did this in the Icehouse release of OpenStack, maybe you can map this to the Havana release:

log into the database (you should see > mysql in your console)
select the nova database:

use nova;
mark the rows in table instances as deleted (that‘s a "soft-delete")

update instances set deleted_at = updated_at, deleted = id, power_state = 0, vm_state = "deleted", terminated_at = updated_at, root_device_name = NULL, task_state = NULL where deleted = 0;

<-- That ‘deletes‘ ALL your instances! Use show columns from instances; if you want to choose another column(s) for your where-clause.
update the cache in table instance_info_chaches appropriately

update instance_info_caches set deleted_at = updated_at, deleted = id where deleted = 0;
update the fixed_ips table:

update fixed_ips set instance_id = NULL, allocated = 0, virtual_interface_id = NULL where deleted = 0;

Note: If the column deleted contains a value not equal to zero, then this seems to be the way to say this row is supposed to be deleted. When I delete an instance via API, OpenStack seems to choose the id as value for deleted.

Source: http://www.databaseskill.com/4605135/

郑重声明：本站内容如果来自互联网及其他传播媒体，其版权均属原媒体及文章作者所有。转载目的在于传递更多信息及用于网络分享，并不代表本站赞同其观点和对其真实性负责，也不构成任何其他建议。

圣诞快乐——向Google致敬——向linux致敬——向stackoverflow致敬——向openStack 致敬——永不退缩