[SERVER-71759] dataSize command doesn't yield Created: 01/Dec/22  Updated: 29/Oct/23  Resolved: 03/Dec/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: 4.2.22, 4.4.18, 5.0.14, 6.0.3, 6.1.0-rc4, 6.2.0-rc1
Fix Version/s: 4.2.24, 4.4.19, 5.0.15, 6.0.4, 6.2.0-rc3, 6.3.0-rc0

Type: Bug Priority: Major - P3
Reporter: Tommaso Tocci Assignee: Tommaso Tocci
Resolution: Fixed Votes: 0
Labels: collection-defrag-bugs
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Problem/Incident
Related
related to SERVER-71771 Defragmenter should cap chunk size es... Closed
is related to SERVER-58356 Cannot kill the dataSize operation Closed
is related to SERVER-15650 Check for places where YIELD_AUTO cou... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v6.2, v6.1, v6.0, v5.0, v4.4, v4.2
Sprint: Sharding EMEA 2022-12-12
Participants:
Case:

 Description   

We recently discovered that dataSize command doesn't yield while scanning the index. This means that during its execution it will possibly block all the operations that requires exclusive access to the collection and considering that scanning the index for the entire collection can take long time this could have a huge impact on the customer workload.

Recently (SERVER-58356) we changed the yield policy to be  INTERRUPT_ONLY so that we can at least kill the operation if needed.

The goal of this ticket to change the yielding policy to YIELD_AUTO for both when the command is called with estimate:true or false



 Comments   
Comment by Githook User [ 05/Dec/22 ]

Author:

{'name': 'Tommaso Tocci', 'email': 'tommaso.tocci@mongodb.com', 'username': 'toto-dev'}

Message: SERVER-71759 dataSize command doesn't yield

(cherry picked from commit 62c6074e3342169809d5c01fd62452c082667c88)
(cherry picked from commit 8109b02976404d3c5d4f7b3d067ab7d54b612ecd)
(cherry picked from commit fe7b2dcce82c71dc4f4e6d7aa776bb50ee5d7484)
Branch: v4.2
https://github.com/mongodb/mongo/commit/ba09304723cd67b1670da2a4fd8a7ae73de78c45

Comment by Githook User [ 04/Dec/22 ]

Author:

{'name': 'Tommaso Tocci', 'email': 'tommaso.tocci@mongodb.com', 'username': 'toto-dev'}

Message: SERVER-71759 dataSize command doesn't yield

(cherry picked from commit 62c6074e3342169809d5c01fd62452c082667c88)
(cherry picked from commit 8109b02976404d3c5d4f7b3d067ab7d54b612ecd)
Branch: v4.4
https://github.com/mongodb/mongo/commit/41f398a4686bbc0b1d53d019efcb80760a18bbd2

Comment by Githook User [ 04/Dec/22 ]

Author:

{'name': 'Tommaso Tocci', 'email': 'tommaso.tocci@mongodb.com', 'username': 'toto-dev'}

Message: SERVER-71759 dataSize command doesn't yield

(cherry picked from commit 62c6074e3342169809d5c01fd62452c082667c88)
Branch: v5.0
https://github.com/mongodb/mongo/commit/91333852bcdbc85650a467df383d5ff72d14ae0b

Comment by Githook User [ 04/Dec/22 ]

Author:

{'name': 'Tommaso Tocci', 'email': 'tommaso.tocci@mongodb.com', 'username': 'toto-dev'}

Message: SERVER-71759 dataSize command doesn't yield
Branch: v6.0
https://github.com/mongodb/mongo/commit/62c6074e3342169809d5c01fd62452c082667c88

Comment by Githook User [ 03/Dec/22 ]

Author:

{'name': 'Tommaso Tocci', 'email': 'tommaso.tocci@mongodb.com', 'username': 'toto-dev'}

Message: SERVER-71759 dataSize command doesn't yield

(cherry picked from commit 44d81c74e55420619b295490606a6bedb367e3c2)
Branch: v6.2
https://github.com/mongodb/mongo/commit/a7c27ed8901a54795743df0911729fc6045d8613

Comment by Githook User [ 02/Dec/22 ]

Author:

{'name': 'Tommaso Tocci', 'email': 'tommaso.tocci@mongodb.com', 'username': 'toto-dev'}

Message: SERVER-71759 dataSize command doesn't yield
Branch: master
https://github.com/mongodb/mongo/commit/44d81c74e55420619b295490606a6bedb367e3c2

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