[CD15] EJB transactional method unable to commit when invoked from CDI bean with MariaDB

Issue cloned from the community forum for tracking.

This regression affects MariaDB which is one of the OpenShift support targets, therefore marking this as blocker.

cc bozpeyni@redhat.com, kkhan1@redhat.com, smarlow@redhat.com

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