[SERVER-72912] Create TTL index for config.sampledQueries and config.sampledQueriesDiff on FCV upgrade Created: 17/Jan/23  Updated: 29/Oct/23  Resolved: 03/Feb/23

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

Type: Task Priority: Major - P3
Reporter: Cheahuychou Mao Assignee: Israel Hsu
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Backwards Compatibility: Fully Compatible
Sprint: Sharding NYC 2023-01-23, Sharding NYC 2023-02-06
Participants:

 Description   
  • Make setFCV upgrade call the helper here.
  • Add a jstest that verifies that the TTL index is created on setFCV upgrade similar to this.


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

Author:

{'name': 'Israel Hsu', 'email': 'israel.hsu@mongodb.com', 'username': 'israelhsu'}

Message: SERVER-72912 Create TTL indexes on config.

{sampledQueries,sampledQueriesDiff}

on setFCV upgrade
Branch: master
https://github.com/mongodb/mongo/commit/f8dba817139f2ea4493b6657f81e78cd8761b7c6

Comment by Israel Hsu [ 31/Jan/23 ]

After reviewing FCV_AND_FEATURE_FLAG_README and the MongoDB manual (e.g. https://www.mongodb.com/docs/manual/release-notes/5.0-upgrade-sharded-cluster/#std-label-5.0-upgrade-sharded-cluster) it's clear that approach 2. is appropriate.
We want the QueryAnalysisWriter service to start with the new binary 7.0 (for example), but if FCV is an earlier version, these services will not do anything. That is, the functionality of these services are gated by the feature flag check for the FCV.
This means that there is no action needed for QueryAnalysisWriter when the set FCV command runs.

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