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

SKIP LOCKED should skip table level locked

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • None
    • N/A
    • Locking
    • None

    Description

      A thread doing table level locking - LOCK TABLES or ALTER TABLES and if another thread is doing SELECT ... SKIP LOCKED then these entire tables should be skipped.

      Attachments

        Issue Links

          relates to

          Task - A task that needs to be done. MDEV-13115 Implement SELECT [FOR UPDATE|LOCK IN SHARED MODE] SKIP LOCKED

          • Major - Major loss of function.
          • Closed

          Activity

            Ascending order - Click to sort in descending order
            danblack Daniel Black added a comment -

            Asked for user feedback in MDEV-13115.

            danblack Daniel Black added a comment - Asked for user feedback in MDEV-13115 .
            danblack Daniel Black added a comment -

            current behaviour matches MySQL, table level locks are still locks and SKIPPED LOCKED will still lockwait on a table level lock. Please state the case if you think a different behaviour is better.

            danblack Daniel Black added a comment - current behaviour matches MySQL, table level locks are still locks and SKIPPED LOCKED will still lockwait on a table level lock. Please state the case if you think a different behaviour is better.

            People

              danblack Daniel Black
              danblack Daniel Black
              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.