[SERVER-82053] Use index hint for time series bucket reopening query Created: 10/Oct/23  Updated: 08/Feb/24  Resolved: 26/Jan/24

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: None
Fix Version/s: 8.0.0-rc0

Type: Improvement Priority: Major - P3
Reporter: Dan Larkin-York Assignee: Dan Larkin-York
Resolution: Fixed Votes: 0
Labels: bkp
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Backports
Depends
depends on SERVER-85557 Return more helpful error when time s... Closed
Problem/Incident
Assigned Teams:
Storage Execution
Backwards Compatibility: Fully Compatible
Backport Requested:
v7.0
Sprint: Execution Team 2023-11-27, Execution Team 2023-12-11, Execution Team 2023-12-25, Execution Team 2024-01-22, Execution Team 2024-02-05
Participants:
Linked BF Score: 155

 Description   

While we disable query-based reopening if a sufficient index does not exist, we currently do not specify an index hint when we do choose to run the query. Under some circumstances, the query planner may fail to use the appropriate index, resulting in a collection scan.



 Comments   
Comment by Githook User [ 08/Feb/24 ]

Author:

{'name': 'Dan Larkin-York', 'email': 'dan.larkin-york@mongodb.com', 'username': 'dhly-etc'}

Message: SERVER-82053 Use index hint for time series bucket reopening query

(cherry picked from commit b6484345740910793809ba655a62eeabda1f319b)

GitOrigin-RevId: 323f3cfdb6f095a97501b7866447ac488132e97a
Branch: v7.0
https://github.com/mongodb/mongo/commit/de48ea1fbbe84be0e8e21c4f09dec4838a0cd6a5

Comment by Githook User [ 25/Jan/24 ]

Author:

{'name': 'Dan Larkin-York', 'email': 'dan.larkin-york@mongodb.com', 'username': 'dhly-etc'}

Message: SERVER-82053 Use index hint for time series bucket reopening query

GitOrigin-RevId: b6484345740910793809ba655a62eeabda1f319b
Branch: master
https://github.com/mongodb/mongo/commit/d34b40707438dcdb97e6a623273ab95b8021afcd

Comment by Githook User [ 29/Nov/23 ]

Author:

{'name': 'Gregory Wlodarek', 'email': 'gregory.wlodarek@mongodb.com', 'username': 'GWlodarek'}

Message: Revert "SERVER-82053 Use index hint for time series bucket reopening query"

This reverts commit ea5336dd3fe4dd481d2c991b3bdd2f01e5593657.
Branch: master
https://github.com/mongodb/mongo/commit/391da0562913774e0c0a72d828d373bf2d7fe3e8

Comment by Githook User [ 27/Nov/23 ]

Author:

{'name': 'Dan Larkin-York', 'email': 'dan.larkin-york@mongodb.com', 'username': 'dhly-etc'}

Message: SERVER-82053 Use index hint for time series bucket reopening query
Branch: master
https://github.com/mongodb/mongo/commit/ea5336dd3fe4dd481d2c991b3bdd2f01e5593657

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