Issue with transaction/Hibernate persistence and MariaDB in Wildfly 15 Final

[alban5650]

Hello,

We are having issues after deploying our application in the latest Wildfly 15.0.0 Final recently released with the following exception:

     java.sql.SQLException: XAER_RMFAIL: The command cannot be executed when global transaction is in the  IDLE state

The error occurs when our code calls a transactional EJB method that itself calls a couple more injected SessionBean that handles the database persistence through an EntityManager

The issue only seems to affect the MariaDB port and not oracle. Here is the full stacktrace generated by the server:

14:47:02,375 ERROR [org.jboss.as.ejb3.invocation] (default task-2) WFLYEJB0034: EJB Invocation failed on component CPC for method public abstract com.banctec.caseware.helpers.InformationHolder com.banctec.caseware.server.cpc.CPC.login(com.banctec.caseware.helpers.InformationHolder,java.lang.String,java.lang.String,java.lang.String) throws com.banctec.caseware.exceptions.CaseWareException: javax.ejb.EJBTransactionRolledbackException: javax.transaction.RollbackException: ARJUNA016053: Could not commit transaction.

    at org.jboss.as.ejb3.tx.CMTTxInterceptor.endTransaction(CMTTxInterceptor.java:114)

    at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:261)

    at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:362)

    at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:144)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

    at org.jboss.invocation.InterceptorContext$Invocation.proceed(InterceptorContext.java:509)

    at org.jboss.weld.module.ejb.AbstractEJBRequestScopeActivationInterceptor.aroundInvoke(AbstractEJBRequestScopeActivationInterceptor.java:81)

    at org.jboss.as.weld.ejb.EjbRequestScopeActivationInterceptor.processInvocation(EjbRequestScopeActivationInterceptor.java:89)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

    at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

    at org.jboss.as.ejb3.component.invocationmetrics.WaitTimeInterceptor.processInvocation(WaitTimeInterceptor.java:47)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

    at org.jboss.as.ejb3.security.SecurityContextInterceptor.processInvocation(SecurityContextInterceptor.java:100)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

    at org.jboss.as.ejb3.deployment.processors.StartupAwaitInterceptor.processInvocation(StartupAwaitInterceptor.java:22)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

    at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:64)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

    at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:67)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

    at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

    at org.jboss.invocation.ContextClassLoaderInterceptor.processInvocation(ContextClassLoaderInterceptor.java:60)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

    at org.jboss.invocation.InterceptorContext.run(InterceptorContext.java:438)

    at org.wildfly.security.manager.WildFlySecurityManager.doChecked(WildFlySecurityManager.java:618)

    at org.jboss.invocation.AccessCheckingInterceptor.processInvocation(AccessCheckingInterceptor.java:57)

    at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:422)

    at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:53)

    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.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:81)

    at com.banctec.caseware.server.cpc.CPCLocal$$$view87.login(Unknown Source)

    at com.banctec.caseware.client.api.API.login(API.java:470)

    ...

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:706)

    at javax.servlet.http.HttpServlet.service(HttpServlet.java:791)

    at io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)

    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)

    at com.banctec.caseware.components.common.WorkplaceFilter.doFilter(WorkplaceFilter.java:192)

    at io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)

    at io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)

    at io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)

    at io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)

    at io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)

    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:132)

    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 org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68)

    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 org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)

    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)

    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)

    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)

    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)

    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1502)

    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:360)

    at io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:830)

    at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)

    at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)

    at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)

    at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1378)

    at java.lang.Thread.run(Thread.java:748)

