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

        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.

            Gliffy Diagrams

              Attachments

                Activity

                There are no comments yet on this issue.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    UweB Uwe Beierlein
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    1 Start watching this issue

                    Dates

                    • Created:
                      Updated: