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

node hang due to conflicting inserts into foreign key child table

Details

    Description

      Cluster node may enter in unresolved conflict state when there are two inserts, with same primary key, into a table which has foreign key constraint for a parent table. These inserts must be issued in separate cluster nodes, and there has to be simultaneous writes (updates or deletes), for the referenced parent row.
      As a result of such scenario, replication applier thread may end in unresolved conflict state, And error log will be filled by messages of type:

      "WSREP: BF lock wait long"

      followed by InnoDB monitor outputs

      Attachments

        Issue Links

          Activity

            seppo Seppo Jaakola created issue -
            seppo Seppo Jaakola made changes -
            Field Original Value New Value
            Status Open [ 1 ] In Progress [ 3 ]
            seppo Seppo Jaakola made changes -
            Assignee Seppo Jaakola [ seppo ] Marko Mäkelä [ marko ]
            Status In Progress [ 3 ] In Review [ 10002 ]
            marko Marko Mäkelä made changes -
            Assignee Marko Mäkelä [ marko ] Seppo Jaakola [ seppo ]
            Status In Review [ 10002 ] Stalled [ 10000 ]
            marko Marko Mäkelä made changes -
            Assignee Seppo Jaakola [ seppo ] Thirunarayanan B [ thiru ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            serg Sergei Golubchik made changes -
            Component/s Storage Engine - InnoDB [ 10129 ]
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            marko Marko Mäkelä made changes -
            issue.field.resolutiondate 2019-01-15 08:14:26.0 2019-01-15 08:14:26.926
            marko Marko Mäkelä made changes -
            Fix Version/s 10.2.19 [ 23207 ]
            Fix Version/s 10.3.11 [ 23141 ]
            Fix Version/s 10.2 [ 14601 ]
            Fix Version/s 10.3 [ 22126 ]
            Assignee Thirunarayanan Balathandayuthapani [ thiru ] Marko Mäkelä [ marko ]
            Resolution Duplicate [ 3 ]
            Status Stalled [ 10000 ] Closed [ 6 ]
            serg Sergei Golubchik made changes -
            Workflow MariaDB v3 [ 88248 ] MariaDB v4 [ 154626 ]

            People

              marko Marko Mäkelä
              seppo Seppo Jaakola
              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.