Caused by: javax.transaction.RollbackException: ARJUNA016053: Could not commit transaction.

    at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1300)

    at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:126)

    at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:89)

    at org.wildfly.transaction.client.LocalTransaction.commitAndDissociate(LocalTransaction.java:77)

    at org.wildfly.transaction.client.ContextTransactionManager.commit(ContextTransactionManager.java:71)

    at org.jboss.as.ejb3.tx.CMTTxInterceptor.endTransaction(CMTTxInterceptor.java:88)

    ... 93 more

    Suppressed: javax.transaction.RollbackException: WFTXN0061: Transaction is marked rollback-only

        at org.wildfly.transaction.client.AbstractTransaction.setRollbackOnly(AbstractTransaction.java:96)

        at org.wildfly.transaction.client.LocalTransaction.setRollbackOnly(LocalTransaction.java:149)

        at org.wildfly.transaction.client.ContextTransactionManager.setRollbackOnly(ContextTransactionManager.java:94)

        at org.hibernate.resource.transaction.backend.jta.internal.JtaTransactionAdapterTransactionManagerImpl.markRollbackOnly(JtaTransactionAdapterTransactionManagerImpl.java:100)

        at org.hibernate.resource.transaction.backend.jta.internal.JtaTransactionCoordinatorImpl$TransactionDriverControlImpl.markRollbackOnly(JtaTransactionCoordinatorImpl.java:456)

        at org.hibernate.engine.transaction.internal.TransactionImpl.markRollbackOnly(TransactionImpl.java:200)

        at org.hibernate.internal.AbstractSharedSessionContract.markForRollbackOnly(AbstractSharedSessionContract.java:378)

        at org.hibernate.internal.ExceptionConverterImpl.handlePersistenceException(ExceptionConverterImpl.java:297)

        at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:155)

        at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)

        at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)

        at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1460)

        at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:511)

        at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3283)

        at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2479)

        at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)

        at org.hibernate.resource.transaction.backend.jta.internal.JtaTransactionCoordinatorImpl.beforeCompletion(JtaTransactionCoordinatorImpl.java:352)

        at org.hibernate.resource.transaction.backend.jta.internal.synchronization.SynchronizationCallbackCoordinatorNonTrackingImpl.beforeCompletion(SynchronizationCallbackCoordinatorNonTrackingImpl.java:47)

        at org.hibernate.resource.transaction.backend.jta.internal.synchronization.RegisteredSynchronization.beforeCompletion(RegisteredSynchronization.java:37)

        at org.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:236)

        at org.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:247)

        at org.wildfly.transaction.client.AbstractTransaction$AssociatingSynchronization.beforeCompletion(AbstractTransaction.java:292)

        at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:76)

        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:360)

        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:91)

        at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)

        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1288)

        ... 98 more

    Suppressed: javax.transaction.RollbackException: WFTXN0061: Transaction is marked rollback-only

        at org.wildfly.transaction.client.AbstractTransaction.setRollbackOnly(AbstractTransaction.java:96)

        at org.wildfly.transaction.client.LocalTransaction.setRollbackOnly(LocalTransaction.java:149)

        at org.wildfly.transaction.client.ContextTransactionManager.setRollbackOnly(ContextTransactionManager.java:94)

        at org.hibernate.resource.transaction.backend.jta.internal.JtaTransactionAdapterTransactionManagerImpl.markRollbackOnly(JtaTransactionAdapterTransactionManagerImpl.java:100)

        at org.hibernate.resource.transaction.backend.jta.internal.JtaTransactionCoordinatorImpl$TransactionDriverControlImpl.markRollbackOnly(JtaTransactionCoordinatorImpl.java:456)

        at org.hibernate.resource.transaction.backend.jta.internal.JtaTransactionCoordinatorImpl.beforeCompletion(JtaTransactionCoordinatorImpl.java:359)

        at org.hibernate.resource.transaction.backend.jta.internal.synchronization.SynchronizationCallbackCoordinatorNonTrackingImpl.beforeCompletion(SynchronizationCallbackCoordinatorNonTrackingImpl.java:47)

        at org.hibernate.resource.transaction.backend.jta.internal.synchronization.RegisteredSynchronization.beforeCompletion(RegisteredSynchronization.java:37)

        at org.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:236)

        at org.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:247)

        at org.wildfly.transaction.client.AbstractTransaction$AssociatingSynchronization.beforeCompletion(AbstractTransaction.java:292)

        at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:76)

        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:360)

        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:91)

        at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)

        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1288)

        ... 98 more

Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute statement

    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:154)

    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:181)

    at org.hibernate.internal.ExceptionConverterImpl.convert(ExceptionConverterImpl.java:188)

    at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1460)

    at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:511)

    at org.hibernate.internal.SessionImpl.flushBeforeTransactionCompletion(SessionImpl.java:3283)

    at org.hibernate.internal.SessionImpl.beforeTransactionCompletion(SessionImpl.java:2479)

    at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.beforeTransactionCompletion(JdbcCoordinatorImpl.java:473)

    at org.hibernate.resource.transaction.backend.jta.internal.JtaTransactionCoordinatorImpl.beforeCompletion(JtaTransactionCoordinatorImpl.java:352)

    at org.hibernate.resource.transaction.backend.jta.internal.synchronization.SynchronizationCallbackCoordinatorNonTrackingImpl.beforeCompletion(SynchronizationCallbackCoordinatorNonTrackingImpl.java:47)

    at org.hibernate.resource.transaction.backend.jta.internal.synchronization.RegisteredSynchronization.beforeCompletion(RegisteredSynchronization.java:37)

    at org.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:236)

    at org.wildfly.transaction.client.AbstractTransaction.performConsumer(AbstractTransaction.java:247)

    at org.wildfly.transaction.client.AbstractTransaction$AssociatingSynchronization.beforeCompletion(AbstractTransaction.java:292)

    at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.beforeCompletion(SynchronizationImple.java:76)

    at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.beforeCompletion(TwoPhaseCoordinator.java:360)

    at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:91)

    at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:162)

    at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1288)

    ... 98 more

Caused by: org.hibernate.exception.GenericJDBCException: could not execute statement

    at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:47)

    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113)

    at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99)

    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:178)

    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3356)

    at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:3229)

    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3630)

    at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:146)

    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:604)

    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:478)

    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:356)

    at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:39)

    at org.hibernate.internal.SessionImpl.doFlush(SessionImpl.java:1454)

    ... 113 more

Caused by: java.sql.SQLException: (conn=360) XAER_RMFAIL: The command cannot be executed when global transaction is in the  IDLE state

    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:258)

    at org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:165)

    at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:238)

    at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:232)

    at org.mariadb.jdbc.MariaDbPreparedStatementClient.execute(MariaDbPreparedStatementClient.java:159)

    at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeUpdate(MariaDbPreparedStatementClient.java:194)

    at org.jboss.jca.adapters.jdbc.CachedPreparedStatement.executeUpdate(CachedPreparedStatement.java:121)

    at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeUpdate(WrappedPreparedStatement.java:537)

    at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:175)

    ... 122 more

Caused by: java.sql.SQLException: XAER_RMFAIL: The command cannot be executed when global transaction is in the  IDLE state

Query is: update CW_USER_POLICY set DATA=?, PWD_EXPIRED=?, FAILED_LOGINS=?, LAST_LOGIN=?, LAST_PWD_CHANGE=?, LOCKED=? where USER_NAME=?, parameters [<bytearray:<?xml version="1.0" encoding="UTF-8"?><UserPolicy xv="2.0" userName="efpadmin" locked="false" expired="false" failedLogins="0" passwordNeverExpires="false"/>>,'N',0,'2018-12-10 14:47:02.355','2018-11-28 07:51:59.0','N','efpadmin']

java thread: default task-2

    at org.mariadb.jdbc.internal.util.LogQueryTool.exceptionWithQuery(LogQueryTool.java:163)

    at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:280)

    at org.mariadb.jdbc.MariaDbPreparedStatementClient.executeInternal(MariaDbPreparedStatementClient.java:223)

    ... 127 more

The issue only started with the Wildfly 15 CR1 snapshot #566 from the 30th of November. The previous build ##565 did not have such issues (nor does the Wildfly 14.0.1 release) and this works fine with Oracle & MariaDB.

Could this be due to the following change? Update WildFlyCustomJtaPlatform#locateTransactionSynchronizationRegistry to use a direct reference to the TransactionSyn…

Let me know if you have any information on this error and whether there are any Wildfly configuration options to overcome this error.

Thanks in advance,

Alban

[marcanthony]

Hi Alban

I have hit the same problem, migrated from Wildfly 10.0.0. to 15.0.0, using MySQL, same error, similar situation, cdi managed bean that invokes 2 EJBs that use different persistent units. I dont seem to have the problem in 14.0.1 either.

Another error that has surfaced is this (apologies for the weird formatting but struggled to define a simple type-up without cluttering)

"javax.persistence.TransactionRequiredException: no transaction is in progress"

Managed bean with injected ejb (with datasource2) and injected entitymanager for datasource1, code is nested as follows

Managed bean method save @Transactional(value = TxType.REQUIRED)

{

          ejb save  @TransactionAttribute(TransactionAttributeType.MANDATORY)

          {

                         persist

                         flush

          }

          find with lock => LockModeType.PESSIMISTIC_WRITE        at this point the "no transaction is in progress" exception is fired 

}

Did notice that error does not occur if the invocation is purely ejb rather that cdi managed bean                    

Can anyone shed some light on this

Thanks

Marc 

[alban5650]

Hi Marc,

The issue is more severe than what I thought. I also have issues with other databases like Oracle but at different part/logic of our application.

Our application has been around for a while (although refactored heavily throughout the years) and has been running fine since Jboss 3.x to Jboss 7 and all the Wildfly 8 to 14.0.1 (including EAP versions) as well as other Application Servers (Weblogic 12, Websphere).

It only started failing from the 30th of November build which was the last nightly build before the final 15 release. I like to work with beta/RC releases as I find it easier to make incremental changes than jumping between a number of versions.

