[SERVER-72895] Implement shardKey index check in checkConsistencyMetadata command Created: 17/Jan/23  Updated: 29/Oct/23  Resolved: 23/Mar/23

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

Type: Task Priority: Major - P3
Reporter: Tommaso Tocci Assignee: Pol Pinol
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-75285 Deadlock between ShardsvrCheckMetadat... Closed
related to SERVER-74086 Implement checks for consistent index... Closed
is related to SERVER-74936 Improve shard key index inconsistency... Closed
Assigned Teams:
Sharding EMEA
Backwards Compatibility: Fully Compatible
Sprint: Sharding EMEA 2023-01-23, Sharding EMEA 2023-02-06, Sharding EMEA 2023-02-20, Sharding EMEA 2023-03-06, Sharding EMEA 2023-03-20, Sharding EMEA 2023-04-03
Participants:

 Description   

As part of the goals of the project, we have to implement the checks for consistent indexes. These checks include:

  1. Missing the index that supports the shard key
  2. The only remaining index compatible with shard key is multikey (SERVER-67299)
  3. Consistent indexes across shards:
    • A sharded collection has an inconsistent index if the collection does not have the exact same indexes (including the index options) on each shard that contains chunks for the collection.
    • Inconsistent indexes can occur, when a user is creating an index with a unique key constraint and one shard contains a chunk with duplicate documents.


 Comments   
Comment by Githook User [ 23/Mar/23 ]

Author:

{'name': 'toto', 'email': '58224719+toto-dev@users.noreply.github.com', 'username': 'toto-dev'}

Message: SERVER-72895 Implement shardKey index check in checkConsistencyMetadata command
Branch: master
https://github.com/mongodb/mongo/commit/9126abbbdd97408118c16cdcec3d30351ecc31ca

Comment by Githook User [ 09/Mar/23 ]

Author:

{'name': 'Pol Pinol Castuera', 'email': 'pol.pinol@mongodb.com', 'username': 'PolPinol'}

Message: Revert "SERVER-72895 Implement shardKey index check in checkConsistencyMetadata command"

This reverts commit aecc384eca15c238950cb9079648702a2e5eadfe.
Branch: master
https://github.com/mongodb/mongo/commit/569a71cd8b1a3690afef8e1a3d19e3c58c8342db

Comment by Githook User [ 08/Mar/23 ]

Author:

{'name': 'Pol Pinol Castuera', 'email': 'pol.pinol@mongodb.com', 'username': 'PolPinol'}

Message: SERVER-72895 Implement shardKey index check in checkConsistencyMetadata command
Branch: master
https://github.com/mongodb/mongo/commit/aecc384eca15c238950cb9079648702a2e5eadfe

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