openstack中volume状态为error，不能被附加不能进行其他操作的解决方法

运行一些增加卷的命令到实例中去，会报错，说volume的状态是error，不能操作。

我们首先进入mysql数据库，选择cinder数据库，更改表volume。操作如下：

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]> show tables;
| volume_types               |
| volumes                    |
| workers                    |
+----------------------------+
35 rows in set (0.00 sec)

更新volumes表

MariaDB [cinder]> UPDATE volumes SET status= 'available' WHERE status = 'error';
Query OK, 3 rows affected (0.01 sec)
Rows matched: 3  Changed: 3  Warnings: 0

 查看卷的状态，变成available了。

[root@controller ~]# openstack volume list
+--------------------------------------+-----------------+-----------+------+--------------------------------------+
| ID                                   | Name            | Status    | Size | Attached to                          |
+--------------------------------------+-----------------+-----------+------+--------------------------------------+
| 38119d26-3411-4589-8fec-d488b4a94553 | test-volume-try | available |   10 |                                      |
| 7a49690f-ef09-496d-ac2c-16a5fc344fd8 | test-volume     | available |   10 |                                      |
| 906ff027-3fe1-4d6e-a0f0-aeaaa4b46985 | test-volume     | in-use    |    8 | Attached to test-server on /dev/vdb  |
| 637d9ff4-b190-4a67-8af2-97e61bcbacb7 | my-new-volume   | available |    8 |                                      |
+--------------------------------------+-----------------+-----------+------+--------------------------------------+

接着进行其他的操作，就可以完成了。

[root@controller ~]# openstack server list
+--------------------------------------+----------------+---------+-----------------------+--------+---------+
| ID                                   | Name           | Status  | Networks              | Image  | Flavor  |
+--------------------------------------+----------------+---------+-----------------------+--------+---------+
| e4351931-b3ce-45b1-abe4-b093e1e58671 | weinihao       | SHUTOFF | public=172.16.175.102 | cirros | m1.tiny |
| 38d4fa76-3eaa-43ad-943b-00912ddbe82b | test-server    | SHUTOFF | public=172.16.175.109 | cirros | m1.tiny |
| 0b2c2aa6-d3a9-4618-8d39-c7ce1d745a02 | test-server    | SHUTOFF | public=172.16.175.105 | cirros | m1.tiny |
| 231a0cf1-b80f-43d2-9f27-82f98e0cd7ea | test-server    | ERROR   |                       | cirros | m1.tiny |
| 70222c6a-eb6b-4327-af37-36b4d071d2d7 | test-server    | ERROR   |                       | cirros | m1.tiny |
| 2c85f074-2ca7-41e5-b814-05191910f8aa | test-server    | ERROR   |                       | cirros | m1.tiny |
| 606dbb92-18a3-49c7-95e7-c0ea1cd584fc | test-server    | ERROR   |                       | cirros | m1.tiny |
| 9906f11e-849e-48e4-84dd-a1d760080751 | test-server    | ERROR   |                       | cirros | m1.tiny |
| cca90771-4c46-45e4-8679-c138c87eb381 | test-server    | ERROR   |                       | cirros | m1.tiny |
| 7d9d38f8-8a55-40df-aa1d-4a2471c90d94 | myCirrosServer | UNKNOWN |                       | cirros | m1.tiny |
+--------------------------------------+----------------+---------+-----------------------+--------+---------+

 格式

Attach the instance to the volume:

$ openstack server add volume
INSTANCE_NAME \
VOLUME_NAME \
--device /dev/vda

运行 

[root@controller ~]# openstack server add volume weinihao test-volume-try --device /dev/vdb
[root@controller ~]#