[SERVER-13299] Can't create 2dsphere index Created: 20/Mar/14  Updated: 10/Dec/14  Resolved: 25/Mar/14

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

Type: Bug Priority: Major - P3
Reporter: Miguel G Assignee: Joanna Cheng
Resolution: Duplicate Votes: 0
Labels: 2dsphere, index
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Issue Links:
Duplicate
duplicates SERVER-12481 attempting to create a 10th index, wi... Closed
Operating System: ALL
Participants:

 Description   

Hi

I have a collection on which I want to create a 2dsphere index. When I run the following command for the first time:

db.collection.ensureIndex(

{ "departures.location": "2dsphere", type: 1 }

)

I get the following error:

{
"err" : "missing Extra",
"code" : 14045,
"n" : 0,
"lastOp" : Timestamp(1394817812, 1),
"connectionId" : 73881,
"ok" : 1
}

Then I run the same command again, and I get this error:

{
"err" : "getFile(): bad file number value (corrupt db?): run repair",
"code" : 10295,
"n" : 0,
"lastOp" : Timestamp(1394817812, 1),
"connectionId" : 73881,
"ok" : 1
}

I run repairDatabase, and the same happens again.

Funny thing is that I cloned the collection without the current indexes, and I can create the 2dsphere index fine in this new collection. So it has to be something related to the current indexes.

Current indexes are:

{
"_id": NumberInt(1)
}
{
"tags.en": 1
}
{
"type": 1,
"name_es": 1,
"priority": -1,
"price_adult.EUR": 1
}
{
"type": 1,
"name_en": 1,
"priority": -1,
"price_adult.EUR": 1
}
{
"_fts": "text",
"_ftsx": NumberInt(1)
}
{
"tags.es": 1
}
{
"type": 1,
"belongs_to_destination": 1,
"priority": -1
}
{
"type": 1,
"related_destination": 1
}



 Comments   
Comment by Daniel Pasette (Inactive) [ 25/Mar/14 ]

duplicate of SERVER-12481

Generated at Thu Feb 08 03:31:16 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.