Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-27547

Galera node INCONSISTENT state on DELETE with FKs having wsrep_slave_threads > 1

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.5.6
    • N/A
    • Galera
    • 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

          Activity

            People

              jplindst Jan Lindström (Inactive)
              aponzo Andrea Ponzo (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.