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

HANDLER READ doesn't upgrade metadata lock from S to SR

        Details

        • Type: Bug
        • Status: Closed
        • Priority: Minor
        • Resolution: Won't Fix
        • Affects Version/s: 10.0.17, 10.1.3
        • Fix Version/s: 10.1.4
        • 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".

          Change code for HANDLER READ statements to upgrade S metadata lock to
          SR metadata lock for the duration of read. This allows us properly
          isolate HANDLER READ from LOCK TABLES WRITE and makes metadata locking
          for these statements consistent with locking for other DML.

            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 -

                  probably not relevant anymore. should be resurrected if we'll decide that it's still needed

                  Show
                  serg Sergei Golubchik added a comment - probably not relevant anymore. should be resurrected if we'll decide that it's still needed
                  Hide
                  Permalink
                  svoj Sergey Vojtovich 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
                  svoj Sergey Vojtovich 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:
                      svoj Sergey Vojtovich
                      Reporter:
                      svoj Sergey Vojtovich
                    • Votes:
                      0 Vote for this issue
                      Watchers:
                      2 Start watching this issue

                      Dates

                      • Created:
                        Updated:
                        Resolved: