Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-59399

Allow dropping an index during separate index build on the same collection

    • Type: Icon: Improvement Improvement
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 5.2.0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Fully Compatible
    • Execution Team 2021-10-18, Execution Team 2021-11-15, Execution Team 2021-11-29
    • 183

      According to my understanding, it's currently not possible to drop an index on a collection at the same time that a separate index is in the process of being built on the same collection. As of SERVER-32033 you can call dropIndex on the in-progress index and the build will be cancelled, but if you try to drop a different already built index you'll get a BackgroundOperationInProgressForNamespace error. I'm guessing this comes from this check here.

      I think this behavior is confusing (why should building index A interfere with dropping index B?) and makes it more difficult to manage indexes.

            Assignee:
            gregory.wlodarek@mongodb.com Gregory Wlodarek
            Reporter:
            daniel.ernst@mongodb.com Daniel Ernst
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: