MySQL Forums
Forum List  »  Replication

Replicating just one database, "The use of replication filters with XA transactions is not supported" error
Posted by: Daniel Lo Nigro
Date: July 07, 2019 03:34PM

I have a master that contains a dozen or so databases, and want to replicate just one of them to another server.

I've configured both servers as per these pages in the docs:
17.1.2 Setting Up Binary Log File Position Based Replication
17.3.6 Replicating Different Databases to Different Slaves

However, I get this error in the slave's log:

2019-07-07T20:56:09.157115Z 5 [ERROR] [MY-013175] [Repl] Slave SQL for channel '': Error in Xid_log_event: Commit could not be completed, 'The use of replication filters with XA transactions is not supported, and can lead to an undefined state in the replication slave.', Error_code: MY-013175
2019-07-07T20:56:09.157130Z 5 [Warning] [MY-010584] [Repl] Slave: The use of replication filters with XA transactions is not supported, and can lead to an undefined state in the replication slave. Error_code: MY-013175
2019-07-07T20:56:09.157141Z 5 [ERROR] [MY-010586] [Repl] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'binlog.000007' position 28430722

None of my code is using "XA transactions" directly, however it seems like newer versions of InnoDB do not allow this functionality to be disabled.

I've tried both the "replicate_do_db" setting and the "replicate_wild_do_table" setting, neither of which worked properly.

How can I configure replication the way that I want - Only replicating one database?

Options: ReplyQuote


Subject
Views
Written By
Posted
Replicating just one database, "The use of replication filters with XA transactions is not supported" error
1606
July 07, 2019 03:34PM


Sorry, you can't reply to this topic. It has been closed.

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.