[DOCS-14927] Investigate changes in SERVER-54571: queryHash and planCacheKey Fields Absent in getMore Requests Created: 11/Nov/21 Updated: 13/Nov/23 Resolved: 16/Nov/21 |
|
| Status: | Closed |
| Project: | Documentation |
| Component/s: | manual, Server |
| Affects Version/s: | None |
| Fix Version/s: | 5.1.0-rc0, Server_Docs_20231030, Server_Docs_20231106, Server_Docs_20231105, Server_Docs_20231113 |
| Type: | Task | Priority: | Major - P3 |
| Reporter: | Backlog - Core Eng Program Management Team | Assignee: | Jason Price |
| Resolution: | Done | Votes: | 0 |
| Labels: | None | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||
| Participants: | |||||||||
| Days since reply: | 2 years, 12 weeks, 1 day ago | ||||||||
| Epic Link: | DOCSP-14300 | ||||||||
| Story Points: | 2 | ||||||||
| Description |
|
Downstream Change Summary This change adds the "queryHash" and "planCacheKey" fields to the slow query log lines for getMore commands, as well as to the profiler entries for these getMores. Description of Linked TicketHi Team, Starting in v4.2, MongoDB introduced the queryHash and planCacheKey that respectively help identify slow queries with the same query shape and the plan cache entry associated with the query. Said fields are present in the log from the initial batch for a "slow" query:
But are absent from any subsequent getMore requests:
This happens for both find and aggregate operations in both v4.2.12 and v4.4.4. It would be nice to have these fields present in the getMore requests as not having them makes troubleshooting more difficult and/or inaccurate when using those fields as an analysis criteria, for example:
Regards |
| Comments |
| Comment by Githook User [ 16/Nov/21 ] |
|
Author: {'name': 'jason-price-mongodb', 'email': '69260375+jason-price-mongodb@users.noreply.github.com', 'username': 'jason-price-mongodb'}Message: Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com> |
| Comment by Githook User [ 16/Nov/21 ] |
|
Author: {'name': 'jason-price-mongodb', 'email': '69260375+jason-price-mongodb@users.noreply.github.com', 'username': 'jason-price-mongodb'}Message: Co-authored-by: jason-price-mongodb <jshfjghsdfgjsdjh@aolsdjfhkjsdhfkjsdf.com> |
| Comment by PM Bot [ 11/Nov/21 ] |
|
Downstream changes updated for upstream |