발생) volume이 물려있는 상태에서 인스턴스를 삭제
해결) volume status 를 강제로 available 로 변경후 volume-detach
mysql> select id,status,attach_status from volumes where status='in-use';
+--------------------------------------+--------+---------------+
| id | status | attach_status |
+--------------------------------------+--------+---------------+
| 7b90a7a4-8395-4000-96cd-af818589755a | in-use | attached |
| d0835d81-bffb-42f4-bb50-56473f8bbce7 | in-use | attached |
+--------------------------------------+--------+---------------+
2 rows in set (0.00 sec)
mysql> update volumes set status='available', attach_status='detached' where status='in-use';
Query OK, 2 rows affected (0.05 sec)
Rows matched: 2 Changed: 2 Warnings: 0
# nova volume-detach <server> <volume>
참고 URL
방법2)
mysql> update volumes set attach_status='detached', status='available' where id='c43a0c3b-b3cf-4a4b-9b85-12726c3defc1';
Query OK, 1 row affected (0.06 sec)
Rows matched: 1 Changed: 1 Warnings: 0
