一、该问题的重现步骤是什么?
1. 暂时不知道是哪个功能 产生的 报错日志
2.
3.
二、你期待的结果是什么?实际看到的又是什么?
三、你正在使用的是什么产品,什么版本?在什么操作系统上?
四、请提供详细的错误堆栈信息,这很重要。
============= Sql Start ============== Execute SQL : insert into ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_ , EXECUTION_ID_, TASK_ID_, SCOPE_ID_, SUB_SCOPE_ID_, SCOPE_TYPE_ , BYTEARRAY_ID_, DOUBLE_, LONG_, TEXT_, TEXT2_ , META_INFO_) values ('acb43f22-ef5f-11ef-a103-fc3497a56c03', 1, 'string', 'wf_notice', '88293c20-ef5f-11ef-a103-fc3497a56c03' , '88293c31-ef5f-11ef-a103-fc3497a56c03', '8841f460-ef5f-11ef-a103-fc3497a56c03', null, null, null , null, null, null, '1', null , null) Execute Time: 0ms ============== Sql End ============== 2025-02-20 15:52:47.048 ERROR 20432 --- [ync-scheduler86] o.f.c.e.impl.interceptor.CommandContext : Error while closing command context org.apache.ibatis.exceptions.PersistenceException: ### Error updating database. Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`qm_application_platform_test`.`ACT_RU_VARIABLE`, CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`id_`)) ### The error may exist in org/flowable/variable/service/db/mapping/entity/VariableInstance.xml ### The error may involve org.flowable.variable.service.impl.persistence.entity.VariableInstanceEntityImpl.insertVariableInstance-Inline ### The error occurred while setting parameters ### SQL: insert into ACT_RU_VARIABLE (ID_, REV_, TYPE_, NAME_, PROC_INST_ID_, EXECUTION_ID_, TASK_ID_, SCOPE_ID_, SUB_SCOPE_ID_, SCOPE_TYPE_, BYTEARRAY_ID_, DOUBLE_, LONG_ , TEXT_, TEXT2_, META_INFO_) values ( ?, 1, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ### Cause: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`qm_application_platform_test`.`ACT_RU_VARIABLE`, CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`id_`)) at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:199) at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:184) at org.flowable.common.engine.impl.db.DbSqlSession.flushRegularInsert(DbSqlSession.java:519) at org.flowable.common.engine.impl.db.DbSqlSession.flushInsertEntities(DbSqlSession.java:500) at org.flowable.common.engine.impl.db.DbSqlSession.flushInserts(DbSqlSession.java:483) at org.flowable.common.engine.impl.db.DbSqlSession.flush(DbSqlSession.java:368) at org.flowable.common.engine.impl.interceptor.CommandContext.flushSessions(CommandContext.java:218) at org.flowable.common.engine.impl.interceptor.CommandContext.close(CommandContext.java:76) at org.flowable.common.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:114) at org.flowable.common.spring.SpringTransactionInterceptor.lambda$execute$0(SpringTransactionInterceptor.java:57) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:140) at org.flowable.common.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:57) at org.flowable.common.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:30) at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:56) at org.flowable.common.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:51) at org.flowable.engine.impl.TaskServiceImpl.setVariableLocal(TaskServiceImpl.java:436) at org.springblade.plugin.workflow.process.service.impl.WfNoticeServiceImpl.handleCompleteTask(WfNoticeServiceImpl.java:317) at org.springblade.plugin.workflow.process.service.impl.WfNoticeServiceImpl.resolveNoticeInfo(WfNoticeServiceImpl.java:268) at jdk.internal.reflect.GeneratedMethodAccessor1208.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:351) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:196) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:765) at org.springframework.aop.aspectj.MethodInvocationProceedingJoinPoint.proceed(MethodInvocationProceedingJoinPoint.java:89) at org.springblade.core.log.aspect.LogTraceAspect.around(LogTraceAspect.java:50) at jdk.internal.reflect.GeneratedMethodAccessor476.invoke(Unknown Source) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:568) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethodWithGivenArgs(AbstractAspectJAdvice.java:637) at org.springframework.aop.aspectj.AbstractAspectJAdvice.invokeAdviceMethod(AbstractAspectJAdvice.java:627) at org.springframework.aop.aspectj.AspectJAroundAdvice.invoke(AspectJAroundAdvice.java:71) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:173) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:765) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:184) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:765) at org.springframework.aop.interceptor.AsyncExecutionInterceptor.lambda$invoke$0(AsyncExecutionInterceptor.java:113) at java.base/java.util.concurrent.FutureTask.run$$$capture(FutureTask.java:264) at java.base/java.util.concurrent.FutureTask.run(FutureTask.java) at org.springblade.core.context.BladeRunnableWrapper.run(BladeRunnableWrapper.java:63) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) at java.base/java.lang.Thread.run(Thread.java:833) Caused by: java.sql.SQLIntegrityConstraintViolationException: Cannot add or update a child row: a foreign key constraint fails (`qm_application_platform_test`.`ACT_RU_VARIABLE`, CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`id_`)) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:118) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) at com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:912) at com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3462) at com.alibaba.druid.filter.FilterEventAdapter.preparedStatement_execute(FilterEventAdapter.java:434) at com.alibaba.druid.filter.FilterChainImpl.preparedStatement_execute(FilterChainImpl.java:3460) at com.alibaba.druid.proxy.jdbc.PreparedStatementProxyImpl.execute(PreparedStatementProxyImpl.java:158) at com.alibaba.druid.pool.DruidPooledPreparedStatement.execute(DruidPooledPreparedStatement.java:483) at org.apache.ibatis.executor.statement.PreparedStatementHandler.update(PreparedStatementHandler.java:48) at org.apache.ibatis.executor.statement.RoutingStatementHandler.update(RoutingStatementHandler.java:75) at org.apache.ibatis.executor.SimpleExecutor.doUpdate(SimpleExecutor.java:50) at org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:117) at org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:76) at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:197) ... 44 common frames omitted
五、若有更多详细信息,请在下面提供。
-
从错误日志来看,问题出在 SQL 插入操作时违反了外键约束。这种错误通常发生在尝试将数据插入到 ACT_RU_VARIABLE 表时,其中 EXECUTION_ID_ 字段的值没有在 ACT_RU_EXECUTION 表中找到对应的记录。
具体的错误是: Cannot add or update a child row: a foreign key constraint fails (`qm_application_platform_test`.`ACT_RU_VARIABLE`, CONSTRAINT `ACT_FK_VAR_EXE` FOREIGN KEY (`EXECUTION_ID_`) REFERENCES `ACT_RU_EXECUTION` (`id_`))
说明 ACT_RU_VARIABLE 表的 EXECUTION_ID_ 字段需要引用 ACT_RU_EXECUTION 表中的 id_ 字段,但当前的 EXECUTION_ID_ 值 (88293c31-ef5f-11ef-a103-fc3497a56c03) 在 ACT_RU_EXECUTION 表中找不到。
具体怎么触发的,还得你多关注下,有了重现步骤我们才好进行判断
讨论(0)
官方新品
- 热议问题
-
物联网APP登录接口在后端提示404, 前端提示跨域问题
1
-
代码生成主子表,查询子表报错了,想问下啥原因哦,sql放数据库执行没报错,用的db2数据库
1
-
swagger文档本地调试,获取token接口请求参数问题
1
-
使用PostgreSQL数据库,执行下列代码时报错
1
-
minio设置的是private的,blade现在能支持直接返回配置的外网Ip吗?
2
-
AVUE中配置可展开表格+复选框 Avue升级后3.6.3版本复选框无法显示
1
-
BladeX4.5.0引入MapStructPlus失败
1
-
mapper中的page和list两个方法,如果配置同一种数据权限。
1
-
方法中引入 MinioTemplate 问题
1
-
想问一下如果觉得本地服务启动的太多了 修改什么配置能让调用服务走服务器上部署的基础服务呢
1
扫一扫访问 Blade技术社区 移动端