zsp419 opened a new issue, #7300: URL: https://github.com/apache/incubator-seata/issues/7300
获取全局锁失败,完整报错信息如下,请帮忙看下什么原因 ommit against JDBC Connection]org.springframework.orm.jpa.JpaSystemException: Unable to commit against JDBC Connection; nested exception is org.hibernate.TransactionException: Unable to commit against JDBC Connection at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:353) at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:255) at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:538) at org.springframework.transaction.support.AbstractPlatformTransactionManager.processCommit(AbstractPlatformTransactionManager.java:743) at org.springframework.transaction.support.AbstractPlatformTransactionManager.commit(AbstractPlatformTransactionManager.java:711) at org.springframework.transaction.interceptor.TransactionAspectSupport.commitTransactionAfterReturning(TransactionAspectSupport.java:632) at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:386) at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.rishiqing.service.workflow.impl.WorkFlowTaskCommonService$$EnhancerBySpringCGLIB$$7e4ead1a.completeTask(<generated>) at com.rishiqing.service.workflow.impl.WorkFlowTaskServiceImpl.completeTask(WorkFlowTaskServiceImpl.java:232) at com.rishiqing.service.workflow.impl.WorkFlowTaskServiceImpl$$FastClassBySpringCGLIB$$3ecd8e4c.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687) at com.rishiqing.service.workflow.impl.WorkFlowTaskServiceImpl$$EnhancerBySpringCGLIB$$b700e1bb.completeTask(<generated>) at com.rishiqing.controller.workflow.WorkFlowTaskController.completeTask(WorkFlowTaskController.java:46) at com.rishiqing.controller.workflow.WorkFlowTaskController$$FastClassBySpringCGLIB$$3b5a2f6a.invoke(<generated>) at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.invokeJoinpoint(CglibAopProxy.java:771) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.adapter.AfterReturningAdviceInterceptor.invoke(AfterReturningAdviceInterceptor.java:55) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.adapter.MethodBeforeAdviceInterceptor.invoke(MethodBeforeAdviceInterceptor.java:56) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:749) at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:691) at com.rishiqing.controller.workflow.WorkFlowTaskController$$EnhancerBySpringCGLIB$$f81834a3.completeTask(<generated>) at sun.reflect.GeneratedMethodAccessor637.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:105) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:879) at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:793) at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1040) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:943) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1006) at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:909) at javax.servlet.http.HttpServlet.service(HttpServlet.java:648) at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:883) at javax.servlet.http.HttpServlet.service(HttpServlet.java:729) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:292) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.springframework.web.filter.RequestContextFilter.doFilterInternal(RequestContextFilter.java:100) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.springframework.web.filter.FormContentFilter.doFilterInternal(FormContentFilter.java:93) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:128) at org.springframework.boot.web.servlet.support.ErrorPageFilter.access$000(ErrorPageFilter.java:66) at org.springframework.boot.web.servlet.support.ErrorPageFilter$1.doFilterInternal(ErrorPageFilter.java:103) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at org.springframework.boot.web.servlet.support.ErrorPageFilter.doFilter(ErrorPageFilter.java:121) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.springframework.web.servlet.v3_1.OpenTelemetryHandlerMappingFilter.doFilter(OpenTelemetryHandlerMappingFilter.java:84) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:201) at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:119) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:240) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:207) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:212) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:94) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:141) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:79) at org.apache.catalina.valves.AbstractAccessLogValve.invoke(AbstractAccessLogValve.java:620) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:88) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:502) at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1132) at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:684) at org.apache.tomcat.util.net.AprEndpoint$SocketWithOptionsProcessor.run(AprEndpoint.java:2464) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) at java.lang.Thread.run(Thread.java:748) Caused by: org.hibernate.TransactionException: Unable to commit against JDBC Connection at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.commit(AbstractLogicalConnectionImplementor.java:92) at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:282) at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) at org.springframework.orm.jpa.JpaTransactionManager.doCommit(JpaTransactionManager.java:534) ... 88 common frames omitted Caused by: io.seata.rm.datasource.exec.LockWaitTimeoutException: Global lock wait timeout at io.seata.rm.datasource.exec.LockRetryController.sleep(LockRetryController.java:66) at io.seata.rm.datasource.ConnectionProxy$LockRetryPolicy.doRetryOnLockConflict(ConnectionProxy.java:364) at io.seata.rm.datasource.ConnectionProxy$LockRetryPolicy.execute(ConnectionProxy.java:348) at io.seata.rm.datasource.ConnectionProxy.commit(ConnectionProxy.java:187) at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.commit(AbstractLogicalConnectionImplementor.java:86) ... 91 common frames omitted Caused by: io.seata.rm.datasource.exec.LockConflictException: get global lock fail, xid:192.168.22.217:8091:8206105597936901980, lockKeys:act_ru_variable:648928845443727496;act_ru_variable:648928845443727494;act_hi_varinst:642660036525260802;act_ru_variable:648928845443727412;act_hi_varinst:642660036525260800;act_ru_variable:648928845443727410;act_ru_variable:648928845443727498;act_ru_variable:648928845443727416;act_ru_variable:648928845443727414;act_ru_variable:648928845443727418;act_ru_variable:648928845443727422;act_ru_variable:648928845443727420;act_ru_variable:648928845443727426;act_ru_variable:648928845443727424;act_ru_variable:648928845443727428;act_ru_variable:648928845443727392;act_ru_execution:630703733930295296;act_ru_variable:648928845443727474;act_ru_variable:648928845443727472;act_ru_variable:648928845443727478;act_ru_variable:648928845443727510;act_ru_variable:648928845443727476;act_ru_variable:648928845443727514;act_ru_variable:648928845443727512;act_ru_variable:64 8928845443727518;act_ru_variable:648928845443727516;act_ru_variable:648928845443727480;act_ru_task:648928845452115979;act_ru_variable:648928845443727484;act_ru_variable:648928845443727482;act_ru_variable:642660036525260800;act_ru_variable:648928845443727400;act_ru_variable:648928845443727488;act_ru_variable:642660036525260802;act_ru_variable:648928845443727486;act_ru_variable:648928845443727404;act_ru_variable:648928845443727402;act_ru_variable:648928845443727408;act_ru_variable:648928845443727406;act_ru_variable:648928845443727492;act_ru_variable:648928845443727490;act_ru_variable:648928845443727452;act_ru_variable:648928845443727450;act_hi_taskinst:648928845452115979;act_ru_variable:648928845443727456;act_ru_variable:648928845443727454;act_ru_variable:648928845443727458;act_hi_actinst:648928845452115978;act_ru_variable:648928845443727462;act_ru_variable:648928845443727460;act_ru_variable:648928845443727500;act_ru_variable:648928845443727466;act_ru_variable:648928845443727464;act_r u_execution:648928845443727389;act_ru_variable:648928845443727504;act_ru_execution:648928845443727388;act_ru_execution:648928845443727387;act_ru_variable:648928845443727502;act_ru_execution:648928845443727386;act_ru_variable:648928845443727468;act_ru_execution:648928845443727385;act_ru_variable:648928845443727508;act_ru_execution:648928845443727384;act_ru_execution:648928845443727383;act_ru_variable:648928845443727506;act_ru_execution:648928845443727382;act_ru_execution:648928845443727381;act_ru_execution:648928845443727391;act_hi_detail:656170047254695936,656170047263084544;act_ru_execution:648928845443727390;act_ru_variable:648928845443727470;act_ru_variable:648928845443727430;act_ru_variable:648928845443727396;act_ru_execution:632153024246939648;act_ru_variable:648928845443727394;act_ru_variable:648928845443727434;act_ru_variable:648928845443727432;act_ru_execution:648928845443727379;act_ru_variable:648928845443727398;act_ru_execution:648928845443727378;act_ru_variable:6489288454 43727438;act_ru_execution:648928845443727377;act_ru_execution:648928845443727376;act_ru_variable:648928845443727436;act_ru_execution:648928845443727375;act_ru_execution:648928845443727374;act_ru_execution:648928845443727373;act_ru_execution:648928845443727372;act_ru_execution:648928845443727371;act_ru_execution:648928845443727370;act_ru_execution:648928845443727380;act_ru_variable:648928845443727440;act_ru_variable:648928845443727444;act_ru_execution:648928845443727369;act_ru_execution:648928845443727368;act_ru_variable:648928845443727442;act_ru_execution:648928845443727367;act_ru_execution:648928845443727366;act_ru_variable:648928845443727448;act_ru_execution:648928845443727365;act_ru_execution:648928845443727364;act_ru_variable:648928845443727446;act_ru_execution:648928845443727363;act_ru_execution:648928845443727362;act_ru_execution:648928845443727361;act_ru_execution:648928845443727360;act_hi_actinst:656170048244551680 at io.seata.rm.datasource.ConnectionProxy.recognizeLockKeyConflictException(ConnectionProxy.java:159) at io.seata.rm.datasource.ConnectionProxy.processGlobalTransactionCommit(ConnectionProxy.java:252) at io.seata.rm.datasource.ConnectionProxy.doCommit(ConnectionProxy.java:230) at io.seata.rm.datasource.ConnectionProxy.lambda$commit$0(ConnectionProxy.java:188) at io.seata.rm.datasource.ConnectionProxy$LockRetryPolicy.doRetryOnLockConflict(ConnectionProxy.java:356) ... 94 common frames omitted 收起 -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: notifications-unsubscr...@seata.apache.org.apache.org For queries about this service, please contact Infrastructure at: us...@infra.apache.org --------------------------------------------------------------------- To unsubscribe, e-mail: notifications-unsubscr...@seata.apache.org For additional commands, e-mail: notifications-h...@seata.apache.org