[SERVER-66793] Disable bucket unpacking with sort for clustered collections with out of order buckets Created: 26/May/22  Updated: 29/Oct/23  Resolved: 19/Oct/22

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: 6.0.0-rc7
Fix Version/s: 6.2.0-rc0, 6.0.5, 5.0.16

Type: Bug Priority: Major - P3
Reporter: James Wahlin Assignee: Joel Redman (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
depends on SERVER-66794 Add an in-memory flag for TS collecti... Closed
Related
related to SERVER-70680 Enable bucket unpacking with sort for... Backlog
is related to SERVER-70747 Rename collection used in bucket_unpa... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v6.0, v5.0
Sprint: QO 2022-10-03, QE 2022-10-17
Participants:

 Description   

As reported in SERVER-66469, time-series buckets that contain dates prior to Jan 1st 1970 or after year 2108 can be placed out of time-order in the clustered collection. As the bucket unpacking with sort optimization relies on this ordering, we should disable when these exist.

A workaround for users who have dates in this range will be to create an index on the time field which is not subject to this behavior.



 Comments   
Comment by Githook User [ 21/Feb/23 ]

Author:

{'name': 'Joel Redman', 'email': 'joel.redman@mongodb.com', 'username': 'joredman'}

Message: SERVER-66793 Use explicit sort when extended range dates are used

(cherry picked from commit 2b65016588fc5f868b0e396b64d1fe9da916a343)

Also includes some changes from aedaf14d6dcc60253f3944252eb5cfc588e08ecb:
plumbing the 'usesExtendedRange' flag and making it available on
BucketSpec. This was originally part of SERVER-66469.
Branch: v5.0
https://github.com/mongodb/mongo/commit/4e9ee688d44e57c1a784e9b146f1d456a0fd9b29

Comment by Githook User [ 31/Jan/23 ]

Author:

{'name': 'Joel Redman', 'email': '77073003+joredman@users.noreply.github.com', 'username': 'joredman'}

Message: SERVER-66793 Use explicit sort when extended range dates are used
Branch: v6.0
https://github.com/mongodb/mongo/commit/2b65016588fc5f868b0e396b64d1fe9da916a343

Comment by Githook User [ 19/Oct/22 ]

Author:

{'name': 'Joel Redman', 'email': '77073003+joredman@users.noreply.github.com', 'username': 'joredman'}

Message: SERVER-66793 Use explicit sort when extended range dates are used
Branch: master
https://github.com/mongodb/mongo/commit/bf76e0e26c9565788f53f5615b6f1fdf2d5e4613

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