I am getting a
WSREP detected deadlock/conflict and aborted the transaction. error when running a DML like:
INSERT INTO `reporting__sales`( ... ) SELECT ... FROM ... LEFT JOIN ... LEFT JOIN ... WHERE ... ON DUPLICATE KEY UPDATE ...
It is a single DML and there is no other process using that table, so I’m somewhat confused about how this can be happening.
Any ideas about this?