Delete instance in nova

delete_vm_from_db.sh

# The usage quotas for the tenant are updated after deleting or creating a new instance
read -s -p "MySQL Password: " pw
vm_uuid=$1
mysql -D nova -p$pw -e "update instances set deleted='1', vm_state='deleted',deleted_at='now()' where uuid='$vm_uuid' limit 1;"
sleep 1
mysql -D nova -p$pw -e "delete from instance_faults where instance_faults.instance_uuid = '$vm_uuid';"
mysql -D nova -p$pw -e "delete from instance_id_mappings where instance_id_mappings.uuid = '$vm_uuid';"
mysql -D nova -p$pw -e "delete from instance_info_caches where instance_info_caches.instance_uuid = '$vm_uuid';"
mysql -D nova -p$pw -e "delete from instance_system_metadata where instance_system_metadata.instance_uuid = '$vm_uuid';"
mysql -D nova -p$pw -e "delete from security_group_instance_association where security_group_instance_association.instance_uuid = '$vm_uuid';"
mysql -D nova -p$pw -e "delete from block_device_mapping where block_device_mapping.instance_uuid = '$vm_uuid';"
mysql -D nova -p$pw -e "delete from fixed_ips where fixed_ips.instance_uuid = '$vm_uuid';"
mysql -D nova -p$pw -e "delete from instance_actions_events where instance_actions_events.action_id in (select id from instance_actions where instance_actions.instance_uuid = '$vm_uuid');"
mysql -D nova -p$pw -e "delete from instance_actions where instance_actions.instance_uuid = '$vm_uuid';"
mysql -D nova -p$pw -e "delete from virtual_interfaces where virtual_interfaces.instance_uuid = '$vm_uuid';"
mysql -D nova -p$pw -e "delete from instances where instances.uuid = '$vm_uuid';"