[SERVER-1016] when a key too large for index how does it affect queries Created: 13/Apr/10  Updated: 24/Jun/13  Resolved: 13/Apr/10

Status: Closed
Project: Core Server
Component/s: Index Maintenance
Affects Version/s: 1.4.0
Fix Version/s: None

Type: Question Priority: Major - P3
Reporter: Ben Wyrosdick Assignee: Eliot Horowitz (Inactive)
Resolution: Done Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Related
related to SERVER-5290 fail to insert docs with fields too l... Closed
Participants:

 Description   

In one db there are some items that are too large for the index and so they get skipped ... here is a log snippet ...

Tue Mar 30 16:18:03 future-production.system.indexes Btree::insert: key too large to index, skipping future-production.quotations.$graph_1 1453 { : { rdf:

{ type: "quotation:quotation" }

, dcterms:

{ title: null, source: "U.S. Congressional Record" }

, quotation:

{ said_on: new Date(1173373205000), reporter: "http://pius.me", organizationSpokenTo: "http://dbpedia.org/page/United_States_Senate", subject: null, evidence: "http://frwebgate.access.gpo.gov/cgi-bin/getpage.cgi?position=page&page...", venue: "http://dbpedia.org/page/United_States_Senate", primary_source: "U.S. Congressional Record", speaker_bioguide_id: "300047", body: "I think after a lot of give and take and after a lot of court decision..." }

} }

When this happens and you query later on that collection that would use the index what does mongodb do? Does it just omit those documents in the results since they didn't make it into the index ... or does it skip that index and do scans since it knows it has missing documents?



 Comments   
Comment by Eliot Horowitz (Inactive) [ 13/Apr/10 ]

the object won't appear in queries that use that index.

Comment by Ben Wyrosdick [ 13/Apr/10 ]

Sorry ... didn't mean to make it major .. it is just a minor priority

Generated at Thu Feb 08 02:55:49 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.