Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-2712

unable to delete index

    XMLWordPrintableJSON

Details

    • Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Icon: Major - P3 Major - P3
    • None
    • 1.8.0-rc1
    • None
    • None
    • ALL

    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.

      Attachments

        Activity

          People

            kristina Kristina Chodorow (Inactive)
            kristina Kristina Chodorow (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: