load data splitting does not generate Xid event in master node

Question

load data splitting does not generate Xid event in master node

sjaakola opened this issue 4 years ago · 1 comments

If node is configured to use load data splitting (wsrep_load_data_splitting) and has binlogging enabled and LOAD DATA execution triggers sub transactions for 10K insert bacthes, then binlog file contains XId event only for the first and last batch of the LOAD DATA transaction. i.e. all intermediate transactions contains only write rows and commit events, but the Xid event with galera replication seqno is missing.

This problem is present in 5.7 version, in 8.0 and later, load data splitting is replaced by streaming replication.

Answer 1 · 2021-03-08T17:24:53.000Z

Fix is released in 5.7.32 version