Issue with XA_RECOVER_ADMIN privilege
I am trying to install Bonitasoft 7.11 on an AWS EC2 instance with the MySQL 8 database on RDS. I have created a user xxx@% and granted the
XA_RECOVER_ADMIN privileges as stated in the documentation
GRANT XA_RECOVER_ADMIN ON *.* TO 'xxx'@'%' with grant option;
After I have installed my BDM, I am receiving the below error when I try to resume the services
(http-nio-8080-exec-9) com.arjuna.ats.jta ARJUNA016045: attempted rollback of < formatId=131077, gtrid_length=29, bqual_length=36, tx_uid=0:ffffac1f2107:9851:5f484e8b:4b7, node_name=1, branch_uid=0:ffffac1f2107:9851:5f484e8b:4bc, subordinatenodename=null, eis_name=0 > (com.mysql.cj.jdbc.MysqlXAConnection@7ee23949) failed with exception code XAException.XAER_RMFAIL
com.mysql.cj.jdbc.MysqlXAException: Undetermined error occurred in the underlying Connection - check your data for consistency
If I install MySQL 8 on the EC2 itself, the xxx@localhost with the same steps is working as expected.
Any guidance on how to resolve this issue will be highly appreciated.