OpenStack虚拟机删除后停在deleting无法正常删除

公司环境中批量删除虚拟机的过程中出现某些虚拟机无法正常删除，任务状态显示删除中但是虚拟无法删除。

通过查询相关文章（下文转载）发现应该是instances row中键值未更新错误导致，但是按照操作云主机数量中内容移除信息但是概况中还是出现该资源被占用的情况。（批量方式待解决）

1.命令行处理方式:（完美解决）

通过rest-state和force-delete后某些报错VM可以清除(测试可行，但是有时候nova delete命令无效，控制台测试可以正常删除)

# nova reset-state --active UUID

# nova force-delete --active UUID

[root@controller1 ~]# nova list

[root@controller1 ~]# nova reset-state 1274d42e-4934-4c8b-96ea-c62adeb0210d
Reset state for server 1274d42e-4934-4c8b-96ea-c62adeb0210d succeeded; new state is error
[root@controller1 ~]# nova list

[root@controller1 ~]# nova reset-state 1274d42e-4934-4c8b-96ea-c62adeb0210d --active
Reset state for server 1274d42e-4934-4c8b-96ea-c62adeb0210d succeeded; new state is active
[root@controller1 ~]# nova list

[root@controller1 ~]# nova delete 1274d42e-4934-4c8b-96ea-c62adeb0210d
Request to delete server 1274d42e-4934-4c8b-96ea-c62adeb0210d has been accepted.
[root@controller1 ~]# nova list

具体的BUG信息请参考:https://review.openstack.org/#/c/294491/ （通常需要删除后重启nova-compute服务才能生效该方法不需要重启服务）

https://community.rackspace.com/products/f/45/t/1478

2.数据库处理方式:（未完全解决，概况中存在资源被占用情况）

MariaDB [nova]> select * from instances\G

*************************** 73. row ***************************
created_at: 2017-08-24 09:49:35
updated_at: 2017-08-25 03:40:45
deleted_at: NULL
id: 174
internal_id: NULL
user_id: 1487af17b9b34850972f451f34394c34
project_id: af087ac33ae2455091db74836d07e1b0
image_ref: e5cf5847-50d0-4584-b77e-0db5479ee7c0
kernel_id:
ramdisk_id:
launch_index: 0
key_name: NULL
key_data: NULL
power_state: 1
vm_state: active
memory_mb: 16384
vcpus: 4
hostname: concar-es01
host: compute1
user_data: NULL
reservation_id: r-b4ya1x14
scheduled_at: NULL
launched_at: 2017-08-24 09:50:46
terminated_at: NULL
display_name: concar-es1
display_description: concar-es01
availability_zone: nova
locked: 0
os_type: NULL
launched_on: compute1
instance_type_id: 57
vm_mode: NULL
uuid: d1027782-6dbe-4bd2-ae02-f69c5632e905
architecture: NULL
root_device_name: /dev/vda
access_ip_v4: NULL
access_ip_v6: NULL
config_drive:
task_state: deleting
default_ephemeral_device: NULL
default_swap_device: NULL
progress: 0
auto_disk_config: 1
shutdown_terminate: 0
disable_terminate: 0
root_gb: 30
ephemeral_gb: 0
cell_name: NULL
node: compute1
deleted: 0
locked_by: NULL
cleaned: 0
ephemeral_key_uuid: NULL

*************************** 74. row ***************************

使用命令进行修改

MariaDB [nova]> update instances set deleted=1 where uuid='d1027782-6dbe-4bd2-ae02-f69c5632e905';

修改后：

*************************** 73. row ***************************
created_at: 2017-08-24 09:49:35
updated_at: 2017-08-25 03:40:45
deleted_at: NULL
id: 174
internal_id: NULL
user_id: 1487af17b9b34850972f451f34394c34
project_id: af087ac33ae2455091db74836d07e1b0
image_ref: e5cf5847-50d0-4584-b77e-0db5479ee7c0
kernel_id:
ramdisk_id:
launch_index: 0
key_name: NULL
key_data: NULL
power_state: 1
vm_state: active
memory_mb: 16384
vcpus: 4
hostname: concar-es01
host: compute1
user_data: NULL
reservation_id: r-b4ya1x14
scheduled_at: NULL
launched_at: 2017-08-24 09:50:46
terminated_at: NULL
display_name: concar-es1
display_description: concar-es01
availability_zone: nova
locked: 0
os_type: NULL
launched_on: compute1
instance_type_id: 57
vm_mode: NULL
uuid: d1027782-6dbe-4bd2-ae02-f69c5632e905
architecture: NULL
root_device_name: /dev/vda
access_ip_v4: NULL
access_ip_v6: NULL
config_drive:
task_state: deleting
default_ephemeral_device: NULL
default_swap_device: NULL
progress: 0
auto_disk_config: 1
shutdown_terminate: 0
disable_terminate: 0
root_gb: 30
ephemeral_gb: 0
cell_name: NULL
node: compute1
deleted: 1
locked_by: NULL
cleaned: 0
ephemeral_key_uuid: NULL