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

Disabling FK and UK checks on appliers may lead to deadlock

Details

    Description

      If both FK and UK checks are disabled on appliers, and there's at least two appliers, and they both execute INSERT statements into the same table, it happens that such inserts are treated as bulk inserts in InnoDB and the first insert grabs an X-lock on a table. The other applier with similar INSERT statement has to wait, but if the lock holder has seqno higher than the waiter, then it will deadlock in Galera waiting on the earlier applier to commit, while that earlier applier is waiting for InnoDB table lock to be released.

      Attachments

        Issue Links

          Activity

            denis.protivensky Denis Protivensky created issue -
            denis.protivensky Denis Protivensky made changes -
            Field Original Value New Value
            denis.protivensky Denis Protivensky made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            denis.protivensky Denis Protivensky made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            denis.protivensky Denis Protivensky made changes -
            Assignee Denis Protivensky [ JIRAUSER52676 ] Julius Goryavsky [ sysprg ]
            denis.protivensky Denis Protivensky made changes -
            Status Stalled [ 10000 ] In Testing [ 10301 ]
            sysprg Julius Goryavsky made changes -
            Status In Testing [ 10301 ] Stalled [ 10000 ]
            sysprg Julius Goryavsky made changes -
            Fix Version/s 10.6.22 [ 29997 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            JIraAutomate JiraAutomate made changes -
            Fix Version/s 10.11.12 [ 29998 ]
            Fix Version/s 11.4.6 [ 29999 ]
            Fix Version/s 11.8.2 [ 30001 ]

            People

              sysprg Julius Goryavsky
              denis.protivensky Denis Protivensky
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.