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

Ensure update to config.collections in createCollection coordinator uses an index scan

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 7.2.0-rc0
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Fully Compatible
    • ALL
    • Sharding EMEA 2023-10-16
    • 135

      The changes in SERVER-79157 changed the insert into config.collections as part of the create collection coordinator commit to an update. However, the update query is using only the uuid field. Since there is no index on config.collections for the uuid, this is resulting in a collection scan in order to do this update.

      We should change this update query to include the _id field so that this query can be done using an index scan rather than a collection scan.

            Assignee:
            allison.easton@mongodb.com Allison Easton
            Reporter:
            allison.easton@mongodb.com Allison Easton
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: