[SERVER-52528] test using an index on a time-series collection as shard key Created: 31/Oct/20  Updated: 29/Oct/23  Resolved: 18/Mar/21

Status: Closed
Project: Core Server
Component/s: Storage
Affects Version/s: None
Fix Version/s: 4.9.0

Type: Task Priority: Major - P3
Reporter: Benety Goh Assignee: Louis Williams
Resolution: Fixed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Depends
Documented
Problem/Incident
Related
related to SERVER-55272 Queries on sharded time-series bucket... Closed
related to SERVER-55653 Queries on time-series views do not a... Closed
is related to SERVER-55426 Investigate work to support inserts o... Closed
is related to SERVER-55809 Disallow sharding a time-series colle... Closed
Backwards Compatibility: Fully Compatible
Sprint: Execution Team 2021-03-22
Participants:
Linked BF Score: 0

 Description   

We should allow a time-series collection to be sharded with a shard key on one of the existing indexes. Sharded time-series collections need to work with collation in the following scenarios:

  • Time-series collection created with the default collation
  • Sharding a time-series collection with a non-default collation.

========= OLD DESCRIPTION =======
A router (mongos) attempting an insert into a collection C, either already knows C is a time-series collection, or will receive an error return informing it of that fact. This error return must include information on what fields are the metadata and time fields. The router must be updated to check routing information for the buckets table to determine what shard to send an insert for a time-series collection to.



 Comments   
Comment by Louis Williams [ 18/Mar/21 ]

I filed SERVER-55272 to fix a bug where the shard filter is not applied for some queries.

Comment by Githook User [ 18/Mar/21 ]

Author:

{'name': 'Louis Williams', 'email': 'louis.williams@mongodb.com', 'username': 'louiswilliams'}

Message: SERVER-52528 Test queries on sharded time-series collections
Branch: master
https://github.com/mongodb/mongo/commit/926ee400907f538c8eb240d97cb292797cd60571

Comment by Githook User [ 18/Mar/21 ]

Author:

{'name': 'Pierlauro Sciarelli', 'email': 'pierlauro.sciarelli@mongodb.com', 'username': 'pierlauro'}

Message: Revert "SERVER-52528 Test queries on sharded time-series collections"

This reverts commit 96319a93464d82deb5749c27aee3e71352fbc8a6.
Branch: master
https://github.com/mongodb/mongo/commit/1299785257ac51faa99cc8197b4b89ed4502489b

Comment by Githook User [ 17/Mar/21 ]

Author:

{'name': 'Louis Williams', 'email': 'louis.williams@mongodb.com', 'username': 'louiswilliams'}

Message: SERVER-52528 Test queries on sharded time-series collections
Branch: master
https://github.com/mongodb/mongo/commit/96319a93464d82deb5749c27aee3e71352fbc8a6

Comment by Githook User [ 16/Mar/21 ]

Author:

{'name': 'Louis Williams', 'email': 'louis.williams@mongodb.com', 'username': 'louiswilliams'}

Message: Revert "SERVER-52528 Test queries on sharded time-series collections"

This reverts commit 64595e343ef4523e53e6b2abea8d9dfcfb3a8259.
Branch: master
https://github.com/mongodb/mongo/commit/751b66eee4b176fde63a835c9b70c6ae457c4af6

Comment by Githook User [ 16/Mar/21 ]

Author:

{'name': 'Louis Williams', 'email': 'louis.williams@mongodb.com', 'username': 'louiswilliams'}

Message: SERVER-52528 Test queries on sharded time-series collections
Branch: master
https://github.com/mongodb/mongo/commit/64595e343ef4523e53e6b2abea8d9dfcfb3a8259

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