ARJUNA016027: Local XARecoveryModule.xaRecovery when upgrading to 25.0.2

Getting advice
,
1

Hi,
I am trying to upgrade from keycloak version 21.1.2 to 25.0.2.

I would like to keep using the MysqlXADataSource.

quarkus.transaction-manager.enable-recovery=true
quarkus.datasource.xxx.jdbc.transactions=xa
quarkus.datasource.xxx.db-kind=mysql
quarkus.datasource.xxx.jdbc.driver=com.mysql.cj.jdbc.MysqlXADataSource
quarkus.datasource.xxx.username=xxx
quarkus.datasource.xxx.password=xxx

quarkus.datasource.xxx.jdbc.url=jdbc:mysql://yyy:zzz/xxx
in the quarkus properties.

I have copied this in the /opt/keycloak/conf/ folder.

I have set up the following keycloak variables:

  KC_TRANSACTION_XA_ENABLED=true 
  KC_TRANSACTION_MODE=xa

But i am getting the following warning/error:

[com.arjuna.ats.jta] (Periodic Recovery) ARJUNA016027: Local XARecoveryModule.xaRecovery got XA exception XAException.XAER_RMERR: com.mysql.cj.jdbc.MysqlXAException: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency
	at com.mysql.cj.jdbc.MysqlXAConnection.mapXAExceptionFromSQLException(MysqlXAConnection.java:343)

To the databases i have set up the following privileges:

GRANT XA_RECOVER_ADMIN ON database.* TO 'username'@'%';
FLUSH PRIVILEGES;

Any idea on what other should i set up, so it works properly?

Thank you in advance