Improve yielding during the scanning collection phase of index builds

XMLWordPrintableJSON

    • Type: Improvement
    • Resolution: Duplicate
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Storage Execution
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      In the case that we are sorting or spilling during the scanning collection phase of an index yield, we may not yield to DDLs that get sent during this phase. This can lead to operations being blocked because we are queueing up a MODE X lock from the DDLs behind the MODE IX lock from scanning collections during the index build.

            Assignee:
            Unassigned
            Reporter:
            Stephanie Eristoff
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: