[SERVER-81089] nonexistent collection for $queryStats entry for queries against the config.transactions Created: 14/Sep/23  Updated: 03/Nov/23  Resolved: 03/Nov/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Colby Ing Assignee: Alyssa Clark
Resolution: Works as Designed Votes: 0
Labels: querystats-7.1-qa
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
is depended on by SERVER-85096 TRACKING: M3 Correctness Tickets Closed
Assigned Teams:
Query Integration
Operating System: ALL
Steps To Reproduce:
  1. start a fresh mongod
  2. wait a bit, let the queries against config collection run automatically
  3. run $queryStats
Participants:

 Description   

 

  {
    key: {
      queryShape: {
        cmdNs: { db: 'config', coll: 'transactions' },
        command: 'find',
        filter: { lastWriteDate: { '$lt': '?date' } },
        projection: { _id: true },
        sort: { _id: 1 }
      },
      readConcern: {},
      collectionType: 'nonExistent'
    },
    metrics: {
      lastExecutionMicros: Long("186"),
      execCount: Long("4"),
      totalExecMicros: {
        sum: Long("2513"),
        max: Long("1957"),
        min: Long("181"),
        sumOfSquares: Long("3932927")
      },
      firstResponseExecMicros: {
        sum: Long("2513"),
        max: Long("1957"),
        min: Long("181"),
        sumOfSquares: Long("3932927")
      },
      docsReturned: {
        sum: Long("0"),
        max: Long("0"),
        min: Long("0"),
        sumOfSquares: Long("0")
      },
      firstSeenTimestamp: ISODate("2023-09-14T12:30:09.483Z"),
      latestSeenTimestamp: ISODate("2023-09-14T12:45:09.478Z")
    },
    asOf: Timestamp({ t: 1694695781, i: 0 })
  } 

 

Unsure if this is a bug or not, but this doesn't seem like a "nonexistent" collection. maybe "collection" or "virtual"

 


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