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

Slow query txnBytesDirty can be negative

    • Type: Icon: Bug Bug
    • Resolution: Unresolved
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Storage Execution
    • ALL
    • Execution Team 2024-09-16, Execution Team 2024-09-30
    • 0

      When looking through log files I saw some slow query logs with negative txnBytesDirty:

      [j5:c:prim] | 2024-07-18T08:49:33.578+00:00 I  COMMAND  51803   [S] [conn1043] "Slow query","attr":{"type":"command","isFromUserConnection":true,"ns":"config.$cmd","collectionType":"config","appName":"/data/mci/fe471a21a870853527fc95d79d3418ee/src/dist-test/bin/mongos","command":{"update":"mongos","bypassDocumentValidation":false,"ordered":true,"updates":[{"q":{"_id":"ip-10-128-182-201.ec2.internal:21252"},"u":{"$set":{"_id":"ip-10-128-182-201.ec2.internal:21252","ping":{"$date":"2024-07-18T08:49:29.954Z"},"up":904,"waiting":true,"mongoVersion":"8.0.0-rc13-82-g96b8614","advisoryHostFQDNs":["ip-10-128-182-201.ec2.internal"]},"$setOnInsert":{"created":{"$date":"2024-07-18T08:34:25.946Z"}}},"multi":false,"upsert":true}],"writeConcern":{"w":"majority","wtimeout":60000},"maxTimeMS":90000,"maxTimeMSOpOnly":90000,"$replData":1,"$clusterTime":{"clusterTime":{"$timestamp":{"t":1721292569,"i":1}}},"$configTime":{"$timestamp":{"t":1721292567,"i":4}},"$topologyTime":{"$timestamp":{"t":1721291666,"i":12}},"mayBypassWriteBlocking":false,"$db":"config"},"numYields":1,"reslen":474,"locks":{"ReplicationStateTransition":{"acquireCount":{"w":4}},"Global":{"acquireCount":{"r":3,"w":2}},"Database":{"acquireCount":{"r":1,"w":2}},"Collection":{"acquireCount":{"w":2}},"Mutex":{"acquireCount":{"r":8}}},"flowControl":{"acquireCount":2},"writeConcern":{"w":"majority","wtimeout":60000,"provenance":"clientSupplied"},"waitForWriteConcernDurationMillis":1797,"storage":{"data":{"txnBytesDirty":-769}},"cpuNanos":57008155,"remote":"127.0.0.1:57694","protocol":"op_msg","queues":{"execution":{"admissions":5},"ingress":{"admissions":1}},"workingMillis":3615,"durationMillis":3615}
      

            Assignee:
            shinyee.tan@mongodb.com Shin Yee Tan
            Reporter:
            louis.williams@mongodb.com Louis Williams
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated: