Open Stack

Hi, all,

I have a zombie vm in openstack Icehouse.

I have removed it from QEMU-KVM with command, virsh. How do remove it
from keystone database?

I find a SQL by google, but it don't work for me? Please help. Thanks.


Invalid SQL:
Error message: ERROR 1054 (42S22) at line 2: Unknown column
'a.instance_id' in 'on clause'


# remove vm from keystone db
mysql -uroot -p$DB_ROOT_PASS << EOF
use nova;
DELETE a FROM nova.security_group_instance_association AS a INNER JOIN
nova.instances AS b ON a.instance_id=b.id where b.uuid='$vm_uuid';
DELETE FROM nova.instance_info_caches WHERE instance_id='$vm_uuid';
DELETE FROM nova.instances WHERE uuid='$vm_uuid';
EOF




-- 
Best regards

Yugang LIU

Keep It Simple, Stupid