mysql> 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
mysql> I
    -> ;
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'I' at line 1
mysql> delete from volume_metadata;
Query OK, 4 rows affected (0.04 sec)

mysql> delete from volume_glance_metadata;
Query OK, 0 rows affected (0.00 sec)

mysql> delete from snapshot_metadata;
Query OK, 0 rows affected (0.00 sec)

mysql> delete from volume_admin_metadata;
Query OK, 8 rows affected (0.01 sec)

mysql> delete from transfers;
Query OK, 0 rows affected (0.00 sec)

mysql> delete from snapshots;
Query OK, 0 rows affected (0.00 sec)

mysql> delete from volume_attachment;
Query OK, 4 rows affected (0.02 sec)

mysql> delete from volumes;
Query OK, 12 rows affected (0.06 sec)

mysql> quit
Bye
ubuntu@ubuntu:~$ cinder create 1
+---------------------+--------------------------------------+
|       Property      |                Value                 |
+---------------------+--------------------------------------+
|     attachments     |                  []                  |
|  availability_zone  |                 nova                 |
|       bootable      |                false                 |
|      created_at     |      2015-06-22T15:22:42.747265      |
| display_description |                 None                 |
|     display_name    |                 None                 |
|      encrypted      |                False                 |
|          id         | 2847b1b2-bbf8-4874-a3c9-511e3ffc661d |
|       metadata      |                  {}                  |
|     multiattach     |                false                 |
|         size        |                  1                   |
|     snapshot_id     |                 None                 |
|     source_volid    |                 None                 |
|        status       |               creating               |
|     volume_type     |                 None                 |
+---------------------+--------------------------------------+
ubuntu@ubuntu:~$ cinder list
+--------------------------------------+-----------+--------------+------+-------------+----------+-------------+
|                  ID                  |   Status  | Display Name | Size | Volume Type | Bootable | Attached to |
+--------------------------------------+-----------+--------------+------+-------------+----------+-------------+
| 2847b1b2-bbf8-4874-a3c9-511e3ffc661d | available |      -       |  1   |      -      |  false   |             |
+--------------------------------------+-----------+--------------+------+-------------+----------+-------------+
ubuntu@ubuntu:~$ cinde show 2847b1b2-bbf8-4874-a3c9-511e3ffc661d
No command 'cinde' found, did you mean:
 Command 'cinder' from package 'python-cinderclient' (main)
 Command 'cindex' from package 'codesearch' (universe)
cinde: command not found
ubuntu@ubuntu:~$ cinder show 2847b1b2-bbf8-4874-a3c9-511e3ffc661d
+---------------------------------------+---------------------------------------+
|                Property               |                 Value                 |
+---------------------------------------+---------------------------------------+
|              attachments              |                   []                  |
|           availability_zone           |                  nova                 |
|                bootable               |                 false                 |
|               created_at              |       2015-06-22T15:22:42.000000      |
|          display_description          |                  None                 |
|              display_name             |                  None                 |
|               encrypted               |                 False                 |
|                   id                  |  2847b1b2-bbf8-4874-a3c9-511e3ffc661d |
|                metadata               | {u'type': u'Normal', u'ldev': u'103'} |
|              multiattach              |                 false                 |
|         os-vol-host-attr:host         |          ubuntu@hus110#hus110         |
|     os-vol-mig-status-attr:migstat    |                  None                 |
|     os-vol-mig-status-attr:name_id    |                  None                 |
|      os-vol-tenant-attr:tenant_id     |    f09e3a587762408e94db26143ff68486   |
|   os-volume-replication:driver_data   |                  None                 |
| os-volume-replication:extended_status |                  None                 |
|                  size                 |                   1                   |
|              snapshot_id              |                  None                 |
|              source_volid             |                  None                 |
|                 status                |               available               |
|              volume_type              |                  None                 |
+---------------------------------------+---------------------------------------+
ubuntu@ubuntu:~$ cinder --os-volume-api-version 2 retype 2847b1b2-bbf8-4874-a3c9-511e3ffc661d hnas-nfs --migration-policy on-demand
ubuntu@ubuntu:~$ cinder list
+--------------------------------------+-----------+--------------+------+-------------+----------+-------------+
|                  ID                  |   Status  | Display Name | Size | Volume Type | Bootable | Attached to |
+--------------------------------------+-----------+--------------+------+-------------+----------+-------------+
| 2847b1b2-bbf8-4874-a3c9-511e3ffc661d |  retyping |      -       |  1   |      -      |  false   |             |
| 6d85a17f-403e-43cc-98db-4a40033f4c2c | available |      -       |  1   |   hnas-nfs  |  false   |             |
+--------------------------------------+-----------+--------------+------+-------------+----------+-------------+
ubuntu@ubuntu:~$ cinder list
+--------------------------------------+-----------+--------------+------+-------------+----------+-------------+
|                  ID                  |   Status  | Display Name | Size | Volume Type | Bootable | Attached to |
+--------------------------------------+-----------+--------------+------+-------------+----------+-------------+
| 2847b1b2-bbf8-4874-a3c9-511e3ffc661d | available |      -       |  1   |      -      |  false   |             |
| 6d85a17f-403e-43cc-98db-4a40033f4c2c | available |      -       |  1   |   hnas-nfs  |  false   |             |
+--------------------------------------+-----------+--------------+------+-------------+----------+-------------+