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

plan_cache_index_create.js should build initial index set in the foreground

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Fixed
    • Affects Version/s: 4.0.0-rc0
    • Fix Version/s: 3.6.9, 4.0.0, 4.1.1
    • Component/s: None
    • Labels:
      None
    • Backwards Compatibility:
      Fully Compatible
    • Backport Requested:
      v4.0, v3.6
    • Sprint:
      Query 2018-06-04
    • Linked BF Score:
      6

      Description

      Currently plan_cache_index_create.js starts with the creation of 2 baseline indexes using majority writeConcern and in the background. After creating we confirm that executing a find will generate a plan cache entry for the more optimal index. We run this test confirming both primary and secondary reads.

      When reading from the secondary, the majority writeConcern background createIndexes invocation will confirm that the index build has completed on the primary and started on the secondary. It does not guarantee that it will be completed and available for a subsequent secondary read. We should change this specific index build to a foreground build which will ensure that we are blocked from reading on the secondary until the index build has completed.

        Attachments

          Activity

            People

            Assignee:
            james.wahlin James Wahlin
            Reporter:
            james.wahlin James Wahlin
            Participants:
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: