MODE IX lock when merging spills during index builds can block stepdowns and DDL operations

XMLWordPrintableJSON

    • Storage Execution
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      If we issue a DDL when we build an index and are performing many merge spills, we can block operations. This is because we still hold onto the MODE IX lock when we are merging spills. The DDL will then queue MODE X lock, which can then lead to all operations hanging.

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

              Created:
              Updated: