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

sh.status() not reflecting dropped databases

    • 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()

      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 Unassigned
            Reporter:
            holee@expedia.com Howard Lee
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Created:
              Updated:
              Resolved: