刷新数据库总是报错：不能增加或者更新约束， Cannot add or update a child row: a foreign key constraint fails

关注

原创最新推荐文章于 2026-08-26 16:36:49 发布 5.5k 阅读 AI 写同款· GEO 优化 ›

Ubuntu云服务器上用MySQL/MariaDB命令行创建生产级数据表 CREATE TABLE是关系型数据库最基础也最关键的SQL操作，其本质是定义数据契约——通过字段类型、约束条件与索引策略，明确数据的结构、完整性与访问效率。理解VARCHAR与TEXT的存储差异、NOT NULL与DEFAULT的业务语义边界、AUTO_INCREMENT与UUID在分布式场景下的取舍，直接决定表能否支撑高并发、多地域、长生命周期的现代应用。在Ubuntu系统中，借助apt原生支持的MySQL或MariaDB服务，配合命令行脚本化建表，可实现环境一致、可复现、易运维的数据库初始化流程。本文阅读详情

$2.run(QueuedThreadPool.java:590)
	at java.lang.Thread.run(Unknown Source)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
 Cannot add or update a child row: a foreign key constraint fails (`manager2`.`#sql-7d0_26`, CONSTRAINT `FKgg6g1h63qg29is5ypae70elgt` FOREIGN KEY (`model_id`) REFERENCES `saas_model` (`id`))
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)

这是因为数据冗余造成不能正常更行数据，删去这些数据就行了，认真看报错信息，给的提示也挺完整的，比如：

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLIntegrityConstraintViolationException:
 Cannot add or update a child row: a foreign key constraint fails 
(`manager2`.`#sql-7d0_21`, CONSTRAINT `FK47i0hrv2j92ffjagi98vf3si9` FOREIGN KEY (`parent_id`) REFERENCES `saas_element` (`id`))
	at

就是table saas_element 中id 和parent_id 冲突，具体是，parent_id ,已经删去，但是仍然存在parent为xxx的数据；

select * from saas_element a where a.parent_id not in (select id from saas_element )

-----------------over--------------

下面是我自己的删除数据

select * from saas_element a where a.parent_id not in  (select id from saas_element )  
父id 不在id中；即有父但是父已经不存在的，所有数据
select * from saas_modelfield a where a.model_id not in  (select id from saas_model )  
在 modelfield 表中，查model_id 已经不存在但是还有数据的这些信息

select * from saas_taglibimport a where a.layout_id not in  (select id from saas_layout a where a.model_id not in  (select id from saas_model )  )  
layout_element
select * from saas_layout_element a where a.Layout_id not in  (select id from saas_layout a where a.model_id not in  (select id from saas_model )  )  
delet table ,tagcatagroy,tagimport 

select * from saas_layout a where a.model_id not in  (select id from saas_model )  

select * from saas_taginfoproperty a where a.taginfo_id not in  (select id from saas_taginfo )  
select * from saas_layout a where a.prevVersion_id not in  (select id from saas_Layout )  
//remove taglibimport retrain of layout
select * from saas_layout a where a.model_id not in  (select id from saas_model )
select * from saas_layout a where a.prevVersion_id not in  (select id from saas_Layout )

//menu ,pageid

select * from saas_page a where a.layout_id not in  (select id from saas_layout )  
//删去能删的数据剩下page Id 88;in saas_menu 
select * from saas_page a where a.layout_id not in  (select id from saas_layout )

select * from saas_layout_element a where a.layout_id not in  (select id from saas_layout )

//menu_page page,
select * from saas_menu_page a where a.relevantPages_id not in  (select id from saas_page )
//e
select * from saas_taglibimport a where a.layout_id not in  (select id from saas_layout )  

http://blog.youkuaiyun.com/flymoringbird/article/details/52468966
select * from INFORMATION_SCHEMA.KEY_COLUMN_USAGE //这个是查询出所有的主键和外键

收录于