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

dropDatabase command failed to drop database from all shards.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Critical - P2
    • Resolution: Gone away
    • Affects Version/s: 2.4.6
    • Fix Version/s: None
    • Component/s: Sharding
    • Labels:
    • Environment:
      OEL linux
    • Operating System:
      Linux
    • Steps To Reproduce:
      Hide

      Insert 100 GB data to sharding cluster for database_1.
      Now start inserting data to database_2.
      Run dropDatabase command from mongos for database_1 (while insertion is going on database_2) .

      Show
      Insert 100 GB data to sharding cluster for database_1. Now start inserting data to database_2. Run dropDatabase command from mongos for database_1 (while insertion is going on database_2) .

      Description

      Hi,

      We have following configuration of mongodb:(journal enabled)
      On machines-1 have following servers
      mongod - 5
      config server - 2
      mongos - 1
      On machines-2 have following servers
      mongod - 5
      config server - 1

      We ran dropDatabase command from mongos, got below error:
      mongos> db.dropDatabase()
      {
      "assertion" : "DBClientBase::findN: transport error: 192.168.50.222:20000 query:

      { dropDatabase: 1 }

      ",
      "assertionCode" : 10276,
      "errmsg" : "db assertion failure",
      "ok" : 0
      }

      dropDatabase dropped the database only from shard1.
      database was not deleted from shard2 to shard10.

      i again ran dropDatabase command from mongos and get "ok"
      mongos> db.dropDatabase()

      { "dropped" : "00031013", "ok" : 1 }

      but database was not deleted from shard2 to shard10.

      We got below log in mongos:
      couldn't find database [00031013] in config db

      I have following questions:
      1. How can we drop the database in above condition:
      2. what does mean by "couldn't find database [00031013] in config db" ?
      3. Any other way to remove database files apart from dropDatabase?

      please help me to resolve this issue

      T&R,
      JRV

        Attachments

          Activity

            People

            • Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: