[SERVER-2712] unable to delete index Created: 08/Mar/11  Updated: 29/Feb/12  Resolved: 02/Sep/11

Status: Closed
Project: Core Server
Component/s: None
Affects Version/s: 1.8.0-rc1
Fix Version/s: None

Type: Bug Priority: Major - P3
Reporter: Kristina Chodorow (Inactive) Assignee: Kristina Chodorow (Inactive)
Resolution: Cannot Reproduce Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified

Operating System: ALL
Participants:

 Description   

https://jira.mongodb.org/browse/SERVER-2709 seems to have messed up all of the indexes in other members of the set. A majority of the set is up and healthy, but now I can't delete any indexes from the collection.

> // db == mongos
> db.c.getIndexes()
[
{
"name" : "id",
"ns" : "test.c",
"key" :

{ "_id" : 1 }

,
"v" : 0
},
{
"ns" : "test.c",
"key" :

{ "random" : 1 }

,
"name" : "random_1",
"v" : 0
},
{
"_id" : ObjectId("4d7695200745733482c8f86f"),
"ns" : "test.c",
"key" :

{ "_id" : 1, "random" : -1 }

,
"name" : "id_1_random-1",
"v" : 0
},
{
"_id" : ObjectId("4d7697a70745733482c8f870"),
"ns" : "test.c",
"key" :

{ "id" : -1, "random" : -1 }

,
"name" : "id_-1_random_-1",
"background" : true,
"v" : 0
}
]
> db.runCommand(

{"deleteIndexes" :"test.c", index : "_id_1_random_-1"}

)
{
"raw" : {
"bar/ec2-50-17-62-250.compute-1.amazonaws.com:27018,ec2-67-202-41-42.compute-1.amazonaws.com:27019,ec2-50-16-149-199.compute-1.amazonaws.com:27018" :

{ "errmsg" : "ns not found", "ok" : 0 }

},
"ok" : 0,
"errmsg" : "

{ bar/ec2-50-17-62-250.compute-1.amazonaws.com:27018,ec2-67-202-41-42.compute-1.amazonaws.com:27019,ec2-50-16-149-199.compute-1.amazonaws.com:27018: \"ns not found\" }

"
> r = connect("ec2-50-17-62-250.compute-1.amazonaws.com:27018/admin")
connecting to: ec2-50-17-62-250.compute-1.amazonaws.com:27018/admin
admin
bar:SECONDARY> r.runCommand(

{replSetGetStatus:1}

)
{
"set" : "bar",
"date" : ISODate("2011-03-08T21:47:57Z"),
"myState" : 2,
"members" : [
{
"_id" : 0,
"name" : "ec2-50-16-149-199.compute-1.amazonaws.com:27018",
"health" : 1,
"state" : 1,
"stateStr" : "PRIMARY",
"uptime" : 10954,
"optime" :

{ "t" : 1299620875000, "i" : 2 }

,
"optimeDate" : ISODate("2011-03-08T21:47:55Z"),
"lastHeartbeat" : ISODate("2011-03-08T21:47:56Z")
},
{
"_id" : 1,
"name" : "ec2-50-17-62-250.compute-1.amazonaws.com:27018",
"health" : 1,
"state" : 2,
"stateStr" : "SECONDARY",
"optime" :

{ "t" : 1299620874000, "i" : 4 }

,
"optimeDate" : ISODate("2011-03-08T21:47:54Z"),
"self" : true
},
{
"_id" : 2,
"name" : "ec2-67-202-41-42.compute-1.amazonaws.com:27019",
"health" : 0,
"state" : 3,
"stateStr" : "(not reachable/healthy)",
"uptime" : 0,
"optime" :

{ "t" : 1299618206000, "i" : 3 }

,
"optimeDate" : ISODate("2011-03-08T21:03:26Z"),
"lastHeartbeat" : ISODate("2011-03-08T21:04:06Z"),
"errmsg" : "socket exception"
}
],
"ok" : 1
}
bar:SECONDARY> r.getSisterDB("test").system.namespaces.find()

{ "name" : "test.system.indexes" } { "name" : "test.foo" } { "name" : "test.foo.$_id_" } { "name" : "test.foo.$x_1" } { "name" : "test.c" } { "name" : "test.c.$_id_" } { "name" : "test.c.$random_1" } { "name" : "test.c.$_id_1_random_-1" } { "name" : "test.c.$id_-1_random_-1" }

Attempting to drop any index through mongos gives the same message.


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