You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@seata.apache.org by "zsp419 (via GitHub)" <gi...@apache.org> on 2025/04/17 08:31:50 UTC
[I] get global lock fail [incubator-seata]
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-unsubscribe@seata.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org
Re: [I] get global lock fail [incubator-seata]
Posted by "funky-eyes (via GitHub)" <gi...@apache.org>.
funky-eyes closed issue #7300: get global lock fail
URL: https://github.com/apache/incubator-seata/issues/7300
--
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-unsubscribe@seata.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org
Re: [I] get global lock fail [incubator-seata]
Posted by "funky-eyes (via GitHub)" <gi...@apache.org>.
funky-eyes commented on issue #7300:
URL: https://github.com/apache/incubator-seata/issues/7300#issuecomment-2812215756
锁被其它事务占用了，请查看server端相关日志进行排查锁被哪个事务所持有。
The lock is held by another transaction. Please check the server-side logs to investigate which transaction is holding the lock.
--
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-unsubscribe@seata.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org
Re: [I] get global lock fail [incubator-seata]
Posted by "zsp419 (via GitHub)" <gi...@apache.org>.
zsp419 closed issue #7300: get global lock fail
URL: https://github.com/apache/incubator-seata/issues/7300
--
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-unsubscribe@seata.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@seata.apache.org
For additional commands, e-mail: notifications-help@seata.apache.org