remove_stuck_vm.bash

#!/bin/bash

echo "Enter your MySQL user"
read MYSQL_USER

echo "Enter your MySQL user password"
read MYSQL_PASSWD

echo "Enter your Nova VM ID"
read VM_ID

MYSQL_HOST=localhost

mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_faults where instance_faults.instance_uuid = '$VM_ID';"
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_extra where instance_extra.instance_uuid = '$VM_ID';"
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_metadata where instance_metadata.instance_uuid = '$VM_ID';"
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_id_mappings where instance_id_mappings.uuid = '$VM_ID';"
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_info_caches where instance_info_caches.instance_uuid = '$VM_ID';"
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_system_metadata where instance_system_metadata.instance_uuid = '$VM_ID';"
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from security_group_instance_association where security_group_instance_association.instance_uuid = '$VM_ID';"
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from block_device_mapping where block_device_mapping.instance_uuid = '$VM_ID';"
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from fixed_ips where fixed_ips.instance_uuid = '$VM_ID';"
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_actions_events where instance_actions_events.action_id in (select id from instance_actions where instance_actions.instance_uuid = '$VM_ID');"
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instance_actions where instance_actions.instance_uuid = '$VM_ID';"
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from virtual_interfaces where virtual_interfaces.instance_uuid = '$VM_ID';"
mysql -u$MYSQL_USER -p$MYSQL_PASSWD -h$MYSQL_HOST -e "USE nova; delete from instances where instances.uuid = '$VM_ID';"