[SERVER-76721] Robustify plan_cache_stats_shard_and_host.js to count plan cache entries only for specific plan cache key Created: 01/May/23  Updated: 29/Oct/23  Resolved: 02/May/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.1.0-rc0, 4.4.22, 5.0.18, 7.0.0-rc1, 6.0.7

Type: Bug Priority: Minor - P4
Reporter: Adi Agrawal Assignee: Adi Agrawal
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v7.0, v6.3, v6.0, v5.0, v4.4
Sprint: QE 2023-05-15
Participants:
Linked BF Score: 20

 Description   

Currently, plan_cache_stats_shard_and_host.js compares number of shards for a collection to the total number of plan cache entries. This fails if we have additional cache entries due to queries run on the collection in the background. To address this issue, we should compare the number of shards in a collection with the number of plan cache entries that correspond specifically to the query's planCacheKey tested by the script.



 Comments   
Comment by Githook User [ 09/May/23 ]

Author:

{'name': 'Adityavardhan Agrawal', 'email': 'adi.agrawal@mongodb.com', 'username': 'Adityav369'}

Message: SERVER-76721: Robustify plan_cache_stats_shard_and_host.js to count plan cache entries only for specific plan cache key
Branch: v4.4
https://github.com/mongodb/mongo/commit/e766fdc40fc3131d3646e2c00733c7cc2158d358

Comment by Githook User [ 05/May/23 ]

Author:

{'name': 'Adityavardhan Agrawal', 'email': 'adi.agrawal@mongodb.com', 'username': 'Adityav369'}

Message: SERVER-76721: Robustify plan_cache_stats_shard_and_host.js to count plan cache entries only for specific plan cache key
Branch: v5.0
https://github.com/mongodb/mongo/commit/1ab1baf318baf327e973ed336940b6b0432ae37b

Comment by Githook User [ 05/May/23 ]

Author:

{'name': 'Adityavardhan Agrawal', 'email': 'adi.agrawal@mongodb.com', 'username': 'Adityav369'}

Message: SERVER-76721: Robustify plan_cache_stats_shard_and_host.js to count plan cache entries only for specific plan cache key
Branch: v6.0
https://github.com/mongodb/mongo/commit/919e225236366b0072f332fcfdde5271526ead2d

Comment by Githook User [ 03/May/23 ]

Author:

{'name': 'Adityavardhan Agrawal', 'email': 'adi.agrawal@mongodb.com', 'username': 'Adityav369'}

Message: SERVER-76721: Robustify plan_cache_stats_shard_and_host.js to count plan cache entries only for specific plan cache key
Branch: v7.0
https://github.com/mongodb/mongo/commit/2e3b2a407ccaa74756abf71437ac301fc60695b3

Comment by Githook User [ 02/May/23 ]

Author:

{'name': 'Adityavardhan Agrawal', 'email': 'adi.agrawal@mongodb.com', 'username': 'Adityav369'}

Message: SERVER-76721: Robustify plan_cache_stats_shard_and_host.js to count plan cache entries only for specific plan cache key
Branch: master
https://github.com/mongodb/mongo/commit/a6d790a62c82d3f841b4b475324cbd523fad38ac

Generated at Thu Feb 08 06:33:25 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.