+---------------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------------+--------------+------+-----+---------+-------+
| created_at | datetime | YES | | NULL | |
| updated_at | datetime | YES | | NULL | |
| deleted_at | datetime | YES | | NULL | |
| deleted | tinyint(1) | YES | | NULL | |
| id | varchar(36) | NO | PRI | NULL | |
| volume_id | varchar(36) | NO | MUL | NULL | |
| attached_host | varchar(255) | YES | | NULL | |
| instance_uuid | varchar(36) | YES | | NULL | |
| mountpoint | varchar(255) | YES | | NULL | |
| attach_time | datetime | YES | | NULL | |
| detach_time | datetime | YES | | NULL | |
| attach_mode | varchar(36) | YES | | NULL | |
| attach_status | varchar(255) | YES | | NULL | |
+---------------+--------------+------+-----+---------+-------
인스턴스(9ac9edf0-0f2a-4214-8a71-e6e52e426704) cinder volume attach 상태
MariaDB [cinder]> select * from volume_attachment where instance_uuid='9ac9edf0-0f2a-4214-8a71-e6e52e426704';
+---------------------+---------------------+---------------------+---------+--------------------------------------+--------------------------------------+---------------+--------------------------------------+------------+---------------------+---------------------+-------------+---------------+
| created_at | updated_at | deleted_at | deleted | id | volume_id | attached_host | instance_uuid | mountpoint | attach_time | detach_time | attach_mode | attach_status |
+---------------------+---------------------+---------------------+---------+--------------------------------------+--------------------------------------+---------------+--------------------------------------+------------+---------------------+---------------------+-------------+---------------+
| 2015-10-15 05:24:00 | 2015-10-15 05:24:00 | NULL | 0 | 1b25c119-4696-4249-8455-e305c8436c08 | 36c1a2da-a5cb-4c79-bd1a-85aa0a4fd5da | NULL | 9ac9edf0-0f2a-4214-8a71-e6e52e426704 | /dev/vdb | 2015-10-15 05:24:00 | NULL | rw | attached |
| 2015-10-15 04:37:51 | 2015-10-15 05:15:53 | 2015-10-15 05:15:53 | 1 | 7a22812b-693d-41d5-a129-b1f979cfbcdc | 36c1a2da-a5cb-4c79-bd1a-85aa0a4fd5da | NULL | 9ac9edf0-0f2a-4214-8a71-e6e52e426704 | /dev/vdb | 2015-10-15 04:37:51 | 2015-10-15 05:15:53 | rw | detached |
+---------------------+---------------------+---------------------+---------+--------------------------------------+--------------------------------------+---------------+--------------------------------------+------------+---------------------+---------------------+-------------+---------------+
인스턴스(9ac9edf0-0f2a-4214-8a71-e6e52e426704) cinder volume detach 상태
+---------------------+---------------------+---------------------+---------+--------------------------------------+--------------------------------------+---------------+--------------------------------------+------------+---------------------+---------------------+-------------+---------------+
| created_at | updated_at | deleted_at | deleted | id | volume_id | attached_host | instance_uuid | mountpoint | attach_time | detach_time | attach_mode | attach_status |
+---------------------+---------------------+---------------------+---------+--------------------------------------+--------------------------------------+---------------+--------------------------------------+------------+---------------------+---------------------+-------------+---------------+
| 2015-10-15 05:24:00 | 2015-10-15 05:25:35 | 2015-10-15 05:25:35 | 1 | 1b25c119-4696-4249-8455-e305c8436c08 | 36c1a2da-a5cb-4c79-bd1a-85aa0a4fd5da | NULL | 9ac9edf0-0f2a-4214-8a71-e6e52e426704 | /dev/vdb | 2015-10-15 05:24:00 | 2015-10-15 05:25:35 | rw | detached |
| 2015-10-15 04:37:51 | 2015-10-15 05:15:53 | 2015-10-15 05:15:53 | 1 | 7a22812b-693d-41d5-a129-b1f979cfbcdc | 36c1a2da-a5cb-4c79-bd1a-85aa0a4fd5da | NULL | 9ac9edf0-0f2a-4214-8a71-e6e52e426704 | /dev/vdb | 2015-10-15 04:37:51 | 2015-10-15 05:15:53 | rw | detached |
+---------------------+---------------------+---------------------+---------+--------------------------------------+--------------------------------------+---------------+--------------------------------------+------------+---------------------+---------------------+-------------+---------------+
