后端节点Mysql8.0 时，dble启动出现 'xa recover' 报错

[Dinosauria]

观察dble日志，找到Mysql端响应XA RECOVER语句结果，报错日志位置：

2022-05-31 14:18:52.964  INFO [8-complexQueryWorker] (com.actiontech.dble.sqlengine.SQLJob.errorResponse(SQLJob.java:144)) - error response errNo:1401, XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency from of sql :/*#timestamp=1653977932963 from=1 reason=sql job*/XA RECOVER at con:MySQLResponseService[isExecuting = false attachment = null autocommitSynced = true isolationSynced = true xaStatus = 0 isDDL = false complexQuery = true] with response handler [SQLJob [shardingNode=null,schema=null,sql=/*#timestamp=1653977932963 from=1 reason=sql job*/XA RECOVER,  jobHandler=com.actiontech.dble.sqlengine.MultiRowSQLQueryResultHandler@1a1a7cc5]] with rrs = [null]  with connection BackendConnection[id = 4 host = 192.168.4.148 port = 3307 localPort = 38964 mysqlId = 2029585 db config = dbInstance[name=instanceM1,disabled=false,maxCon=1000,minCon=20]
2022-05-31 14:18:52.964  WARN [8-complexQueryWorker] (com.actiontech.dble.backend.mysql.nio.handler.transaction.xa.XAHandler$XARecover.onResult(XAHandler.java:164)) - execute 'XA RECOVER' in dbInstance[name=instanceM1,disabled=false,maxCon=1000,minCon=20] error!

为什么报错？怎么解决？

[wenyh1]

根据上面的日志看，dble下发语句xa recover至MySQL ,MySQL响应报错：1401, XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency

报错原因：
后端节点Mysql版为8.0；在Mysql8.0中，执行XA RECOVER的用户需要拥有 XA _ RECOVER _ ADMIN 特权；否则报错 1401 ...
具体见：XA_RECOVER_ADMIN

解决方案：
db.xml中配置的后端MySQL用户 需要赋予 XA_RECOVER_ADMIN 权限，比如：

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

重启dble 或者 刷新连接池生效。

[PanternBao]

此功能暂无法关闭。