sh.status() not reflecting dropped databases

XMLWordPrintableJSON

    • Linux
    • Hide

      1. log into mongo shell in both primaries.
      2. db.dropDatabase()
      3. log into mongo shell for mongos
      4. sh.status()

      Show
      1. log into mongo shell in both primaries. 2. db.dropDatabase() 3. log into mongo shell for mongos 4. sh.status()
    • None
    • 0
    • None
    • None
    • None
    • None
    • None
    • None

      Setup:
      Two shards both in 3-member replica set

      Problem:
      sh.status() not reflecting changes, still shows databases that are dropped.

      In all members of replica set:

      s1:PRIMARY> show dbs
      admin   (empty)
      config  (empty)
      local   1.03076171875GB
      
      s0:PRIMARY> show dbs
      admin   (empty)
      config  (empty)
      local   1.03076171875GB
      

      But in mongos:

      mongos> sh.status()
      --- Sharding Status ---
        sharding version: {
              "_id" : 1,
              "version" : 3,
              "minCompatibleVersion" : 3,
              "currentVersion" : 4,
              "clusterId" : ObjectId("52379d1365ee53adcc8cad42")
      }
        shards:
              {  "_id" : "s0",  "host" : "s0/chelarcpoc008.karmalab.net:27017,chelarcpoc009.karmalab.net:27017,chelarcpoc010.karmalab.net:27017" }
              {  "_id" : "s1",  "host" : "s1/chelarcpoc011.karmalab.net:27017,chelarcpoc012.karmalab.net:27017,chelarcpoc013.karmalab.net:27017" }
        databases:
              {  "_id" : "enron",  "partitioned" : true,  "primary" : "s0" }
                      enron.messages
                              shard key: { "headers.From" : 1 }
                              chunks:
                                      s1      6
                                      s0      7
                              { "headers.From" : { "$minKey" : 1 } } -->> { "headers.From" : "bruce.lundstrom@enron.com" } on : s1 Timestamp(2, 0)
                              { "headers.From" : "bruce.lundstrom@enron.com" } -->> { "headers.From" : "dan.dietrich@enron.com" } on : s1 Timestamp(3, 0)
                              { "headers.From" : "dan.dietrich@enron.com" } -->> { "headers.From" : "e..haedicke@enron.com" } on : s1 Timestamp(4, 0)
                              { "headers.From" : "e..haedicke@enron.com" } -->> { "headers.From" : "ginger.dernehl@enron.com" } on : s1 Timestamp(5, 0)
                              { "headers.From" : "ginger.dernehl@enron.com" } -->> { "headers.From" : "jeffrey.shankman@enron.com" } on : s1 Timestamp(6, 0)
                              { "headers.From" : "jeffrey.shankman@enron.com" } -->> { "headers.From" : "kevinscott@onlinemailbox.net" } on : s1 Timestamp(7, 0)
                              { "headers.From" : "kevinscott@onlinemailbox.net" } -->> { "headers.From" : "marcus.nettelton@enron.com" } on : s0 Timestamp(7, 1)
                              { "headers.From" : "marcus.nettelton@enron.com" } -->> { "headers.From" : "michael.tribolet@enron.com" } on : s0 Timestamp(1, 7)
                              { "headers.From" : "michael.tribolet@enron.com" } -->> { "headers.From" : "phillip.love@enron.com" } on : s0 Timestamp(1, 8)
                              { "headers.From" : "phillip.love@enron.com" } -->> { "headers.From" : "rudwell.johnson@enron.com" } on : s0 Timestamp(1, 9)
                              { "headers.From" : "rudwell.johnson@enron.com" } -->> { "headers.From" : "stanley.horton@enron.com" } on : s0 Timestamp(1, 10)
                              { "headers.From" : "stanley.horton@enron.com" } -->> { "headers.From" : "trials@stockbottom.com" } on : s0 Timestamp(1, 11)
                              { "headers.From" : "trials@stockbottom.com" } -->> { "headers.From" : { "$maxKey" : 1 } } on : s0 Timestamp(1, 12)
              {  "_id" : "admin",  "partitioned" : false,  "primary" : "config" }
              {  "_id" : "dummy",  "partitioned" : false,  "primary" : "s1" }
              {  "_id" : "test",  "partitioned" : false,  "primary" : "s0" }
      

      Why is sh.status() still showing databases that I've deleted? Almost an hour now.

            Assignee:
            Unassigned
            Reporter:
            Howard Lee
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: