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

Indicate the reason for replanning in the log file

    XMLWordPrintable

    Details

    • Backwards Compatibility:
      Fully Compatible
    • Backport Requested:
      v4.2, v4.0, v3.6
    • Sprint:
      Query 2019-11-04, Query 2019-11-18, Query 2019-12-16, Query 2019-12-30, Query 2020-01-13

      Description

      As of the the query plan cache changes introduced in 3.0 via SERVER-15225, the database will monitor the performance of cached plans and can replan them if they are found to be less efficient than expected. Indication that this has occurred is present in the log file via the replanned:1 flag as of 3.2 via SERVER-18468. Replanning can also be triggered when the sort memory threshold is exceeded while using a cached plan.

      The current replanned boolean flag recorded in the log file does not indicate which specific trigger caused the event. This can result in incorrect conclusions or additional steps to properly diagnose the situation.

        Attachments

          Activity

            People

            Assignee:
            david.percy David Percy
            Reporter:
            christopher.harris Christopher Harris
            Participants:
            Votes:
            2 Vote for this issue
            Watchers:
            16 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: