Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-5473

Mutex lock contention doing VSS lookup loading a block

Details

    • 2024-1, 2024-2

    Description

      A shared mutex contention in VSS lookup becomes visible after MCOL-5472 is resolved.
      Version Substitution Structure is a structure that gives PrimProc the actual version of a block if there is any DML operation in progress. Any block scan operations looks for a block using blocks' LBID before it reads the block from a persistent storage. VSS is node significant.
      The suggested solution is to horizontally scale VSS cache having multiple caches. hash(LBID) mod number_of_caches can be used to deterministically pick a cache from the list.

      Attachments

        Issue Links

          is part of

          Bug - A problem which impairs or prevents the functions of the product. MCOL-5460 concurrent CTE operation excessive mutex

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

          Activity

            Ascending order - Click to sort in descending order
            drrtuy Roman created issue -
            drrtuy Roman made changes -
            Field Original Value New Value
            drrtuy Roman made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            toddstoffel Todd Stoffel (Inactive) made changes -
            Rank Ranked higher
            toddstoffel Todd Stoffel (Inactive) made changes -
            Fix Version/s 23.08 [ 28540 ]
            Fix Version/s 23.02 [ 28209 ]
            alexey.vorovich alexey vorovich (Inactive) made changes -
            Labels rm_perf
            JIraAutomate JiraAutomate added a comment -

            Automated message:
            ----------------------------
            Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.

            JIraAutomate JiraAutomate added a comment - Automated message: ---------------------------- Since this issue has not been updated since 6 weeks, it's time to move it back to Stalled.
            julien.fritsch Julien Fritsch made changes -
            Status In Progress [ 3 ] Stalled [ 10000 ]
            julien.fritsch Julien Fritsch made changes -
            Sprint 2024-1 [ 755 ]
            drrtuy Roman made changes -
            Issue Type Bug [ 1 ] New Feature [ 2 ]
            julien.fritsch Julien Fritsch made changes -
            Priority Blocker [ 1 ] Critical [ 2 ]
            julien.fritsch Julien Fritsch made changes -
            Sprint 2024-1 [ 755 ] 2024-1, 2024-2 [ 755, 764 ]
            julien.fritsch Julien Fritsch made changes -
            Labels rm_perf Concurrency rm_perf
            julien.fritsch Julien Fritsch made changes -
            Sprint 2024-1, 2024-2 [ 755, 764 ] 2024-1, 2024-2, 2024-3 [ 755, 764, 784 ]
            julien.fritsch Julien Fritsch made changes -
            Sprint 2024-1, 2024-2, 2025-1 [ 755, 764, 784 ] 2024-1, 2024-2 [ 755, 764 ]

            People

              drrtuy Roman
              drrtuy Roman
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.