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;
|
Bug
Major
