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

Adding constraint on InnoDB-Table locks whole database, although an index for that constraint already exists

    XMLWordPrintable

Details

    Description

      We are running a Galera-Cluster with 3 Nodes.

      Someone accidently deleted all foreign-keys of a table. The corresponding Index-Entries remained.

      Because the Index-Entry did exist we assumed that we can alter the table to add one of the missing foreign-keys using "total order isolation" without a global lock.

      But the database was locked for hours. It would be nice, if creation of foreign-keys would not block the whole database when an corresponding index already exists.

      Attachments

        Activity

          People

            nirbhay_c Nirbhay Choubey (Inactive)
            UweB Uwe Beierlein
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.