Верблюд Jboss Верблюд AriesXATransaction Mybatis oracle javax.transaction.RollbackException: Невозможно зафиксировать: транзакция помечена для отката
Jboss Fuse Aries XA transactions issue. XA Datasource is setup using Aries-XA auto enlistment.
Blueprint-xml для предоставления источника данных
<service interface="javax.sql.XADataSource" ref="oracle-XA-DB">
<service-properties>
<entry key="datasource.name" value="oracleXADB" />
<entry key="aries.xa.name" value="oracle-XA-DB" />
<entry key="aries.xa.username" value="${datasource.user}" />
<entry key="aries.xa.password" value="${datasource.password}" />
<entry key="aries.xa.pooling" value="true" />
<entry key="aries.xa.poolMinSize" value="0" />
<entry key="aries.xa.poolMaxSize" value="10" />
<entry key="aries.xa.exceptionSorter" value="known" />
<entry key="aries.xa.transaction" value="none" />
</service-properties>
</service>
This datasource exposed is retrieved using mybatis-component to execute the database operations. The XA commit, roll-backs are working fine for the initial few transactions. Later, the entire bundles dependent upon the datasource fails with the following exception. Once, the bundles are restarted, the services are working fine, but only for a limited time.
StackTrace org.apache.camel.impl.DefaultMessage | Имя метода: autoSave| Данные журнала: On Exception Error MSG| Сообщение об исключении: транзакция JTA неожиданно откатилась (возможно из-за тайм-аута); вложенное исключение: javax.transaction.RollbackException: невозможно зафиксировать: транзакция помечена для отката | Исключение StackTrace:org.springframework.transaction.UnexpectedRollbackException: транзакция JTA неожиданно откатилась (возможно из-за тайм-аута); Вложенное исключение: javax.transaction.RollbackException: Невозможно выполнить фиксацию: транзакция, помеченная для отката в org.springframework.transaction.jta.JtaTransactionManager.doCommit(JtaTransactionManager.java:1015) в org.springframework.transaction.ManagerTransform.Transform.Transform.Port.Format.Port: Неизвестный источник) в org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:148) в org.apache.camel.spring.spi.TransactionErrorHandler.doInTransactionTemplate(TransactionErrorHandler.jameg.17).4 spring.spi.TransactionErrorHandler.processInTransaction(TransactionErrorHandler.java:134) в org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:103) в org.apache.camel.spring.spi.TransactionErrorHandler.process(TransactionErrorHandler.java:112) в org.apache.orame.proame.proame. процесс (CamelInternalProcessor.java:191) в org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191) в org.apache.camel.component.directvm.DirectVmProcessor.process(DirectVmProcessor.java:55).apache.camel.component.directvm.DirectVmProducer.process(DirectVmProducer.java:55) в org.apache.camel.processor.SendProcessor.process(SendProcessor.java:129) в org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) в org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191) в org.apache.camel.processor.Pipeline.process(Pipeline.java:118) в org.apache.camel.processor.Pipeline.process(Pipeline.java:80) в org.apache.camel.processor.ChoiceProcessor.process(ChoiceProcessor.java:111) в org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) в org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191) в org.ache.camel.processor.Pipeline.process (Pipeline.java:118) в org.apache.camel.processor.Pipeline.process (Pipeline.java:80) в org.apache.camel.processor.TryProcessor.process(TryProcessor.java:113) в org.apache.camel.processor.TryProcessor.process(TryProcessor.java:84) в org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) в org.apache.camel.processor. CamelInternalProcessor.process (CamelInternalProcessor.java:191) в org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:191) в org.apache.camel.component.cxf.jaxrs.CxfRsInvker (93) на org.apache.camel.component.cxf.jaxrs.CxfRsInvoker.performInvocation (CxfRsInvoker.java:68) на org.apache.cxf.service.invoker.AbstractInvoker.invoke(AbstractInvoker.java:97) в org.apache.cxf.jaxrs.JAXRSInvoker.invoke(JAXRSInvoker.java:200) в org.apache.cxf.jaxrs.JAXRSInvoker.invoke (JAjavaIn99oker) в org.apache.cxf.interceptor.ServiceInvokerInterceptor$1.run(ServiceInvokerInterceptor.java:59) в org.apache.cxf.interceptor.ServiceInvokerInterceptor.handleMessage(ServiceInvokerInterceptor.java:96) в org.pha.pha.pha.doIntercept(PhaseInterceptorChain.java:307) по адресу org.apache.cxf.transport.ChainInitiationObserver.onMessage(ChainInitiationObserver.java:121) по адресу org.apache.cxf.transport.http.AbstractHTTPDest.jt).apache.cxf.transport.servlet.ServletController.invokeDestination(ServletController.java:234) в org.apache.cxf.transport.servlet.ServletController.invoke(ServletController.java:208) в org.apt..ServletController.invoke(ServletController.java:160) в org.apache.cxf.transport.servlet.CXFNonSpringServlet.invoke(CXFNonSpringServlet.java:171) в org.apache.cxf.transport.servlet.AbstractHTTPServlet.handleRequest(AbstractHTTPServlet.java:293) в org.apache.cxf.transport.servT.erletHH 212) в javax.servlet.http.HttpServlet.service (HttpServlet.java:595) в org.apache.cxf.transport.servlet.AbstractHTTPServlet.service (AbstractHTTPServlet.java:268) в org.ecliplet.jt..handle(ServletHolder.java:684) в org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:503) в org.ops4j.pax.web.service.jetty.internal.HttpServiceServletHler:69) в org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) в org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:533) в org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231) в org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086) в org.ops4j.pax.web.service.jetty.internal.HttpServiceContext.doHandle(HttpServiceContext.java:240) в org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429ser) в org.eclserser session.SessionHandler.doScope(SessionHandler.java:193) в org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020) в org.eclipse.jetty.server.handler.ScopedHandler.handle (Scoped. Java:135) в org.ops4j.pax.web.service.jetty.internal.JettyServerHandlerCollection.handle(JettyServerHandlerCollection.java:75) в org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper)). в org.eclipse.jetty.server.Server.handle(Server.java:370) в org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494) в org.eclipse.jetty.sertt.Conbent(AbstractHttpConnection.java:982) в org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.content(AbstractHttpConnection.java:1043) в org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:865) по адресу org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) по адресу org.eclipse.jetty.server.Asyncttp. org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696) в org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53) в org.ecliptil.j.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) в org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543) в java.lang.Thread.run(поток) Причина: javax.transaction.RollbackException: Невозможно зафиксировать: транзакция, отмеченная для отката в org.apache.geronimo.transaction.manager.TransactionImpl.commit(TransactionImpl.java:272) в org.apache.geronimo.transaction.manager.TransactionManagerImpl.commit(TransactionManagerImpl.java:252) в org.springframework.transaction.jta.JtaTransactionManager.doCommit(JtaTransactionManager.java:1012) ... еще 72 Причина d: oracle.jdbc.xa.OracleXAException в oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1101) в oracle.jdbc.xa.client.OracleXAResource.start(OracleXAResource.java:237) в org..geronimo.transaction..getConnection(TransactionEnlistingInterceptor.java:60) в org.apache.geronimo.connector.outbound.TransactionCachingInterceptor.getConnection(TransactionCachingInterceptor.java:101) в org.apache.geronimo.connector.outbound.ConnectionHandorInter (org).) в org.apache.geronimo.connector.outbound.TCCLInterceptor.getConnection(TCCLInterceptor.java:39) в org.apache.geronimo.connector.outbound.ConnectionTrackingInterceptor.getConnection(ConnectionTrackingInterceptor.java:66) в org.ap ache.geronimo.connector.outbound. DataSourceUtils.java:111) по адресу org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) по адресу org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.spring.pring.pring.pring.pring.pring.pring.pring.pring.pring..transaction.SpringManagedTransaction.getConnection(SpringManagedTransaction.java:67) в org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279) в org.apache.ibatis.executor.SimpleExecutor.prepareStatement(Simple) в org.apache.ibatis.executor.SimpleExecutor.doQuery (SimpleExecutor.java:59) в org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267) в org.apache.ibatis.executor.BaseExecutor. запроса (BaseExecutor.java:137) в org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:96) в org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:77) в org.apache.ibatis.executor.keygen.SelectKeyGenerator.processGeneratedKeys(SelectKeyGenerator.java:66) в org.apache.ibatis.executor.keygen.SelectKeyGenerator.processBefore(SelectKeyGenerator.java:46) в org.apache.ibatis.executor.statement.BavaSeneeHandmentHementHatementHtate:130) в org.apache.ibatis.executor.statement.BaseStatementHandler.(BaseStatementHandler.java:63) в org.apache.ibatis.executor.statement.PreparedStatementHandler.(PreparedStatementHandler.java:39) в org.apache.at executor.statement.RoutingStatementHandler.(RoutingStatementHandler.java:45) в org.apache.ibatis.session.Configuration.newStatementHandler(Configuration.java:468) в org.apache.ibatis.executor.SimpleExecutor.doU46date (Simple) в org.apache.ibatis.executor.BaseExecutor.update(BaseExecutor.java:105) в org.apache.ibatis.executor.CachingExecutor.update(CachingExecutor.java:71) в org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:152) в org.apache.ibatis.session.defalSessionSq.insert(DefaultSqlSession.java:141) в sun.reflect.GeneratedMethodAccessor701.invoke(Неизвестный источник) в sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) в java.voke.f.:606) в org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:358) в com.sun.proxy.$Proxy96.insert(неизвестный источник) в org.mybatis.spring.SqlSessionTemplSl. Java: 240) в org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:51) в org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:52) в com.sun.proxy.$Proxy120.insertAutoSaveData(неизвестный источник) по адресу com.scb.s2b.entity.common.service.autosavedata.dao.AutoSaveDataServiceDAO.insertAutoSaveData(AutoSaveDataServiceDAO.java:46) at com.scb.s2b.entity.common.service.autosavedata.AutoSaveDataServiceImpl.create(AutoSaveDataServiceImpl.java:101) в Proxy35e8703c_fb57_4678_af6c_7ddd) в sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) в java.lang.reflect.Method.invoke(Method.java:606) в org.apache.camel.component.bean.MethodInfo. Java:408) в org.apache.camel.component.bean.MethodInfo$1.doProceed(MethodInfo.java:279) в org.apache.camel.component.bean.MethodInfo$1.proceed(MethodInfo.java:252) в org.apache.camel.component.bean.BeanProcessor.process(BeanProcessor.java:171) в org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) в org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:109) в org.apache.camel.processor.DelegateAsyncProcessor.process(DelegateAsyncProcessor.java:87) в org.apache.camel.processor.CamelInternalProcessor.process(CamelInternalProcessor.java:166) в org.apache.camel.processor.Pipeline.process(Pipeline.java:118) в org.apache.camel.processor.Pipeline.process (конвейер. Java: 80) в org.apache.camel.processor.TryProcessor.process (TryProcessor.java:113) в org.apache.camel.processor.TryProcessor.process(TryProcessor.java:84) в org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) при org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:448) при org.apache.camel.util.AsyncProcessorHelper.process(AsyncProcessorHelper.java:109) в org.apache.camel.processor.RedeliveryErrorHandler.process(RedeliveryErrorHandler.java:329) в org.apache.camel.processor.DefaultErrorHandler.process(DefaultErrorHandler.java:56) в org.apache.prooror.proame.proame.proame.proame () CamelInternalProcessor.java:166) в org.apache.camel.processor.RedeliveryErrorHandler.process (RedeliveryErrorHandler. Java: 448) в org.apache.camel.spring.spi.TransactionErrorHandler.processByErrorHandler(TransactionErrorHandler.java:218) в org.apache.camel.spring.spi.TransactionErrorHandler.process (TransactionErava.exe).camel.spring.spi.TransactionErrorHandler.process (TransactionErrorHandler.java:112) при org.apache.camel.management.InstrumentationProcessor.process(InstrumentationProcessor.java:77) в org.apache.camel.processor.RedeliveryErrorHandler.process (RedeliveryErrorHandler 0.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) в org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:131...)