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

Session cursor cache prevent ident drop

    • Type: Icon: Bug Bug
    • Resolution: Won't Do
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • RSS Sydney
    • RSS Sydney - 2024-06-25

      The pending drop ident reaper does not notify the MongoDB layer cursor caches to release any cursors on tables that we need to drop. This then results in the pending drop ident reaper consistently failing to drop these idents until the cursors are cleared from the cache the normal way which happens when sessions are released for the standard hybrid cursor caching approach. If the queries running are very slow this can then take a while before free space is reclaimed.

      The problem is worse if the wiredTigerCursorCacheSize setting is set to a positive value where these cursors can then remain in the cache for a long time.

      Before SERVER-69363 we had a separate drop pending system that did clear cursors from cached sessions. But even this system has issues as only cursors in cached (non-active) sessions would be cleared. So an aggregation that has created a temporary table would not be able to have this table dropped until the whole aggregation is completed and the session is released (and the cursors cleared).

            Assignee:
            clarisse.cheah@mongodb.com Clarisse Cheah
            Reporter:
            henrik.edin@mongodb.com Henrik Edin
            Votes:
            0 Vote for this issue
            Watchers:
            7 Start watching this issue

              Created:
              Updated:
              Resolved: