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 _______________________________________________ Mailing list: http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack Post to : [email protected] Unsubscribe : http://lists.openstack.org/cgi-bin/mailman/listinfo/openstack
