[SERVER-47640] $lookup should increment the serverStatus metrics.queryExecutor counters Created: 17/Apr/20 Updated: 29/Oct/23 Resolved: 03/Jan/21 |
|
| Status: | Closed |
| Project: | Core Server |
| Component/s: | None |
| Affects Version/s: | None |
| Fix Version/s: | 4.9.0 |
| Type: | Improvement | Priority: | Major - P3 |
| Reporter: | Chris Harris | Assignee: | Rishab Joshi (Inactive) |
| Resolution: | Fixed | Votes: | 2 |
| Labels: | qexec-team | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Issue Links: |
|
||||||||||||||||||||
| Backwards Compatibility: | Fully Compatible | ||||||||||||||||||||
| Sprint: | Query 2020-05-18, Query 2020-11-30, Query 2020-12-14, Query 2020-12-28, Query 2021-01-11 | ||||||||||||||||||||
| Participants: | |||||||||||||||||||||
| Case: | (copied to CRM) | ||||||||||||||||||||
| Linked BF Score: | 14 | ||||||||||||||||||||
| Description |
|
As demonstrated below, work performed by $lookup does not increment either the scanned or scannedObjects counters in serverStatus. The result is that mongod does not accurately report the amount of work being performed in this area which complicates the diagnostic and troubleshooting process.
In this example, we populate a local collection with one document and a foreign collection with 1,000 documents. None of the work performed by the $lookup (including the full COLLSCAN of the 1,000 documents in the foreign collection) gets captured by the queryExecutor metrics.
|
| Comments |
| Comment by Githook User [ 01/Jan/21 ] |
|
Author: {'name': 'Rishab Joshi', 'email': 'rishab.joshi@mongodb.com'}Message: |
| Comment by Githook User [ 30/Dec/20 ] |
|
Author: {'name': 'Pierlauro Sciarelli', 'email': 'pierlauro.sciarelli@mongodb.com', 'username': 'pierlauro'}Message: Revert " This reverts commit 9df6363a6699dc20e3abbbd7de386798a4a6a524. |
| Comment by Githook User [ 30/Dec/20 ] |
|
Author: {'name': 'Rishab Joshi', 'email': 'rishab.joshi@mongodb.com'}Message: |
| Comment by David Storch [ 23/Jul/20 ] |
|
Flagging for re-triage, since Drew is now working on other priorities. |