[#MDEV-27547] Galera node INCONSISTENT state on DELETE with FKs having wsrep_slave

Hello,
same issue as reported on previous MENT-1129 regarding the commit order removing data on 2 tables having Foreign keys.
The Customer is the same on a different region using the Version 10.5.

[ERROR] Slave SQL: Could not execute Delete_rows_v1 event on table webdb.tasks_task; Cannot delete or update a parent row: a foreign key constraint fails (`webdb`.

`tasks_task_parents`, CONSTRAINT `tasks_task_parents_to_task_id_ca5c9a5b_fk_tasks_task_id` FOREIGN KEY (`to_task_id`) REFERENCES `tasks_task` (`id`)), Error_code: 1451; handler error HA_

ERR_ROW_IS_REFERENCED; the event's master log FIRST, end_log_pos 1331, Internal MariaDB error code: 1451

2022-01-13 21:05:02 49 [Warning] WSREP: Event 3 Delete_rows_v1 apply failed: 152, seqno 4567748838

2022-01-13 21:05:02 0 [Note] WSREP: Member 1(lhr-dc1-qt-wdb9) initiates vote on e707c4af-317b-11ec-a095-6e2d4e1c370b:4567748838,d0d48f437229894c:  Cannot delete or update a parent row: a

 foreign key constraint fails (`webdb`.`tasks_task_parents`, CONSTRAINT `tasks_task_parents_to_task_id_ca5c9a5b_fk_tasks_task_id` FOREIGN KEY (`to_task_id`) REFERENCES `tasks_task` (`id`

)), Error_code: 1451;

[MDEV-27547] Galera node INCONSISTENT state on DELETE with FKs having wsrep_slave_threads > 1 Created: 2022-01-19 Updated: 2022-04-08 Resolved: 2022-04-08
Status:	Closed
Project:	MariaDB Server
Component/s:	Galera
Affects Version/s:	10.5.6
Fix Version/s:	N/A

[MDEV-27547] Galera node INCONSISTENT state on DELETE with FKs having wsrep_slave_threads > 1 Created: 2022-01-19 Updated: 2022-04-08 Resolved: 2022-04-08