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

Sharded query plan cache commands contain redundant information

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major - P3 Major - P3
    • None
    • 2.6.0-rc0
    • Querying
    • Query
    • ALL
    • Hide

      Run QA/QA-453/query_plan_cache_commands_sharded.js, and add printjson() to the TODO comments.

      Show
      Run QA/QA-453/query_plan_cache_commands_sharded.js, and add printjson() to the TODO comments.

    Description

      When executing any of the query plan cache commands on a sharded cluster, an extra set of results are returned at the top level. For example, the following output is produced by the planCacheListQueryShapes command in QA/QA-453/query_plan_cache_commands_sharded.js:

      {
              "shapes" : [
                      {
                              "query" : {
                                      "_id" : {
                                              "$lte" : -1
                                      }
                              },
                              "sort" : {
       
                              },
                              "projection" : {
       
                              }
                      }
              ],
              "ok" : 1,
              "shard0000" : {
                      "shapes" : [
                              {
                                      "query" : {
                                              "_id" : {
                                                      "$lte" : -1
                                              }
                                      },
                                      "sort" : {
       
                                      },
                                      "projection" : {
       
                                      }
                              }
                      ],
                      "ok" : 1
              },
              "shard0001" : {
                      "shapes" : [
                              {
                                      "query" : {
                                              "_id" : {
                                                      "$gte" : 1
                                              }
                                      },
                                      "sort" : {
       
                                      },
                                      "projection" : {
       
                                      }
                              }
                      ],
                      "ok" : 1
              }
      }
      

      The same issue applies to planCacheListPlans.

      Attachments

        Activity

          People

            backlog-server-query Backlog - Query Team (Inactive)
            benjamin.becker Ben Becker
            Votes:
            1 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: