找回密码
 注册
查看: 2345|回复: 1

删除数据库数据报错

[复制链接]

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
发表于 2021-5-19 15:00:06 | 显示全部楼层 |阅读模式
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`))

1

主题

0

回帖

12

积分

管理员

积分
12
QQ
 楼主| 发表于 2021-5-19 15:13:17 | 显示全部楼层
delete from `cinder`.`snapshots` where `id`='5ca0b248-ac38-4d82-98c4-d12c4d940906'1 ]  D% l/ h) B/ ^" ]" t
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`))+ {7 Q( w3 ]2 `3 s% }: A0 p
! ?8 c. p6 ~( q* M
在这个表中volume_glance_metadata查找snapshot_id=5ca0b248-ac38-4d82-98c4-d12c4d940906
, Q. k. U) ~. {, q6 m6 ]
# c/ K7 k9 }4 n
您需要登录后才可以回帖 登录 | 注册

本版积分规则

返回首页|Archiver|手机版|小黑屋|易陆发现技术论坛 ( 蜀ICP备2026014127号-1 )

GMT+8, 2026-6-12 03:27 , Processed in 0.017483 second(s), 22 queries .

Powered by Discuz! X5.0

© 2001-2026 Discuz! Team.

快速回复 返回顶部 返回列表