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

multiple mongos are having different data

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Duplicate
    • Affects Version/s: 3.0.6
    • Fix Version/s: None
    • Component/s: Sharding, WiredTiger
    • Labels:
      None
    • Operating System:
      ALL
    • Steps To Reproduce:
      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

      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

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

                Dates

                Created:
                Updated:
                Resolved: