]
Marc Anthony Puca edited comment on WFLY-11543 at 12/20/18 5:02 PM:
--------------------------------------------------------------------
Added the server.log with trace for org.wildfly.transaction.client, com.arjuna and
org.jboss.as.txn when the issue occurs logs.zip contains 2 files one for each scenario (no
transaction and transaction idle)
was (Author: marcanthony):
Added the server.log with trace for org.wildfly.transaction.client, com.arjuna and
org.jboss.as.txn when the issue occurs logs.zip contains 2 files once for each scenario
EJB transactional method unable to commit when invoked from CDI bean
with MariaDB
---------------------------------------------------------------------------------
Key: WFLY-11543
URL:
https://issues.jboss.org/browse/WFLY-11543
Project: WildFly
Issue Type: Bug
Components: JPA / Hibernate
Affects Versions: 15.0.0.Final
Environment: WildFly 15.0.0.Final
MariaDB 10.1.19
Reporter: Michal Jurc
Assignee: Scott Marlow
Priority: Blocker
Attachments: logs.zip, server-trace.zip
Issue cloned from the [community
forum|https://developer.jboss.org/thread/279303] for
tracking.
{quote}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.{quote}
{quote}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 {quote}