ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails

在数据库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)