Issue cloned from the community forum for tracking.

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.

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)

Unknown macro: { 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