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

multiple mongos are having different data

XMLWordPrintableJSON

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 3.0.6
    • Component/s: Sharding, WiredTiger
    • None
    • ALL
    • Hide

      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> use db2
switched to db db2
mongos> db.inventories.count()
140714
mongos> ^C


On 10.14.17.245 (mongos2)
Before restart:
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> 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
      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> use db2 switched to db db2 mongos> db.inventories.count() 140714 mongos> ^C On 10.14.17.245 (mongos2) Before restart: 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> 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: