Bug #101552 xa recover and not found xa in the slave
| Submitted: | 11 Nov 2020 3:57 | Modified: | 16 Dec 2020 14:08 |
|---|---|---|---|
| Reporter: | weifan tian | Email Updates: | |
| Status: | No Feedback | Impact on me: | |
| Category: | MySQL Server: XA transactions | Severity: | S3 (Non-critical) |
| Version: | 5.7 | OS: | Debian |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
[16 Nov 2020 14:08]
MySQL Verification Team
Hi, I'm running this on 5.7.32 today for many hours without being able to reproduce the problem. Few questions - can you share config on the both master and slave? - in description you mentioned multisource replication but in your explanation how to reproduce you are mentioning master-slave only? - what version of mysql are you using? - you wrote "Over time in the slave wo can find:" - can you please explain what you mean here by "wo". Thanks Bogdan
[17 Dec 2020 1:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.039 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.
Description: when use Multi-source replication, one of slave is rep from secondary and master the same time(gtid is enabled) ,in the master database ,start a transaction , end the transaction , prepare the transaction and commit the transaction,but sometime we can find the trx_mysql_thread_id is 0 in the processlist, but No any xa was found When executing the XA recover command How to repeat: >connect client to master server Loop through the following script for ((i=1;i<=100000000;i=i+1)) do xa='xatest'$i /usr/bin/mysql xa_test -e "xa start '${xa}';insert into xa_test(name) values('${xa}');xa end '${xa}';xa PREPARE '${xa}';select sleep(0.2);xa commit '${xa}';" done Over time in the slave wo can find: trx_mysql_thread_id is 0 in the processlist, but No any xa was found When executing the XA recover command ,But in the slave library binlog,We can see the complete XA transaction