I will have to put a simple case together to replicate the way our application works but this might take some time. I will remove support for Wildfly 15 for now until I managed to get this sorted.

I do have an EAP support subscription with Redhat but I don't think I can raise issues for the community version. I'd rather get those issues resolved before the next EAP is released though!

[marcanthony]

Hi Alban

Same here, I updated my original message to include a different scenarion which is also firing an exception, our application has run fine from wildfly 8. 9 and 10, finally had some time scheduled for upgrade to 15 and application doesn't like it at all!

[mayerw01]

It looks like this is an issue with the XA support of your database version (MySQL Bugs: #17343: XAConnection doesn't allow second XA START )

Did you try to upgrade your MariaDB/MySql?

[alban5650]

Hi Wolfgang,

I have setup the latest available MariaDB database 10.3.

Note that the same EAR application works fine with Wildfly 10.x to 14.0.1 (up to 15 CR1 build #565) running against the same database server.

Changing the persistence.xml to use a non XA datasource seems to get me further but have more issues down the line.

I also have issues with the transaction and JPA with other database vendor like Oracle starting from the final Wildfly 15 build.

[marcanthony]

Hi Wolfgang

Thank you for the reply, unfortunately I am not in the position to update the db at the moment but as Alban stated everything worked fine until previous final release. Is this related to the Update WildFlyCustomJtaPlatform#locateTransactionSynchronizationRegistry to use a direct reference to the TransactionSyn…

in your opinion?

As this appears to be a potential performance tweak not a bug fix

Thanks

Marc

[alban5650]

I can confirm that my issue(s) were caused by the following change: https://github.com/wildfly/wildfly/pull/11784/

I downloaded the source code from Github, reverted this single change, recompiled Wildfly 15 final and my various issues with transactions & hibernate persistence (whether with MariaDB or Oracle, somehow SQLServer was not affected using the jTDS JDBC driver) are all gone:

Not sure how to get the attention of the developer(s) though! I probably still need to put a proper test case together and raise a JIRA for it.

[marcanthony]

I am sure there are going to be lots of other users with the same issue someone will look into it soon, i hope...

[jaikiran]

Could one of you create a JIRA for this here - JBoss Issue Tracker  please and add relevant details and point to this thread?

[alban5650]

Thanks Jaikiran.

Do you think adding a comment in the GitHub pull request or the existing JIRA [WFLY-11243] Update WildFlyCustomJtaPlatform#locateTransactionSynchronizationRegistry to use a direct reference to the T…  could help for now?

I am busy with a new release of our own application but will try to put a testcase together once I am done and managed to get a bit of free time.

Wildfly 15 is no longer an option for us as it has already been released but I will hopefully be able to create a JIRA for this before the next Wildfly and EAP release.

[jaikiran]

alban5650  wrote:

Thanks Jaikiran.

Do you think adding a comment in the GitHub pull request or the existing JIRA [WFLY-11243] Update WildFlyCustomJtaPlatform#locateTransactionSynchronizationRegistry to use a direct reference to the T…  could help for now?

Probably. Typically a closed issue isn't reopened (at least that was the workflow a few years back) and instead a new one is created with the details. But adding a comment to this existing one can get some attention to this discussion, from people who are familiar with this area of code.

[simkam]

alban5650 Can you please post some details about your configuration - standalone.xml file (or at least datasource configuration snippet), server.log, persistence.xml?

marcanthony I believe that "javax.persistence.TransactionRequiredException: no transaction is in progress" is caused by Hibernate upgrade between WildFly 10 and WildFly 15. There is a lot of hibernate configuration properties helping with backward compatibility, please refer to Hibernate migration guides. There is another forum post for "no transaction is in progress" error: WildFly 14 + Hibernate 5.3.6 - no transaction is in progress. It is probably unrelated to the MariaDB persistence issue at the beginning of this thread.

[smarlow]

Does the "XAER_RMFAIL: The command cannot be executed when global transaction is in the  IDLE state" failure occur with a single active thread (e.g. single user accessing the system)?

Or does the problem only occur under load?

Also, since you have modified the WildFly code (reverted a git commit and rebuilt), would you be able to try a modification of the original change, to help determine the likely cause?  If yes, I will come up with a code change to help determine the cause.

Scott

[alban5650]

Hi Scott.

The error occurs with a single active thread (a single user trying to login to our application).

I'm happy to revert back to the official Wildfly 15 Final source code, apply your code change and rebuild/test.

Please note that I'm off work until the New Year but can try to do this one evening. The Wildfly build process takes about 45 mins on my old laptop (skipping all maven tests) but once built, the test is very quick.