We encountered node inconsistency issue in one of our Galera cluster. After checking, the problem is related to CTAS "Create Table As Select" DDL. We have Galera transaction fragment in the case.
A simple test case is prepared and no issue when transaction fragment is disabled.
We need transaction fragment enabled since vendor application need to run a large transaction (>2GB).
Test case is attached: galera-transation-fragment-ctas-ddl-inconsistent.txt
DB error log about the inconsistency: galera-transation-fragment-ctas-ddl-inconsistent.mysqld.node2.log