3394
MySQLERRORNotableReplicationHIGH confidence
XA transactions are incompatible with replication filters
Production Risk
High — XA transactions fail; distributed transaction integrity may be compromised.
How to reproduce
trigger — this will error
trigger — this will error
-- XA transaction referencing a filtered database.
expected output
ERROR 3394 (HY000): XA transactions are not supported with replication filters.
Fix
Use row-based replication filtering instead
Use row-based replication filtering instead
-- Use replicate_wild_do_table or replicate_wild_ignore_table instead of database-level filters.
Why this works
Table-level filters are compatible with XA transactions.
What not to do
✕
Sources
Official documentation ↗
MySQL 8.0 — 3394 ER_XA_REPLICATION_FILTERS
Content generated with AI assistance and reviewed for accuracy. Found an error? hello@errcodes.dev