获取事务已在另一个线程异常中回滚 [英] Getting Transaction was rolled back in a different thread exception
问题描述
所以我在Wildfly 10 Application Server中配置了2个xa-datsource，我使用的是Hibernate ORM 5.2.9。数据库是Postgres 9.6
So I have 2 xa-datsources configured in my Wildfly 10 Application Server and I am using Hibernate ORM 5.2.9. And the DB is Postgres 9.6
在我的应用程序中，我有一个EJB，它有2个嵌套for循环，我必须在嵌套循环的每次迭代中从表中读取数据。但是一段时间后我得到了这个异常
In my application I have an EJB which has 2 nested for loops and I have to read data from a table in every iteration of the nested loop. But after some time I'm getting this exception
javax.ejb.EJBTransactionRolledbackException：org.hibernate.HibernateException：事务已回滚到不同的主题！
javax.ejb.EJBTransactionRolledbackException: org.hibernate.HibernateException: Transaction was rolled back in a different thread!
我无法理解为什么会这样。我有一个小概念验证应用程序，它使用JDBC连接到数据库，一切正常。
I can't understand why this is happening. I have a small proof of concept application which uses JDBC to connect to the DB and everything works fine.
编辑
这是抛出我提到的异常后的堆栈跟踪：
EDIT This is the stacktrace after the exception I mentioned is thrown:
12：39：07,319 WARN [com.arjuna.ats.arjuna]（默认任务） -7）
ARJUNA012077：Abort调用已经中止的原子动作
0：ffffac280184：2edc54df：598adfb2：27f
12：39：07,320 ERROR [org.jboss.as.ejb3.invocation] （默认任务-7）WFLYEJB0034：EJB调用在组件
ejb / calculationResource上失败，方法为public void
com.actuariado.smartsolve.services.api.calculation.CalculationResource.calculateFinancial（org.jboss.resteasy。 plugins.providers.multipart.MultipartFormDataInput）
抛出com.actuariado.smartsolve.exceptions.AppException：
javax.ejb.EJBTransactionRolledbackException：事务在org.jboss.as.ejb3.tx回滚
.CMTTxInterceptor.handleEndTransactionExc epp（CMTTxInterceptor.java:137）
at org.jboss.as.ejb3.tx.CMTTxInterceptor.endTransaction（CMTTxInterceptor.java:117）
at org.jboss.as.ejb3.tx.CMTTxInterceptor。 invokeInOurTx（CMTTxInterceptor.java:279）
at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:327）
at org.jboss.as.ejb3.tx.CMTTxInterceptor。 processInvocation（CMTTxInterceptor.java:239）
at org.jboss.invocation.InterceptorContext.proceed（InterceptorContext.java:340）
at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation（ CurrentInvocationContextInterceptor.java:41）
at org.jboss.invocation.InterceptorContext.proceed（InterceptorContext.java:340）
at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation（WaitTimeInterceptor。 java：47）
at org.jboss.invocation.InterceptorContext.proce ed（InterceptorContext.java:340）
at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation（SecurityContextInterceptor.java:100）
at org.jboss.invocation.InterceptorContext.proceed（InterceptorContext。 java：340）
at org.jboss.as.ejb3.deployment.processors.StartupAwaitInterceptor.processInvocation（StartupAwaitInterceptor.java:22）
at org.jboss.invocation.InterceptorContext.proceed（InterceptorContext.java： 340）
at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory $ 1.processInvocation（ShutDownInterceptorFactory.java:64）
at org.jboss.invocation.InterceptorContext.proceed（InterceptorContext.java:340 ）
at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation（LoggingInterceptor.java:67）
at org.jboss.invocation.InterceptorContext.proceed（InterceptorContext.java:340）
at org.jbos s.as.ee.component.NamespaceContextInterceptor.processInvocation（NamespaceContextInterceptor.java:50）
at org.jboss.invocation.InterceptorContext.proceed（InterceptorContext.java:340）
at org.jboss.as。 ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation（AdditionalSetupInterceptor.java:54）
at org.jboss.invocation.InterceptorContext.proceed（InterceptorContext.java:340）
at org.jboss.invocation.ContextClassLoaderInterceptor。 processInvocation（ContextClassLoaderInterceptor.java:64）
at org.jboss.invocation.InterceptorContext.proceed（InterceptorContext.java:340）
at org.jboss.invocation.InterceptorContext.run（InterceptorContext.java:356）
at org.wildfly.security.manager.WildFlySecurityManager.doChecked（WildFlySecurityManager.java:636）
at org.jboss.invocation.AccessCheckingInterceptor.processInvocation（AccessCheckingInterceptor.jav） a：61）
at org.jboss.invocation.InterceptorContext.proceed（InterceptorContext.java:340）
at org.jboss.invocation.InterceptorContext.run（InterceptorContext.java:356）
at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation（PrivilegedWithCombinerInterceptor.java:80）
at org.jboss.invocation.InterceptorContext.proceed（InterceptorContext.java:340）
at org.jboss.invocation.ChainedInterceptor .processInvocation（ChainedInterceptor.java:61）
at org.jboss.as.ee.component.ViewService $ View.invoke（ViewService.java:198）
at org.jboss.as.ee.component .ViewDescription $ 1.processInvocation（ViewDescription.java:185）
at org.jboss.invocation.InterceptorContext.proceed（InterceptorContext.java:340）
at org.jboss.invocation.ChainedInterceptor.processInvocation（ChainedInterceptor。 java：61）
at org.jboss.as.ee.compon ent.ProxyInvocationHandler.invoke（ProxyInvocationHandler.java:73）
at com.actuariado.smartsolve.services.api.calculation.CalculationResource $$$ view200.calculateFinancial（Unknown
Source）
at sun .reflect.NativeMethodAccessorImpl.invoke0（原生方法）
at sun.reflect.NativeMethodAccessorImpl.invoke（NativeMethodAccessorImpl.java:62）
at sun.reflect.DelegatingMethodAccessorImpl.invoke（DelegatingMethodAccessorImpl.java:43）
at java.lang.reflect.Method.invoke（Method.java:498）
at org.jboss.resteasy.core.MethodInjectorImpl.invoke（MethodInjectorImpl.java:139）
at org.jboss .resteasy.core.ResourceMethodInvoker.invokeOnTarget（ResourceMethodInvoker.java:295）
at org.jboss.resteasy.core.ResourceMethodInvoker.invoke（ResourceMethodInvoker.java:249）
at org.jboss.resteasy.core .ResourceMethodInvoker.invoke（ResourceMethodInvoker.java:236 ）
at org.jboss.resteasy.core.SynchronousDispatcher.invoke（SynchronousDispatcher.java:402）
at org.jboss.resteasy.core.SynchronousDispatcher.invoke（SynchronousDispatcher.java:209)
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221）
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(httpServletDispatcher.java:56 ）
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(httpServletDispatcher.java:51）
at javax.servlet.http.HttpServlet.service（HttpServlet.java:790)
at io.undertow.servlet.handlers.ServletHandler.handleRequest（ServletHandler.java:85）
at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest（ServletSecurityRoleHandler.java:62）
在io.undertow.servlet.handlers.ServletDispatchingHandl er.handleRequest（ServletDispatchingHandler.java:36）
at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest（SecurityContextAssociationHandler.java:78）
at io.undertow.server.handlers.PredicateHandler。 handleRequest（PredicateHandler.java:43）
at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest（SSLInformationAssociationHandler.java:131）
at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler。 handleRequest（ServletAuthenticationCallHandler.java:57）
at io.undertow.server.handlers.PredicateHandler.handleRequest（PredicateHandler.java:43）
at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest（AbstractConfidentialityHandler。 java：46）
at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest（ServletConfidentialityConstrain tHandler.java:64）
at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest（AuthenticationMechanismsHandler.java:60）
at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest（CachedAuthenticatedSessionHandler。 java：77）
at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest（NotificationReceiverHandler.java:50）
at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest（AbstractSecurityContextAssociationHandler.java:43）
at io.undertow.server.handlers.PredicateHandler.handleRequest（PredicateHandler.java:43）
at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest（JACCContextIdHandler.java:61）
at io.undertow.server.handlers.PredicateHandler.handleRequest（PredicateHandler.java:43）
at io.undertow.server.handlers.Predic ateHandler.handleRequest（PredicateHandler.java:43）
at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest（ServletInitialHandler.java:292)
at io.undertow.servlet.handlers.ServletInitialHandler.access $ 100 （ServletInitialHandler.java:81）
at io.undertow.servlet.handlers.ServletInitialHandler $ 2.call（ServletInitialHandler.java:138）
at io.undertow.servlet.handlers.ServletInitialHandler $ 2.call（ServletInitialHandler .java：135）
at io.undertow.servlet.core.ServletRequestContextThreadSetupAction $ 1.call（ServletRequestContextThreadSetupAction.java:48）
at io.undertow.servlet.core.ContextClassLoaderSetupAction $ 1.call（ContextClassLoaderSetupAction.java ：43）
at io.undertow.servlet.api.LegacyThreadSetupActionWrapper $ 1.call（LegacyThreadSetupActionWrapper.java:44）
at io.undertow.servlet.api.LegacyThreadSetupActionWrapper $ 1.call（LegacyThreadSe） tupActionWrapper.java:44）
at io.undertow.servlet.api.LegacyThreadSetupActionWrapper $ 1.call（LegacyThreadSetupActionWrapper.java:44）
at io.undertow.servlet.api.LegacyThreadSetupActionWrapper $ 1.call（LegacyThreadSetupActionWrapper。 java：44）
at io.undertow.servlet.api.LegacyThreadSetupActionWrapper $ 1.call（LegacyThreadSetupActionWrapper.java:44）
at io.undertow.servlet.api.LegacyThreadSetupActionWrapper $ 1.call（LegacyThreadSetupActionWrapper.java： 44）
at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest（ServletInitialHandler.java:272）
at io.undertow.servlet.handlers.ServletInitialHandler.access $ 000（ServletInitialHandler.java:81）
at io.undertow.servlet.handlers.ServletInitialHandler $ 1.handleRequest（ServletInitialHandler.java:104）
at io.undertow.server.Connectors.executeRootHandler（Connectors.java:202)
at io .unde rtow.server.HttpServerExchange $ 1.run（HttpServerExchange.java:805）
at java.util.concurrent.ThreadPoolExecutor.runWorker（ThreadPoolExecutor.java:1142）
at java.util.concurrent.ThreadPoolExecutor $ Worker .run（ThreadPoolExecutor.java:617）
at java.lang.Thread.run（Thread.java:745)
引起：javax.transaction.RollbackException：WFLYEJB0447：Transaction'TransactionImple< ac，BasicAction：
0：ffffac280184：2edc54df：598adfb2：27f status：ActionStatus.ABORTED>'
已在org.jboss.as.ejb3.tx.CMTTxInterceptor.endTransaction回滚
（CMTTxInterceptor.java:98）
... 88 more
12:39:07,319 WARN [com.arjuna.ats.arjuna] (default task-7) ARJUNA012077: Abort called on already aborted atomic action 0:ffffac280184:2edc54df:598adfb2:27f 12:39:07,320 ERROR [org.jboss.as.ejb3.invocation] (default task-7) WFLYEJB0034: EJB Invocation failed on component ejb/calculationResource for method public void com.actuariado.smartsolve.services.api.calculation.CalculationResource.calculateFinancial(org.jboss.resteasy.plugins.providers.multipart.MultipartFormDataInput) throws com.actuariado.smartsolve.exceptions.AppException: javax.ejb.EJBTransactionRolledbackException: Transaction rolled back at org.jboss.as.ejb3.tx.CMTTxInterceptor.handleEndTransactionException(CMTTxInterceptor.java:137) at org.jboss.as.ejb3.tx.CMTTxInterceptor.endTransaction(CMTTxInterceptor.java:117) at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:279) at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:327) at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:239) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:47) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.deployment.processors.StartupAwaitInterceptor.processInvocation(StartupAwaitInterceptor.java:22) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:67) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:54) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:64) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356) at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:636) at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:61) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:356) at org.jboss.invocation.PrivilegedWithCombinerInterceptor.processInvocation(PrivilegedWithCombinerInterceptor.java:80) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:198) at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:185) at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:340) at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73) at com.actuariado.smartsolve.services.api.calculation.CalculationResource$$$view200.calculateFinancial(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:139) at org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:295) at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:249) at org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:236) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:402) at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:209) at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:221) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:51) at javax.servlet.http.HttpServlet.service(HttpServlet.java:790) at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:85) at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62) at io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36) at org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:131) at io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46) at io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64) at io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60) at io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77) at io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50) at io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43) at io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:292) at io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:81) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:138) at io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:135) at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48) at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44) at io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:272) at io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:81) at io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:104) at io.undertow.server.Connectors.executeRootHandler(Connectors.java:202) at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:805) at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617) at java.lang.Thread.run(Thread.java:745) Caused by: javax.transaction.RollbackException: WFLYEJB0447: Transaction 'TransactionImple < ac, BasicAction: 0:ffffac280184:2edc54df:598adfb2:27f status: ActionStatus.ABORTED >' was already rolled back at org.jboss.as.ejb3.tx.CMTTxInterceptor.endTransaction(CMTTxInterceptor.java:98) ... 88 more
推荐答案
所以我想我弄清楚发生了什么。
看起来，当调用我的EJB方法时，Container会创建一个全局JTA事务，或类似的事务，它的超时时间为5分钟（默认来自Wildfly）。
由于我的业务逻辑（嵌套循环）花费的时间超过了处理时间，因此当我尝试再次访问数据库时，事务会超时并抛出异常。
So I think I figured out what's happening. As it seems, when my EJB method is invoked the Container creates a global JTA transaction, or something like that, which has a timeout of 5 minutes (default from Wildfly). Since my business logic (the nested loops) is taking more than that time to process, the transaction times out and throws that exception when I try to access the DB again.
这篇关于获取事务已在另一个线程异常中回滚的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
