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

mongos are having different data in shared cluster

    XMLWordPrintable

Details

    • Bug
    • Status: Closed
    • Major - P3
    • Resolution: Cannot Reproduce
    • 3.0.6
    • None
    • Sharding
    • None
    • ALL
    • Hide

      We have a sharded cluster of mongo 3.0.6, having 2 shards, 3 config servers and 3 mongos.
      In this cluster we are having multiple databases, eg. db1,db2 and db3.

      In this cluster we are having multiple databases, eg. db1,db2 and db3

      db1 > shard1 primary (not sharded)
      db2 > shard1 primary (not sharded)
      db3 > shard2 primary (not sharded)
      mongos1 , mongos2, mongos3 > three mongos
       
      On 10.14.4.121 (mongos1)
      mongos> use admin
      mongos> db.runCommand(
      { movePrimary: "db2", to: "shard1" }
      )
      mongos> db.runCommand({flushRouterConfig: 1})
      mongos> use db2
      switched to db db2
      mongos> db.inventories.count()
      140714
      mongos> ^C
       
      On 10.14.17.245 (mongos2)
      Before restart:
      mongos> db.runCommand({flushRouterConfig: 1})
      mongos> use db2
      switched to db db2
      mongos> db.inventories.count()
      28
      After mongos2 Restart:
      mongos> use db2
      switched to db db2
      mongos> db.inventories.count()
      140714
       
      On 10.14.2.71 (mongos3)
      Before Restart:
      mongos> db.runCommand({flushRouterConfig: 1})
      mongos> use db2
      switched to db db2
      mongos> db.inventories.count()
      25
      After Restart:
      mongos> use db2
      switched to db db2
      mongos> db.inventories.count()
      140714
      

      Show
      We have a sharded cluster of mongo 3.0.6, having 2 shards, 3 config servers and 3 mongos. In this cluster we are having multiple databases, eg. db1,db2 and db3. In this cluster we are having multiple databases, eg. db1,db2 and db3 db1 > shard1 primary (not sharded) db2 > shard1 primary (not sharded) db3 > shard2 primary (not sharded) mongos1 , mongos2, mongos3 > three mongos   On 10.14.4.121 (mongos1) mongos> use admin mongos> db.runCommand( { movePrimary: "db2", to: "shard1" } ) mongos> db.runCommand({flushRouterConfig: 1}) mongos> use db2 switched to db db2 mongos> db.inventories.count() 140714 mongos> ^C   On 10.14.17.245 (mongos2) Before restart: mongos> db.runCommand({flushRouterConfig: 1}) mongos> use db2 switched to db db2 mongos> db.inventories.count() 28 After mongos2 Restart: mongos> use db2 switched to db db2 mongos> db.inventories.count() 140714   On 10.14.2.71 (mongos3) Before Restart: mongos> db.runCommand({flushRouterConfig: 1}) mongos> use db2 switched to db db2 mongos> db.inventories.count() 25 After Restart: mongos> use db2 switched to db db2 mongos> db.inventories.count() 140714

    Description

      Hi,
      We have a sharded cluster of mongo 3.0.6, having 2 shards, 3 config servers and 3 mongos.
      In this cluster we are having multiple databases, eg. db1,db2 and db3

      db1 > shard1 primary (not sharded)
      db2 > shard2 primary (not sharded)
      db3 > shard2 primary (not sharded)
      

      After moving primary of db2 database from shard2 to shard1, after that all three mongos are showing different document counts (the one mongos from where we are running move primary command is showing right data, other two mongos are showing wrong data)

      Attachments

        Issue Links

          Activity

            People

              kelsey.schubert@mongodb.com Kelsey T Schubert
              rakesh.mib.j@gmail.com Rakesh Kumar
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: