아래 링크에 의해 발생된 에러로 인해 cinder status 가 attaching 에서 진행이 안되는 상황
http://chonnom.com/bbs/board.php?bo_table=OpenStack&wr_id=365

MariaDB [(none)]> use cinder;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
MariaDB [cinder]> select * from volumes where id='7243daaa-4e72-4071-9909-7357bcb373ed';
+---------------------+---------------------+------------+---------+--------------------------------------+--------+----------------------------------+----------------------------------+-------------------+------+-------------------+-----------+---------------+---------------------+---------------------+---------------+--------------+---------------------+-------------------+---------------+-------------+----------------+--------------+----------+-------------------+----------+-------------------+------------------+--------------------+-----------------------------+-------------------------+---------------------+-------------+-------------+-----------------+
| created_at          | updated_at          | deleted_at | deleted | id                                   | ec2_id | user_id                          | project_id                       | host              | size | availability_zone | status    | attach_status | scheduled_at        | launched_at         | terminated_at | display_name | display_description | provider_location | provider_auth | snapshot_id | volume_type_id | source_volid | bootable | provider_geometry | _name_id | encryption_key_id | migration_status | replication_status | replication_extended_status | replication_driver_data | consistencygroup_id | provider_id | multiattach | previous_status |
+---------------------+---------------------+------------+---------+--------------------------------------+--------+----------------------------------+----------------------------------+-------------------+------+-------------------+-----------+---------------+---------------------+---------------------+---------------+--------------+---------------------+-------------------+---------------+-------------+----------------+--------------+----------+-------------------+----------+-------------------+------------------+--------------------+-----------------------------+-------------------------+---------------------+-------------+-------------+-----------------+
| 2016-08-22 13:05:03 | 2016-08-23 01:03:55 | NULL       |       0 | 7243daaa-4e72-4071-9909-7357bcb373ed | NULL   | c76b97bc7f294a7bac60e95229e45e53 | cf240e77532746c0aada67098ddb58e0 | cl-201-56@lvm#LVM |   12 | nova              | available | attached      | 2016-08-22 13:05:03 | 2016-08-22 13:05:04 | NULL          | akanaka_217  | NULL                | NULL              | NULL          | NULL        | NULL           | NULL         |        0 | NULL              | NULL     | NULL              | NULL             | disabled           | NULL                        | NULL                    | NULL                | NULL        |           0 | NULL            |
+---------------------+---------------------+------------+---------+--------------------------------------+--------+----------------------------------+----------------------------------+-------------------+------+-------------------+-----------+---------------+---------------------+---------------------+---------------+--------------+---------------------+-------------------+---------------+-------------+----------------+--------------+----------+-------------------+----------+-------------------+------------------+--------------------+-----------------------------+-------------------------+---------------------+-------------+-------------+-----------------+
1 row in set (0.00 sec)

MariaDB [cinder]> update volumes set attach_status='detached',status='available' where id='7243daaa-4e72-4071-9909-7357bcb373ed';
Query OK, 1 row affected (0.01 sec)
Rows matched: 1  Changed: 1  Warnings: 0

root@controller:~# cinder list
+--------------------------------------+-----------+-------------+------+-------------+----------+-------------+
|                  ID                  |   Status  |     Name    | Size | Volume Type | Bootable | Attached to |
+--------------------------------------+-----------+-------------+------+-------------+----------+-------------+
| 7243daaa-4e72-4071-9909-7357bcb373ed | available | akanaka_217 |  12  |      -      |  false   |             |
+--------------------------------------+-----------+-------------+------+-------------+----------+-------------+

root@controller:~# cinder delete 7243daaa-4e72-4071-9909-7357bcb373ed
Request to delete volume 7243daaa-4e72-4071-9909-7357bcb373ed has been accepted.

참고
https://ask.openstack.org/en/question/66918/how-to-delete-volume-with-available-status-and-attached-to/