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

Implement SELECT [FOR UPDATE|LOCK IN SHARED MODE] SKIP LOCKED

Details

    Attachments

      Issue Links

        causes

        Bug - A problem which impairs or prevents the functions of the product. MDEV-25433 SKIP LOCKED should imply NOWAIT

        • Critical - Crashes, loss of data, severe memory leak.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. MDEV-31236 Assertion `prebuilt->select_lock_type == LOCK_NONE || (index)->is_spatial()' failed in row_search_mvcc

        • Major - Major loss of function.
        • Stalled
        relates to

        Task - A task that needs to be done. MDEV-25338 add SKIP LOCKED to UPDATE syntax

        • Major - Major loss of function.
        • Open

        Bug - A problem which impairs or prevents the functions of the product. MDEV-25388 SKIP LOCKED should skip table level locked

        • Major - Major loss of function.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. MDEV-27999 select~for update skip locked locks unnecessary record

        • Critical - Crashes, loss of data, severe memory leak.
        • Closed

        Bug - A problem which impairs or prevents the functions of the product. MDEV-11481 MariaRocks port: rocksdb.select_for_update_skip_locked_nowait (DISABLED)

        • Minor - Minor loss of function, or other problem where easy workaround is present.
        • Open

        Task - A task that needs to be done. MDEV-19986 MyRocks: Range Locking: SeekForUpdate support

        • Major - Major loss of function.
        • Open

        Task - A task that needs to be done. MDEV-33455 skip modified rows in parallel XA replication, don't wait

        • Critical - Crashes, loss of data, severe memory leak.
        • Open

        Activity

          Ascending order - Click to sort in descending order
          Nothing4You Richard Schwab created issue -
          serg Sergei Golubchik made changes -
          Field Original Value New Value
          fsantulli Federico Santulli made changes -
          Attachment mariadb_10.5.8_skip_locked.patch [ 55600 ]
          fsantulli Federico Santulli made changes -
          Attachment mariadb_10.5.8_skip_locked.patch [ 55600 ]
          fsantulli Federico Santulli made changes -
          Attachment mariadb_10.5.8_skip_locked.patch [ 55601 ]
          danblack Daniel Black made changes -
          Assignee Daniel Black [ danblack ]
          danblack Daniel Black made changes -
          Fix Version/s 10.6 [ 24028 ]
          danblack Daniel Black made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          julien.fritsch Julien Fritsch made changes -
          Fix Version/s 10.6 [ 24028 ]
          danblack Daniel Black made changes -
          Summary Implement FOR UPDATE SKIP LOCKED / NOWAIT Implement FOR UPDATE SKIP LOCKED
          danblack Daniel Black made changes -
          Fix Version/s 10.6 [ 24028 ]
          danblack Daniel Black made changes -
          Assignee Daniel Black [ danblack ] Sergei Golubchik [ serg ]
          Status In Progress [ 3 ] In Review [ 10002 ]
          danblack Daniel Black made changes -
          Assignee Sergei Golubchik [ serg ] Michael Widenius [ monty ]
          olafbuitelaar Olaf Buitelaar made changes -
          danblack Daniel Black made changes -
          Component/s Server [ 13907 ]
          Component/s Storage Engine - InnoDB [ 10129 ]
          Fix Version/s 10.6.0 [ 24431 ]
          Fix Version/s 10.6 [ 24028 ]
          Assignee Michael Widenius [ monty ] Daniel Black [ danblack ]
          Resolution Fixed [ 1 ]
          Status In Review [ 10002 ] Closed [ 6 ]
          danblack Daniel Black made changes -
          Summary Implement FOR UPDATE SKIP LOCKED Implement SELECT [FOR UPDATE|LOCK IN SHARED MODE] SKIP LOCKED
          danblack Daniel Black made changes -
          danblack Daniel Black made changes -
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 81279 ] MariaDB v4 [ 133293 ]
          ralf.gebhardt Ralf Gebhardt made changes -
          danblack Daniel Black made changes -
          marko Marko Mäkelä made changes -
          marko Marko Mäkelä made changes -
          mariadb-jira-automation Jira Automation (IT) made changes -
          Zendesk Related Tickets 103700 185397

          People

            danblack Daniel Black
            Nothing4You Richard Schwab
            Votes:
            26 Vote for this issue
            Watchers:
            34 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.