xa模式事务无法提交

[xiabx]

• [ ] I have searched the issues of this repository and believe that this is not a duplicate.

Ⅰ. Issue Description

seata版本是1.5.1，使用xa模式时，mysql的xa事务无法提交，rm和tm也没报错。但是在mysql里看事务并没有提交成功，通过查innodb_trx表可以查到。XA RECOVER也可以查到。

这个问题在连5.7.38版本mysql时会出现，但是用8.0.29时候xa事务能正常提交。

Ⅱ. Describe what happened

If there is an exception, please attach the exception trace: rm和tm未报错

Just paste your stack trace here!

Ⅲ. Describe what you expected to happen

期望xa事务可以在5.7.38版本mysql可以正常提交。

Ⅳ. How to reproduce it (as minimally and precisely as possible)

https://gitee.com/helloxia/springboot-consul-seata.git

1. mysql使用5.7.38
2. 项目启动后访问: http://[localhost:9202/purchase/commit?userId=U1&commodityCode=C1&orderCount=1
3. 通过mysql命令XA RECOVER 查看事务是否提交

Ⅴ. Anything else we need to know?

Ⅵ. Environment:

• JDK version : 1.8
• Seata version: 1.5.1
• OS : windows
• Others: mysql 5.7.38

[funky-eyes]

麻烦模拟一次事务请求,把相关server端的日志和client端的日志都发一下

[funky-eyes]

已确认为手动代理和自动代理混用导致的bug,后续我们将修复此问题,目前先只是用其中一个方式来解决此问题