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

ALTER TABLE ... IMPORT/DISCARD TABLESPACE under LOCK TABLES doesn't acquire X metadata lock

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Won't Fix
        • Affects Version/s: 10.0.17, 10.1.3
        • Fix Version/s: 10.1.5
        • Component/s: Locking
        • Labels:
          None

          Description

          This problem was fixed along with MySQL WL#6671 "Improve scalability by not using thr_lock.c locks for InnoDB tables".

          Due to coding mistake thr_lock.c lock was necessary to isolate ALTER TABLE
          IMPORT/DISCARD TABLESPACE under LOCK TABLES from concurrent I_S queries/
          open HANDLERs.

          Change ALTER TABLE IMPORT/DISCARD TABLESPACE code to acquire X
          lock on table being imported/discarded even under lock tables.

            Gliffy Diagrams

              Attachments

                Issue Links

                is part of

                Task - A task that needs to be done. MDEV-7660 MySQL WL#6671 "Improve scalability by not using thr_lock.c locks for InnoDB tables"

                • Major - Major loss of function.
                • Open

                  Activity

                  Ascending order - Click to sort in descending order
                  Hide
                  Permalink
                  svoj Sergey Vojtovich added a comment -

                  Sergei, please review fix for this bug.

                  Show
                  svoj Sergey Vojtovich added a comment - Sergei, please review fix for this bug.
                  Hide
                  Permalink
                  serg Sergei Golubchik added a comment -

                  This task is not relevant anymore since we don't plan to apply MySQL WL#6671 "Improve scalability by not using thr_lock.c locks for InnoDB tables".

                  The aim is to fix it in InnoDB instead of fixing it in MDL.

                  Show
                  serg Sergei Golubchik added a comment - This task is not relevant anymore since we don't plan to apply MySQL WL#6671 "Improve scalability by not using thr_lock.c locks for InnoDB tables". The aim is to fix it in InnoDB instead of fixing it in MDL.

                    People

                    • Assignee:
                      serg Sergei Golubchik
                      Reporter:
                      svoj Sergey Vojtovich
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: