删除数据库数据报错

admin

ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (`cinder`.`volume_glance_metadata`, CONSTRAINT `volume_glance_metadata_ibfk_2` FOREIGN KEY (`snapshot_id`) REFERENCES `snapshots` (`id`))

admin

delete from `cinder`.`snapshots` where `id`='5ca0b248-ac38-4d82-98c4-d12c4d940906'
Cannot delete or update a parent row: a foreign key constraint fails (`cinder`.`volume_glance_metadata`, CONSTRAINT `volume_glance_metadata_ibfk_2` FOREIGN KEY (`snapshot_id`) REFERENCES `snapshots` (`id`))

! S$ k2 D6 b! p6 a) U$ h在这个表中volume_glance_metadata查找snapshot_id=5ca0b248-ac38-4d82-98c4-d12c4d940906
0 a  L* B6 b* g& J- ^+ l