[SERVER-74143] A slow query report should not require the rstl lock to return storage statistics Created: 17/Feb/23  Updated: 29/Oct/23  Resolved: 14/Jun/23

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 7.1.0-rc0, 7.0.0-rc6, 6.0.8, 5.0.20

Type: Improvement Priority: Major - P3
Reporter: Dianna Hohensee (Inactive) Assignee: Josef Ahmad
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Related
Assigned Teams:
Storage Execution
Backwards Compatibility: Fully Compatible
Backport Requested:
v7.0, v6.3, v6.0, v5.0
Sprint: Execution Team 2023-06-12, Execution EMEA Team 2023-06-26
Participants:

 Description   

A slow query can fail to report storage statistics, https://github.com/mongodb/mongo/blob/5e5c97b34ff6d457dfd4ad65644e42675e2b9993/src/mongo/db/curop.cpp#L488-L491 There does not appear to be any need for the RSTL, https://github.com/mongodb/mongo/blob/5e5c97b34ff6d457dfd4ad65644e42675e2b9993/src/mongo/db/storage/wiredtiger/wiredtiger_recovery_unit.cpp#L905-L920, so these report should be allowed to succeed



 Comments   
Comment by Githook User [ 14/Jul/23 ]

Author:

{'name': 'Josef Ahmad', 'email': 'josef.ahmad@mongodb.com', 'username': 'josefahmad'}

Message: SERVER-74143 Exempt slow query storage stats log from acquiring the RSTL

(cherry picked from commit ed6bf2e56aa4e33421bc2f0771706b120fed1ed4)
(cherry picked from commit 968262317174adbc5f7707945055404272e7f248)
Branch: v5.0
https://github.com/mongodb/mongo/commit/e0a65fea6cb706ce5b985dda9e28cd503c0dddc3

Comment by Githook User [ 27/Jun/23 ]

Author:

{'name': 'Josef Ahmad', 'email': 'josef.ahmad@mongodb.com', 'username': 'josefahmad'}

Message: SERVER-74143 Exempt slow query storage stats log from acquiring the RSTL

(cherry picked from commit ed6bf2e56aa4e33421bc2f0771706b120fed1ed4)
Branch: v6.0
https://github.com/mongodb/mongo/commit/968262317174adbc5f7707945055404272e7f248

Comment by Githook User [ 26/Jun/23 ]

Author:

{'name': 'Josef Ahmad', 'email': 'josef.ahmad@mongodb.com', 'username': 'josefahmad'}

Message: SERVER-74143 Exempt slow query storage stats log from acquiring the RSTL

(cherry picked from commit ed6bf2e56aa4e33421bc2f0771706b120fed1ed4)
Branch: v7.0
https://github.com/mongodb/mongo/commit/aa4358022ed32dba2ea58648a2a79e081e3f0956

Comment by Githook User [ 13/Jun/23 ]

Author:

{'name': 'Josef Ahmad', 'email': 'josef.ahmad@mongodb.com', 'username': 'josefahmad'}

Message: SERVER-74143 Exempt slow query storage stats log from acquiring the RSTL
Branch: master
https://github.com/mongodb/mongo/commit/ed6bf2e56aa4e33421bc2f0771706b120fed1ed4

Generated at Thu Feb 08 06:26:37 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.