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

Ensure SBE plan cache entry is dropped between prepare and open

    • Type: Icon: Improvement Improvement
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution

      In SERVER-87437, we modified the plan cache entry to be saved using the minValid time instead of collection version. One issue after this was the fsm_workloads/drop_index_during_lookup.js failed with a tassert (index not found). The index on the secondary collection of a lookup query is dropped after prepare and before open is called, causing a tassert. The tassert was changed to a uassert that fails with query plan killed.

       

      As a part of this ticket, we should determine why the index is dropped. The best explanation while investigating SERVER-87437 was that when the lookup stage is created, the plan cache entry still exists, and is not cleared after the drop. 

            Assignee:
            Unassigned Unassigned
            Reporter:
            adi.agrawal@mongodb.com Adi Agrawal
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: