Service被调用两遍,导致乐观锁异常

运行结果及报错内容 :图中的两次begin update sql就是被两个线程调用两遍

HHH000010: On release of batch it still contained JDBC statements,

javax.persistence.OptimisticLockException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: delete from cont_invoice where id=?,
    at org.hibernate.internal.ExceptionConverterImpl.wrapStaleStateException(ExceptionConverterImpl.java:238) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:93) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1406) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1389) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.query.internal.NativeQueryImpl.beforeQuery(NativeQueryImpl.java:268) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.query.internal.AbstractProducedQuery.executeUpdate(AbstractProducedQuery.java:1694) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at com.sinosoft.microservice.contract.management.provider.service.sync.SyncInvoiceExcelService.syncInvoiceExcelToDataTable(SyncInvoiceExcelService.java:410) ~[classes!/:na],
    at com.sinosoft.microservice.contract.management.provider.service.sync.SyncInvoiceExcelService$$FastClassBySpringCGLIB$$77e90dc7.invoke(<generated>) ~[classes!/:na],
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) [spring-core-5.3.14.jar!/:5.3.14],
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:783) ~[spring-aop-5.3.14.jar!/:5.3.14],
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) ~[spring-aop-5.3.14.jar!/:5.3.14],
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753) ~[spring-aop-5.3.14.jar!/:5.3.14],
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:123) ~[spring-tx-5.3.14.jar!/:5.3.14],
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:388) ~[spring-tx-5.3.14.jar!/:5.3.14],
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:119) ~[spring-tx-5.3.14.jar!/:5.3.14],
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.3.14.jar!/:5.3.14],
    at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:753) ~[spring-aop-5.3.14.jar!/:5.3.14],
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:698) [spring-aop-5.3.14.jar!/:5.3.14],
    at com.sinosoft.microservice.contract.management.provider.service.sync.SyncInvoiceExcelService$$EnhancerBySpringCGLIB$$80333fff.syncInvoiceExcelToDataTable(<generated>) ~[classes!/:na],
    at com.sinosoft.microservice.contract.management.provider.web.DataImportController.syncInvoiceExcelToDataTable(DataImportController.java:225) ~[classes!/:na],
    at com.sinosoft.microservice.contract.management.provider.web.DataImportController$$FastClassBySpringCGLIB$$8226e756.invoke(<generated>) [classes!/:na],
    at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) [spring-core-5.3.14.jar!/:5.3.14],
    at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689) [spring-aop-5.3.14.jar!/:5.3.14],
    at com.sinosoft.microservice.contract.management.provider.web.DataImportController$$EnhancerBySpringCGLIB$$37bdbe0c.syncInvoiceExcelToDataTable(<generated>) [classes!/:na],
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[na:1.8.0_212],
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[na:1.8.0_212],
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[na:1.8.0_212],
    at java.lang.reflect.Method.invoke(Method.java:498) ~[na:1.8.0_212],
    at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:205) [spring-web-5.3.14.jar!/:5.3.14],
    at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:150) [spring-web-5.3.14.jar!/:5.3.14],
    at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:117) [spring-webmvc-5.3.14.jar!/:5.3.14],
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:895) [spring-webmvc-5.3.14.jar!/:5.3.14],
    at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:808) [spring-webmvc-5.3.14.jar!/:5.3.14],
    at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) [spring-webmvc-5.3.14.jar!/:5.3.14],
    at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1067) [spring-webmvc-5.3.14.jar!/:5.3.14],
    at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:963) [spring-webmvc-5.3.14.jar!/:5.3.14],
    at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) [spring-webmvc-5.3.14.jar!/:5.3.14],
    at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) [spring-webmvc-5.3.14.jar!/:5.3.14],
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:681) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) [spring-webmvc-5.3.14.jar!/:5.3.14],
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:764) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:53) [tomcat-embed-websocket-9.0.56.jar!/:na],
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-embed-core-9.0.56.jar!/:na],
    at com.sinosoft.microservice.contract.management.provider.filter.TokenFilter.doFilter(TokenFilter.java:34) [classes!/:na],
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.springframework.boot.actuate.metrics.web.servlet.WebMvcMetricsFilter.doFilterInternal(WebMvcMetricsFilter.java:96) [spring-boot-actuator-2.6.2.jar!/:2.6.2],
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.14.jar!/:5.3.14],
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) [spring-web-5.3.14.jar!/:5.3.14],
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.14.jar!/:5.3.14],
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.springframework.web.filter.CorsFilter.doFilterInternal(CorsFilter.java:91) [spring-web-5.3.14.jar!/:5.3.14],
    at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:117) [spring-web-5.3.14.jar!/:5.3.14],
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:189) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:197) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:97) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:540) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:135) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:92) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:78) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:357) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:382) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:895) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1732) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1191) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-embed-core-9.0.56.jar!/:na],
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-embed-core-9.0.56.jar!/:na],
    at java.lang.Thread.run(Thread.java:748) [na:1.8.0_212],
Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; statement executed: delete from cont_invoice where id=?,
    at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:67) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:54) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:47) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3698) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.persister.entity.AbstractEntityPersister.delete(AbstractEntityPersister.java:3958) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.action.internal.EntityDeleteAction.execute(EntityDeleteAction.java:123) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.engine.spi.ActionQueue.lambda$executeActions$1(ActionQueue.java:478) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at java.util.LinkedHashMap.forEach(LinkedHashMap.java:684) ~[na:1.8.0_212],
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:475) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:344) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:40) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],
    at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:107) ~[hibernate-core-5.6.3.Final.jar!/:5.6.3.Final],

目前本地无法复现, 线上也时不时出现,看日志怀疑事Service方法执行两遍,服务为批量服务, 执行了两分钟左右

想知道, 为什么会出现图中的两个线程号, 是不是这个原因导致的重复执行,进而导致的异常, 如何解决

写回答
好问题 0 提建议
追加酬金
关注问题
分享
邀请回答
编辑收藏删除
收藏举报

2条回答默认最新

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
三千烦恼丝xzh 2022-11-09 18:49
关注
看日志是从http请求开始执行的，那么出现http重调用也是正常不过的问题，不过是页面请求还是rpc都是可以有重试机制的，对于这种简单的可以做一个接口限流机制，锁的粒度可以根据业务需求调整

本回答被题主选为最佳回答 , 对您是否有帮助呢?

解决无用
评论打赏
分享
举报

评论

按下Enter换行，Ctrl+Enter发表内容

查看更多回答(1条)

报告相同问题？

关注问题

ssh框架，接口实现类调用service方法报空指针异常 eclipse hibernate java
2019-11-01 15:02

回答 2 已采纳 1.确保tpcCombinationSaleService不是null，打断点看一下 2.确保两个参数是否为null 3.如果都没问题，断点打到这一行 indexName = indexName.
通过java版sdk调用智能合约向Fabric提交交易出现异常 fabric java
2018-05-30 13:48

回答 5 已采纳问题已经解决，是因为忽略了在部署多通道情况下，通道数据需要同步，否则会因为chaincode中进行校验而导致chaincode执行失败，最终导致前台应用程序报错。
service调用其他service？还是调用其他service的dao？ java
2021-05-10 10:29

回答 4 已采纳实际中为了保证事务，大部分是一个service中调用多个dao。service中处理业务逻辑，dao层操作数据库
乐观锁失败异常ObjectOptimisticLockingFailureException
2021-01-30 17:31

DayDayUp丶的博客新开发的系统，往往可能需要将旧版的系统中的历史数据，用脚本的方式在新系统中跑一遍业务流程，其实可能是用Java代码自动调用一些业务流程接口。在执行过程中发现报错： 2021-01-27 19:32:46.300 ...
java后端调用Post请求在地址后面加参数抛异常 java
2019-01-26 14:55

回答 4 已采纳 1,把请求的URL 打印下，看一下字符 2，你的tomcat 版本是多少？tomcat高版本中URL有些特殊字符不允许，例如 { }
java动态加载类及调用类的方法 java
2017-03-15 14:16

回答 2 已采纳解析后，应该得到这样的结果： String className = "cn.market"; String methodName = "register"; List paramTypes =
javamail调用异常 imap java
2018-07-04 01:54

回答 1 已采纳认证失败，看看是不是需要SSL证书
JAVA-乐观锁更新失败或业务异常后接口重试
2019-07-03 14:12

葫芦胡的博客要么在应用层加锁，要么在缓存加锁，要么在数据库层使用乐观锁，使用version作为更新依据。说明：如果每次访问冲突概率小于20%，推荐使用乐观锁，否则使用悲观锁。乐观锁的重试次数不得小于3次。那这个重试机制...
为什么调用Mapper或者service时，报空指针错误 intellij-idea jar java spring
2019-04-15 15:51

回答 1 已采纳 Test主类上需要配置Spring配置文件路径，有没有配置呢？类似这样的： ``` @ContextConfiguration(locations = { "classpath:config/
Java 调用外部 exe 程序无反应 java
2018-03-21 09:45

回答 2 已采纳改成这样试试 ``` runtime.exec("\"F:/xinanjiang/send.exe\""); ```
通过java 程序调用jmeter 实现自动测试 java
2018-05-04 08:27

回答 3 已采纳 ``` public class AutoNumberRmiTest extends AbstractJavaSamplerClient { private AutoNumberSe
java mysql乐观锁_Java使用悲观锁和乐观锁解决数据库更新操作行锁的问题案例分享...
2021-02-06 21:22

周莫莫的博客 2、乐观锁：Optimistic Lock，来解决该问题。假设有1个账户，同时进行收入、支出的操作，需要保证账户金额不能出错，即，收入了账户增加余额，支出了账户减少余额，如果操作出错，则需要用户第二次重新操作。1、悲观...
Java中toString()方法调用的疑问 eclipse java
2019-07-31 10:25

回答 3 已采纳字符串的toString() 返回的是字符串本身。当你toString之后，再toString已经是字符串了 ![图片说明](https://img-ask.csdn.net/upload/201
乐观锁失败或接口调用失败后使用AOP实现重试机制
2023-12-13 15:14

ClinEvol的博客二、处理方案：捕获到对应乐观锁失败异常后进行重试。以下使用aop实现一个重试，可用于乐观锁。1、新建一个注解，用于标注需要重试的方法。3、新建切面类对标注注解的方法进行代理。2、新建重试的方法并添加注解。
Mysql乐观锁实战
2022-02-21 10:22

艾-普-西-隆的博客文章首先介绍乐观锁的概念，然后介绍乐观锁的实现原理，最后用一个springboot项目演示乐观锁的实现方式。目录什么是乐观锁 乐观锁实现原理实战什么是乐观锁 在进行数据库操作的时候，乐观锁总是假设查询...
没有解决我的问题, 去提问

问题事件

关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
系统已结题 11月18日
关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
已采纳回答 11月10日
关注

码龄粉丝数原力等级 --

被采纳

被点赞

采纳率
创建了问题 11月9日

悬赏问题

¥15 装 pytorch 的时候出了好多问题，遇到这种情况怎么处理？
¥20 IOS游览器某宝手机网页版自动立即购买JavaScript脚本
¥15 手机接入宽带网线，如何释放宽带全部速度
¥30 关于#r语言#的问题：如何对R语言中mfgarch包中构建的garch-midas模型进行样本内长期波动率预测和样本外长期波动率预测
¥15 ETLCloud 处理json多层级问题
¥15 matlab中使用gurobi时报错
¥15 这个主板怎么能扩出一两个sata口
¥15 不是，这到底错哪儿了😭
¥15 2020长安杯与连接网探
¥15 关于#matlab#的问题：在模糊控制器中选出线路信息，在simulink中根据线路信息生成速度时间目标曲线（初速度为20m/s，15秒后减为0的速度时间图像）我想问线路信息是什么

Service被调用两遍,导致乐观锁异常

Service被调用两遍,导致乐观锁异常

运行结果及报错内容 :图中的两次begin update sql就是被两个线程调用两遍

目前本地无法复现, 线上也时不时出现,看日志怀疑事Service方法执行两遍,服务为批量服务, 执行了两分钟左右

想知道, 为什么会出现图中的两个线程号, 是不是这个原因导致的重复执行,进而导致的异常, 如何解决

2条回答 默认 最新

问题事件

悬赏问题

2条回答默认最新