[SERVER-76296] Make sure query sampling works correctly after DDL operations Created: 19/Apr/23  Updated: 29/Oct/23  Resolved: 26/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: Bug 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
Depends
depends on SERVER-76297 Make query sampling jstests check nam... Closed
Related
is related to SERVER-70479 Make sure that dropDatabase, dropColl... Closed
Backwards Compatibility: Fully Compatible
Operating System: ALL
Backport Requested:
v7.0
Sprint: Sharding NYC 2023-05-01
Participants:

 Description   

If a collection with query sampling enabled is dropped via dropCollection, dropDatabase or renamed via renameCollection, query sampling should stop even if the collection is later recreated with the same name (in the drop case) or if the config.queryAnalyzers document has not been deleted (see SERVER-70479). Also, if the client later runs a configureQueryAnalyzer command enable query sampling again, the sampling should follow the new configuration. 



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

Author:

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

Message: SERVER-76296 Fix error messages for analyzeShardKey and configureQueryAnalyzer commands

(cherry picked from commit 3e9182413acd35a8858c458f5bc1762adf40be6e)
Branch: v7.0
https://github.com/mongodb/mongo/commit/5b3234c8238d8238d1a4cb63c0d9b1909b60d8ef

Comment by Githook User [ 26/Apr/23 ]

Author:

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

Message: SERVER-76296 Fix error messages for analyzeShardKey and configureQueryAnalyzer commands
Branch: master
https://github.com/mongodb/mongo/commit/3e9182413acd35a8858c458f5bc1762adf40be6e

Comment by Githook User [ 26/Apr/23 ]

Author:

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

Message: SERVER-76296 Re-enable multiversion testing for analyzeShardKey and configureQueryAnalyzer commands
Branch: master
https://github.com/mongodb/mongo/commit/8b7be91fc2de0c99bf0f35cf2a9e6eda50a64dc8

Comment by Githook User [ 25/Apr/23 ]

Author:

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

Message: SERVER-76296 Make QueryAnalysisWriter only persist samples for collection with query sampling still enabled

(cherry picked from commit bb61585e4f3454d2c67196db86d72bd20e456c64)
Branch: v7.0
https://github.com/mongodb/mongo/commit/c242873695309227627cff505fbfd334a0d177cf

Comment by Githook User [ 25/Apr/23 ]

Author:

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

Message: SERVER-76296 Serialize configureQueryAnalyzer command with DDL commands

(cherry picked from commit 0bd4cff6dd575b547e5b5bebf93ad8ce000939c0)
Branch: v7.0
https://github.com/mongodb/mongo/commit/3434f4f47bf6a604a2a7cf92536569fa2421b6a7

Comment by Githook User [ 25/Apr/23 ]

Author:

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

Message: SERVER-76296 Make QueryAnalysisWriter only persist samples for collection with query sampling still enabled
Branch: master
https://github.com/mongodb/mongo/commit/bb61585e4f3454d2c67196db86d72bd20e456c64

Comment by Githook User [ 25/Apr/23 ]

Author:

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

Message: SERVER-76296 Serialize configureQueryAnalyzer command with DDL commands
Branch: master
https://github.com/mongodb/mongo/commit/0bd4cff6dd575b547e5b5bebf93ad8ce000939c0

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