[SERVER-70479] Make sure that dropDatabase, dropCollection and renameCollection on sharded cluster delete the config.queryAnalyzers doc for the collection being dropped or renamed Created: 11/Oct/22  Updated: 29/Oct/23  Resolved: 25/Apr/23

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

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

Issue Links:
Backports
Duplicate
is duplicated by SERVER-73990 Make query analysis work with collect... Closed
Related
related to SERVER-76296 Make sure query sampling works correc... Closed
Assigned Teams:
Sharding NYC
Backwards Compatibility: Fully Compatible
Backport Requested:
v7.0
Sprint: Sharding NYC 2023-04-03, Sharding NYC 2023-04-17, Sharding NYC 2023-05-01
Participants:

 Description   

The sharding_ddl_util::removeQueryAnalyzerMetadataFromConfig() is currently only called in sharded collection path. So the dropDatabase command currently doesn't delete the config.queryAnalyzers docs for unsharded collections. There was a bug in the jstest added in SERVER-69150. It wasn't verifying the config.queryAnalyzers doc is deleted so we failed to catch that.



 Comments   
Comment by Githook User [ 25/Apr/23 ]

Author:

{'name': 'Cheahuychou Mao', 'email': 'mao.cheahuychou@gmail.com', 'username': 'cheahuychou'}

Message: SERVER-70479 Make sure that dropDatabase, dropCollection and renameCollection on sharded cluster delete the config.queryAnalyzers doc for the collection being dropped or renamed

(cherry picked from commit 57872cba96820e27b5b0420b9fa42b3f34971b45)
Branch: v7.0
https://github.com/mongodb/mongo/commit/8eb36ff05e97c791efecf627835f32471b1b52b6

Comment by Githook User [ 25/Apr/23 ]

Author:

{'name': 'Cheahuychou Mao', 'email': 'mao.cheahuychou@gmail.com', 'username': 'cheahuychou'}

Message: SERVER-70479 Use namespace as the _id for config.queryAnalyzers collection

(cherry picked from commit f1fd45a9706a0d7ee666559fb7921f37016f9931)
Branch: v7.0
https://github.com/mongodb/mongo/commit/6264c7f55910601c4043eb4e3d4dcbbc7efe8ce3

Comment by Githook User [ 25/Apr/23 ]

Author:

{'name': 'Cheahuychou Mao', 'email': 'mao.cheahuychou@gmail.com', 'username': 'cheahuychou'}

Message: SERVER-70479 Make sure that dropDatabase, dropCollection and renameCollection on sharded cluster delete the config.queryAnalyzers doc for the collection being dropped or renamed
Branch: master
https://github.com/mongodb/mongo/commit/57872cba96820e27b5b0420b9fa42b3f34971b45

Comment by Githook User [ 24/Apr/23 ]

Author:

{'name': 'Cheahuychou Mao', 'email': 'mao.cheahuychou@gmail.com', 'username': 'cheahuychou'}

Message: SERVER-70479 Use namespace as the _id for config.queryAnalyzers collection
Branch: master
https://github.com/mongodb/mongo/commit/f1fd45a9706a0d7ee666559fb7921f37016f9931

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