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

CREATE TABLE with FOREIGN KEY constraint fails to apply in parallel

    XMLWordPrintable

Details

    Description

      This issue was observed when testing the fix for MDEV-26803. There, in the test galera.galera_fk_cascade_delete, scenario 2, if the applier thread count in node 2 is raised to 2, before the test tables are created, it often happens that the table 'c' create applies in parallel with one of the 'p1' table inserts , and this fails with assertion.
      Reason for this appears to be that create table with FK constraints does not append the referenced table names as keys in the write set.

      Attachments

        Issue Links

          Activity

            People

              jplindst Jan Lindström (Inactive)
              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.