Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
10.5.6
-
None
-
CentOS Linux release 7.9.2009 (Core)
Description
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;
|
Attachments
Issue Links
- relates to
-
MDEV-26803 Galera crash - Assertion. Possible parallel writeset problem
- Closed