Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-81089

nonexistent collection for $queryStats entry for queries against the config.transactions

    • Type: Icon: Bug Bug
    • Resolution: Works as Designed
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • Query Integration
    • ALL
      1. start a fresh mongod
      2. wait a bit, let the queries against config collection run automatically
      3. run $queryStats

       

        {
          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"

       

            Assignee:
            alyssa.clark@mongodb.com Alyssa Clark
            Reporter:
            colby.ing@mongodb.com Colby Ing
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: