从数据库删除僵尸卷

mysql  -uxxx -pxxx -hxxxx  <<EOF
use cinder
delete from volume_admin_metadata where volume_id ='$1';
delete from volume_attachment where volume_id = '$1';
delete from volume_metadata where volume_id = '$1';
delete from volume_glance_metadata where volume_id = '$1';
delete from snapshots where volume_id='$1';
delete from volumes where id ='$1';

EOF

 

说明：从数据库删除命令行里删不掉的卷；使用方法 #bash 脚本名 卷id ；

标红的xxx需要修改为使用环境中相应的参数；