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

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

Details

    • Bug
    • Status: Closed (View Workflow)
    • Minor
    • Resolution: Won't Fix
    • 10.0.17, 10.1.3
    • 10.1.4
    • Locking
    • 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.

      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"

          • Blocker - Blocks development and/or testing work, production could not run.
          • Closed

          Activity

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

            Sergei, please review fix for this bug.

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

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

            serg Sergei Golubchik added a comment - probably not relevant anymore. should be resurrected if we'll decide that it's still needed
            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.

            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

              svoj Sergey Vojtovich
              svoj Sergey Vojtovich
              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.