OpenStack+Ceph集群 手动删除错误实例

简述一下之前的操作：
我创建了一个minIO的虚机，使用warp对其进行测试
测试使发现minIO虚机容量过小，于是对该虚机进行了resize扩容
扩容时没考虑osd空间不足，导致运行时虚机宕机了，连接不上虚机
于是我扩容了osd，将原存数据的osd删除，添加了更大空间的osd
但扩容时没有删除pool池，导致还遗留有原osd数据的信息，导致ceph瘫痪
重建pool池后，ceph正常，但minIO虚机找不到原存放的数据，导致出现状态错误
于是对其执行删除实例操作，但一天过去，仍然没有删除，提示删除中
故现在来手动操作数据库进行删除
下文参考http://t.zoukankan.com/IvanChen-p-4489407.html编写

先查看实例记录实例的UUID

nova list

[root@controller ~(keystone)]# nova list
+--------------------------------------+-----------+--------+------------+-------------+----------+
| ID                                   | Name      | Status | Task State | Power State | Networks |
+--------------------------------------+-----------+--------+------------+-------------+----------+
| eef4803b-d06d-4130-b28f-4180de957aa9 | minioHost | ERROR  | deleting   | Running     |          |
+--------------------------------------+-----------+--------+------------+-------------+----------+

eef4803b-d06d-4130-b28f-4180de957aa9就是我们要删除的实例的uuid

进入mysql

mysql

查看一下数据库

show databases;

nova数据库是存放我们实例信息的地方

use nova;
show tables;

查看nova的tables

+--------------------------------------------+
| Tables_in_nova                             |
+--------------------------------------------+
| agent_builds                               |
| aggregate_hosts                            |
| aggregate_metadata                         |
| aggregates                                 |
| allocations                                |
| block_device_mapping                       |
| bw_usage_cache                             |
| cells                                      |
| certificates                               |
| compute_nodes                              |
| console_auth_tokens                        |
| console_pools                              |
| consoles                                   |
| dns_domains                                |
| fixed_ips                                  |
| floating_ips                               |
| instance_actions                           |
| instance_actions_events                    |
| instance_extra                             |
| instance_faults                            |
| instance_group_member                      |
| instance_group_policy                      |
| instance_groups                            |
| instance_id_mappings                       |
| instance_info_caches                       |
| instance_metadata                          |
| instance_system_metadata                   |
| instance_type_extra_specs                  |
| instance_type_projects                     |
| instance_types                             |
| instances                                  |
| inventories                                |
| key_pairs                                  |
| migrate_version                            |
| migrations                                 |
| networks                                   |
| pci_devices                                |
| project_user_quotas                        |
| provider_fw_rules                          |
| quota_classes                              |
| quota_usages                               |
| quotas                                     |
| reservations                               |
| resource_provider_aggregates               |
| resource_providers                         |
| s3_images                                  |
| security_group_default_rules               |
| security_group_instance_association        |
| security_group_rules                       |
| security_groups                            |
| services                                   |
| shadow_agent_builds                        |
| shadow_aggregate_hosts                     |
| shadow_aggregate_metadata                  |
| shadow_aggregates                          |
| shadow_block_device_mapping                |
| shadow_bw_usage_cache                      |
| shadow_cells                               |
| shadow_certificates                        |
| shadow_compute_nodes                       |
| shadow_console_pools                       |
| shadow_consoles                            |
| shadow_dns_domains                         |
| shadow_fixed_ips                           |
| shadow_floating_ips                        |
| shadow_instance_actions                    |
| shadow_instance_actions_events             |
| shadow_instance_extra                      |
| shadow_instance_faults                     |
| shadow_instance_group_member               |
| shadow_instance_group_policy               |
| shadow_instance_groups                     |
| shadow_instance_id_mappings                |
| shadow_instance_info_caches                |
| shadow_instance_metadata                   |
| shadow_instance_system_metadata            |
| shadow_instance_type_extra_specs           |
| shadow_instance_type_projects              |
| shadow_instance_types                      |
| shadow_instances                           |
| shadow_key_pairs                           |
| shadow_migrate_version                     |
| shadow_migrations                          |
| shadow_networks                            |
| shadow_pci_devices                         |
| shadow_project_user_quotas                 |
| shadow_provider_fw_rules                   |
| shadow_quota_classes                       |
| shadow_quota_usages                        |
| shadow_quotas                              |
| shadow_reservations                        |
| shadow_s3_images                           |
| shadow_security_group_default_rules        |
| shadow_security_group_instance_association |
| shadow_security_group_rules                |
| shadow_security_groups                     |
| shadow_services                            |
| shadow_snapshot_id_mappings                |
| shadow_snapshots                           |
| shadow_task_log                            |
| shadow_virtual_interfaces                  |
| shadow_volume_id_mappings                  |
| shadow_volume_usage_cache                  |
| snapshot_id_mappings                       |
| snapshots                                  |
| tags                                       |
| task_log                                   |
| virtual_interfaces                         |
| volume_id_mappings                         |
| volume_usage_cache                         |
+--------------------------------------------+
110 rows in set (0.001 sec)

instance_info_caches与实例的网络设置缓存有关
instances 是实例的主表

删除instances 主表的记录

update instances set deleted_at = updated_at, deleted = 1, power_state = 0, vm_state = "deleted",  terminated_at = updated_at,  root_device_name = NULL,  task_state = NULL where uuid = 'eef4803b-d06d-4130-b28f-4180de957aa9';  

现在在网页上可以发现已经看不到这个实例了

剩下的就是删除网络相关的配置信息

update instance_info_caches set deleted_at = updated_at, deleted = 1  where instance_uuid = 'eef4803b-d06d-4130-b28f-4180de957aa9';