Shard collection creation may not yield for more than 100ms

    • Type: Bug
    • Resolution: Unresolved
    • Priority: Major - P3
    • None
    • Affects Version/s: None
    • Component/s: None
    • None
    • Query Execution
    • ALL
    • None
    • 3
    • TBD
    • None
    • None
    • None
    • None
    • None
    • None
    • None

      _shardsvrCreateCollectionParticipant

      "Slow query","attr":{"type":"command","isFromUserConnection":true,"ns":"test.$cmd","collectionType":"normal","appName":"/data/mci/db99b5a585af66fece493b8e5903bc47/src/dist-test/bin/mongod","command":{"_shardsvrCreateCollectionParticipant":"mode_merge_fail_target","indexes":[{"v":2,"key":{"_id":1},"name":"_id_"},{"v":2,"key":{"_id":"hashed"},"name":"_id_hashed"}],"options":{"uuid":{"$uuid":"ce303969-8491-47e8-a960-9da4a3c2ba67"}},"collectionUUID":{"$uuid":"ce303969-8491-47e8-a960-9da4a3c2ba67"},"idIndex":{"v":2,"key":{"_id":1},"name":"_id_"},"writeConcern":{"w":"majority","wtimeout":60000},"lsid":{"id":{"$uuid":"9b70a0a0-5f5e-4f97-bc22-9f9622938f10"},"uid":{"$binary":{"base64":"u4nTF1+wmByGgmwndZCCo3FgRx9gUEtGEkFRhsYwq3A=","subType":"0"}}},"txnNumber":258,"$clusterTime":{"clusterTime":{"$timestamp":{"t":1753821224,"i":215}}},"$configTime":{"$timestamp":{"t":1753821224,"i":195}},"$topologyTime":{"$timestamp":{"t":1753821214,"i":9}},"$audit":{"$impersonatedUser":{"user":"__system","db":"local"},"$impersonatedRoles":[]},"versionContext":{"OFCV":"8.2"},"mayBypassWriteBlocking":false,"$db":"test"},"totalOplogSlotDurationMicros":120249,"numYields":0,"reslen":156,"locks":{"ReplicationStateTransition":{"acquireCount":{"w":6}},"Global":{"acquireCount":{"r":3,"w":3}},"Database":{"acquireCount":{"r":1,"w":3}},"Collection":{"acquireCount":{"r":1,"w":2,"W":1}}},"flowControl":{"acquireCount":2},"writeConcern":{"w":"majority","wtimeout":60000,"provenance":"clientSupplied"},"waitForWriteConcernDurationMillis":1,"storage":{"timeWaitingMicros":{"storageExecutionMicros":967}},"cpuNanos":4597997,"remote":"127.0.0.1:41584","protocol":"op_msg",{*}"delinquencyInfo"{*}{*}:{{*}{*}"totalDelinquentAcquisitions"{*}{*}:{*}{*}1{*}{*},{*}{*}"totalAcquisitionDelinquencyMillis"{*}{*}:{*}{*}120{*}{*},{*}{*}"maxAcquisitionDelinquencyMillis"{*}{*}:{*}{*}120{*}{*}}{*},"queues":{"ingress":{"admissions":3},"execution":{"admissions":6}},"workingMillis":122,"durationMillis":122}
      

      _shardsvrCreateCollection

      "Slow query","attr":{"type":"command","isFromUserConnection":true,"ns":"test.$cmd","collectionType":"normal","appName":"MongoDB Shell","command":{"_shardsvrCreateCollection":"jstests_compare_long_double","capped":false,"unsplittable":true,"readConcern":{"level":"local","provenance":"implicitDefault"},"writeConcern":{"w":"majority","wtimeout":60000},"databaseVersion":{"uuid":{"$uuid":"bfe4b7e7-d784-4766-8cdb-2d234b592626"},"timestamp":{"$timestamp":{"t":1753821432,"i":45}},"lastMod":1},"lsid":{"id":{"$uuid":"f4985e46-2818-4a81-b01b-47376eed7965"},"uid":{"$binary":{"base64":"47DEQpj8HBSa+/TImW+5JCeuQeRkm5NMpJWZG3hSuFU=","subType":"0"}}},"$clusterTime":{"clusterTime":{"$timestamp":{"t":1753821432,"i":59}}},"$configTime":{"$timestamp":{"t":1753821432,"i":56}},"$topologyTime":{"$timestamp":{"t":1753821418,"i":70}},"$client":{"application":{"name":"MongoDB Shell"},"driver":{"name":"MongoDB Internal Client","version":"8.2.0-alpha2-85-gdafcedb-patch-68892a068bcf3a00071f4f07"},"os":{"type":"Linux","name":"Amazon Linux release 2023.8.20250715 (Amazon Linux)","architecture":"aarch64","version":"Kernel 6.1.141-165.249.amzn2023.aarch64"},"mongos":{"host":"ip-10-122-32-131.ec2.internal:20003","client":"127.0.0.1:47914","version":"8.2.0-alpha2-85-gdafcedb-patch-68892a068bcf3a00071f4f07"}},"mayBypassWriteBlocking":false,"$db":"test"},"totalOplogSlotDurationMicros":107181,"numYields":0,"reslen":206,"locks":{"ReplicationStateTransition":{"acquireCount":{"w":2}},"Global":{"acquireCount":{"r":2,"w":1}},"Database":{"acquireCount":{"w":1}},"Collection":{"acquireCount":{"w":1}},"DDLDatabase":{"acquireCount":{"w":1}},"DDLCollection":{"acquireCount":{"W":1}},"Mutex":{"acquireCount":{"r":1}}},"flowControl":{"acquireCount":1},"readConcern":{"level":"local","provenance":"implicitDefault"},"writeConcern":{"w":"majority","wtimeout":60000,"provenance":"clientSupplied"},"waitForWriteConcernDurationMillis":21,"storage":{"timeWaitingMicros":{"storageExecutionMicros":26479}},"cpuNanos":3388407,"remote":"127.0.0.1:42190","protocol":"op_msg","delinquencyInfo":{"totalDelinquentAcquisitions":1,"totalAcquisitionDelinquencyMillis":107,"maxAcquisitionDelinquencyMillis":107},"queues":{"ingress":{"admissions":2},"execution":{"admissions":4}},"workingMillis":129,"durationMillis":129}
      

              Assignee:
              Unassigned
              Reporter:
              Zixuan Zhuang
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: