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

mongos are having different data in shared cluster

    • Type: Icon: Bug Bug
    • Resolution: Cannot Reproduce
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 3.0.6
    • Component/s: 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

      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)

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

              Created:
              Updated:
              Resolved: