createIndexes on shard cluster may not yield for 200ms

XMLWordPrintableJSON

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

      [js_test:delinquent_ops] d22044| 2025-07-04T04:08:20.140+00:00 I  COMMAND  51803   [S] [QueryAnalysisWriter-0] "Slow query","attr":{"type":"command","isFromUserConnection":false,"ns":"config.analyzeShardKeySplitPoints","collectionType":"config","command":{"createIndexes":"analyzeShardKeySplitPoints","indexes":[{"key":{"expireAt":1},"expireAfterSeconds":0,"name":"AnalyzeShardKeySplitPointsTTLIndex"}],"$db":"config"},"totalOplogSlotDurationMicros":201143,"numYields":0,"reslen":271,"locks":{"ReplicationStateTransition":{"acquireCount":{"w":2}},"Global":{"acquireCount":{"r":1,"w":2}},"Database":{"acquireCount":{"w":2}},"Collection":{"acquireCount":{"w":2}}},"flowControl":{"acquireCount":1},"storage":{"timeWaitingMicros":{"storageExecutionMicros":41542}},"cpuNanos":4391940,"protocol":"op_msg","delinquencyInfo":{"totalDelinquentAcquisitions":1,"totalAcquisitionDelinquencyMillis":201,"maxAcquisitionDelinquencyMillis":201},"queues":{"ingress":{"admissions":1},"execution":{"admissions":3}},"workingMillis":201,"durationMillis":201} 

      In this test failure in BF-38411, we find one createIndexes didn't yield for 200ms, which is a potential problem. The assertion is removed temporarily but it worth to investigate the root cause.

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

                Created:
                Updated: