[DOCS-3820] Limitation on covered queries for sharding should also be included in the covered index tutorial Created: 25/Jul/14  Updated: 28/Jan/15  Resolved: 22/Dec/14

Status: Closed
Project: Documentation
Component/s: manual
Affects Version/s: mongodb-2.6
Fix Version/s: v1.3.9, v1.3.16

Type: Task Priority: Major - P3
Reporter: Stennie Steneker (Inactive) Assignee: Kay Kim (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
is related to DOCS-4571 In 2.8 sharded clusters support cover... Closed
Participants:
Days since reply: 9 years, 3 weeks ago

 Description   

Due to SERVER-5022, it is currently not possible to have fully covered sharded queries.

This is noted in the Limits section of the manual: http://docs.mongodb.org/manual/reference/limits/#Covered-Queries-in-Sharded-Clusters

.. but not mentioned in the tutorial on creating covered queries:
http://docs.mongodb.org/manual/tutorial/create-indexes-to-support-queries/#create-indexes-that-support-covered-queries



 Comments   
Comment by Kay Kim (Inactive) [ 28/Jan/15 ]

no worries : )

Comment by Ori Avtalion [ 28/Jan/15 ]

My bad. I assumed it was a regression. It's a new feature, and documented in the 2.8 release notes in the General Improvements section.

Comment by Kay Kim (Inactive) [ 28/Jan/15 ]

Hi Ori –
Sure. Once we have the new ticket, we can schedule it and such.

Kay

Comment by Ori Avtalion [ 28/Jan/15 ]

If this limitation is a regression from 2.4 to 2.6, it should be added to the 2.6 release notes (specifically, the Compatibility Changes).

Should I open a new bug?

Comment by Kay Kim (Inactive) [ 23/Dec/14 ]

no worries.

Comment by Gianfranco Palumbo [ 23/Dec/14 ]

you're right, sorry.

thanks for this

Comment by Githook User [ 22/Dec/14 ]

Author:

{u'username': u'kay-kim', u'name': u'kay', u'email': u'kay.kim@10gen.com'}

Message: DOCS-3820 reorder covered query limitations list
Branch: v2.6
https://github.com/mongodb/docs/commit/f69bdc239721030bf3426c3d555f6686d0446e39

Comment by Githook User [ 22/Dec/14 ]

Author:

{u'username': u'kay-kim', u'name': u'kay', u'email': u'kay.kim@10gen.com'}

Message: DOCS-3820 reorder covered query limitations list
Branch: v2.4
https://github.com/mongodb/docs/commit/1ff613fb36c7d1a22300553e78d7267a66e0d430

Comment by Kay Kim (Inactive) [ 22/Dec/14 ]

The tutorial for covering a query has moved to this page: http://docs.mongodb.org/manual/core/query-optimization/#covering-a-query
and the limitation regarding the covered indexes is in the subsection http://docs.mongodb.org/manual/core/query-optimization/#limitations
and the sharded collection is the last bulleted point in the list (line 160-161 in the commit)

I'll move that last bulleted point up for higher visibility.

Comment by Gianfranco Palumbo [ 21/Dec/14 ]

Reopening this ticket after the limitation has been removed again from this tutorial (DOCS-2473):
https://github.com/mongodb/docs/commit/f3e1d02e82ccac429a30175d125bda8226ca5d66

Maybe we can just point out to this limitations section:
http://docs.mongodb.org/manual/core/query-optimization/#limitations

Please note that in 2.8 this has changed: DOCS-4571

Comment by Githook User [ 06/Aug/14 ]

Author:

{u'username': u'kay-kim', u'name': u'kay', u'email': u'kay.kim@10gen.com'}

Message: DOCS-3820 covered indexes and sharded collections
Branch: v2.4
https://github.com/mongodb/docs/commit/80d372f2c75a94c47f414882aa37d4d2b72b1c50

Comment by Githook User [ 06/Aug/14 ]

Author:

{u'username': u'kay-kim', u'name': u'kay', u'email': u'kay.kim@10gen.com'}

Message: DOCS-3820 covered indexes and sharded collections
Branch: master
https://github.com/mongodb/docs/commit/955fdbe3f8ce6bae3e7f8affb49c28f32b373a24

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