在数据库nova的instances表中删除虚机时失败:
delete from instances where vm_state='deleted';
报错:
ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (nova
.block_device_mapping
, CONSTRAINT block_device_mapping_instance_uuid_fkey
FOREIGN KEY (instance_uuid
) REFERENCES instances
(uuid
))
解决办法:
SET foreign_key_checks = 0; // 先设置外键约束检查关闭
delete from instances where vm_state='deleted'; //删除状态为deleted的虚机
SET foreign_key_checks = 1; // 开启外键约束检查,以保持表结构完整性
删除成功:
MariaDB [nova]> delete from instances where vm_state='deleted';
Query OK, 94 rows affected (0.02 sec)