[SERVER-13042] Sharded query plan cache commands contain redundant information Created: 05/Mar/14  Updated: 06/Dec/22  Resolved: 05/Jul/19

Status: Closed
Project: Core Server
Component/s: Querying
Affects Version/s: 2.6.0-rc0
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Ben Becker Assignee: Backlog - Query Team (Inactive)
Resolution: Won't Do Votes: 1
Labels: 26qa, query-44-grooming
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
Assigned Teams:
Query
Operating System: ALL
Steps To Reproduce:

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

Participants:

 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.



 Comments   
Comment by David Storch [ 05/Jul/19 ]

Due to the introduction of the $planCacheStats aggregation metadata source in version 4.2, we're not currently considering improvements to the planCacheListPlans or planCacheListQueryShapes commands. Closing as Won't Do.

Generated at Thu Feb 08 03:30:27 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.