Openstack清除错误实例（Error Instance）

由于neutron或nova的问题，在创建instance的时候会出现一些创建报error的实例，但普通方法又删不掉，这时候就要去mysql数据库里去删。

通常创建的记录还没写到nova数据库中，但通常会写到nova-api，nova-cell0数据库中。因此只能在这数据库中删除。

NOVA-api:

#mysql -u root -p

MariaDB [(none)]> use nova_api
MariaDB [nova_api]> select * from instance_mappings;
MariaDB [nova_api]> select id from instance_mappings;
+----+
| id |
+----+
|  6 |
|  7 |
|  8 |
|  9 |
| 10 |
+----+
5 rows in set (0.000 sec)

MariaDB [nova_api]> delete from instance_mappings where id=6;
Query OK, 1 row affected (0.011 sec)

MariaDB [nova_api]> delete from instance_mappings where id=7
    -> ;
Query OK, 1 row affected (0.032 sec)

MariaDB [nova_api]> delete from instance_mappings where id=8
    -> ;
Query OK, 1 row affected (0.005 sec)

MariaDB [nova_api]> delete from instance_mappings where id=9;
Query OK, 1 row affected (0.019 sec)

MariaDB [nova_api]> delete from instance_mappings where id=10;
Query OK, 1 row affected (0.009 sec)

NOVA-cell0:
MariaDB [nova_api]> use nova_cell0;

Database changed

MariaDB [nova_cell0]> show tables;

MariaDB [nova_cell0]> SET Foreign_key_checks=1;

MariaDB [nova_api]> select id from instances;
（删除略，和上面语句一样）

MariaDB [nova_cell0]> show tables;
MariaDB [nova_cell0]> SET Foreign_key_checks=0;
Query OK, 0 rows affected (0.000 sec)

MariaDB [nova_cell0]> exit