[DOCS-13131] cursor.maxTimeMS should explain how terminated operations are logged Created: 18/Oct/19  Updated: 30/Oct/23

Status: Closed
Project: Documentation
Component/s: manual
Affects Version/s: None
Fix Version/s: Server_Docs_20231030

Type: Improvement Priority: Minor - P4
Reporter: Nic Cottrell Assignee: Unassigned
Resolution: Won't Do Votes: 0
Labels: docs-query
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Participants:
Days since reply: 1 year, 14 weeks, 2 days ago
Epic Link: DOCSP-1769

 Description   

Description

The cursor.maxTimeMS Behavior section doesn't explain what is reported in the logs.

At least in 3.6.12, there will be a log entry with errmsg: "operation exceeded time limit" such as:

2019-10-15T20:02:11.341+0100 I COMMAND  [conn636131] command myDb.myColl command: aggregate { aggregate: "myColl", pipeline: [... ], allowDiskUse: true, fromMongos: true, cursor: { batchSize: 101 }, maxTimeMS: 5000, shardVersion: [ Timestamp(19622, 240811), ObjectId('5705031ca624b38123a80989') ], $clusterTime: { clusterTime: Timestamp(0, 0), signature: { hash: BinData(0, 0000000000000000000000000000000000000000), keyId: 0 } }, ... $db: "myDb" } planSummary: IXSCAN { ... } exception: Error in $cursor stage :: caused by :: errmsg: "operation exceeded time limit" code:ExceededTimeLimit numYields:241 reslen:276 locks:{ Global: { acquireCount: { r: 586 } }, Database: { acquireCount: { r: 293 } }, Collection: { acquireCount: { r: 293 } } } protocol:op_msg 5011ms

It's useful to know that this is logged with this message so we can search for this type of slow query.

Scope of changes

Impact to Other Docs

MVP (Work and Date)

Resources (Scope or Design Docs, Invision, etc.)



 Comments   
Comment by Education Bot [ 31/Oct/22 ]

Hello! This ticket has been closed due to inactivity. If you believe this ticket is still important, please reopen it and leave a comment to explain why. Thank you!

Generated at Thu Feb 08 08:07:01 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.