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

Sync Issue on sharded cluster

    • Type: Icon: Bug Bug
    • Resolution: Incomplete
    • Priority: Icon: Major - P3 Major - P3
    • None
    • Affects Version/s: 3.4.10
    • Component/s: None
    • Environment:
      Windows Server 2016

      I am having 3 Servers 3 ReplicaSet and 3 Shards. I have manually deleted database and its recreated using server application. Now in 2 server if I access data it is in sync buy 1 server is working as is own not in sync. Please some one help me.

      Before deleting it was working fine. All the 3 server database were in sync. If I do rs.status() and sh.status() its output looks ok to me if some one can check this It will be appreciated.

      r3:SECONDARY> rs.status()
      {
              "set" : "r3",
              "date" : ISODate("2017-10-25T07:23:29.279Z"),
              "myState" : 2,
              "term" : NumberLong(9),
              "syncingTo" : "10.0.0.6:30013",
              "heartbeatIntervalMillis" : NumberLong(2000),
              "optimes" : {
                      "lastCommittedOpTime" : {
                              "ts" : Timestamp(1508916202, 1),
                              "t" : NumberLong(9)
                      },
                      "appliedOpTime" : {
                              "ts" : Timestamp(1508916202, 1),
                              "t" : NumberLong(9)
                      },
                      "durableOpTime" : {
                              "ts" : Timestamp(1508916202, 1),
                              "t" : NumberLong(9)
                      }
              },
              "members" : [
                      {
                              "_id" : 0,
                              "name" : "10.0.0.6:30013",
                              "health" : 1,
                              "state" : 1,
                              "stateStr" : "PRIMARY",
                              "uptime" : 925313,
                              "optime" : {
                                      "ts" : Timestamp(1508916202, 1),
                                      "t" : NumberLong(9)
                              },
                              "optimeDurable" : {
                                      "ts" : Timestamp(1508916202, 1),
                                      "t" : NumberLong(9)
                              },
                              "optimeDate" : ISODate("2017-10-25T07:23:22Z"),
                              "optimeDurableDate" : ISODate("2017-10-25T07:23:22Z"),
                              "lastHeartbeat" : ISODate("2017-10-25T07:23:28.588Z"),
                              "lastHeartbeatRecv" : ISODate("2017-10-25T07:23:28.024Z"),
                              "pingMs" : NumberLong(0),
                              "electionTime" : Timestamp(1507990921, 1),
                              "electionDate" : ISODate("2017-10-14T14:22:01Z"),
                              "configVersion" : 5
                      },
                      {
                              "_id" : 1,
                              "name" : "10.0.0.4:30013",
                              "health" : 1,
                              "state" : 2,
                              "stateStr" : "SECONDARY",
                              "uptime" : 925340,
                              "optime" : {
                                      "ts" : Timestamp(1508916202, 1),
                                      "t" : NumberLong(9)
                              },
                              "optimeDate" : ISODate("2017-10-25T07:23:22Z"),
                              "syncingTo" : "10.0.0.6:30013",
                              "configVersion" : 5,
                              "self" : true
                      },
                      {
                              "_id" : 2,
                              "name" : "10.0.0.5:30013",
                              "health" : 1,
                              "state" : 2,
                              "stateStr" : "SECONDARY",
                              "uptime" : 925313,
                              "optime" : {
                                      "ts" : Timestamp(1508916202, 1),
                                      "t" : NumberLong(9)
                              },
                              "optimeDurable" : {
                                      "ts" : Timestamp(1508916202, 1),
                                      "t" : NumberLong(9)
                              },
                              "optimeDate" : ISODate("2017-10-25T07:23:22Z"),
                              "optimeDurableDate" : ISODate("2017-10-25T07:23:22Z"),
                              "lastHeartbeat" : ISODate("2017-10-25T07:23:28.600Z"),
                              "lastHeartbeatRecv" : ISODate("2017-10-25T07:23:28.558Z"),
                              "pingMs" : NumberLong(0),
                              "syncingTo" : "10.0.0.4:30013",
                              "configVersion" : 5
                      }
              ],
              "ok" : 1
      }
      
      mongos> sh.status()
      --- Sharding Status ---
        sharding version: {
              "_id" : 1,
              "minCompatibleVersion" : 5,
              "currentVersion" : 6,
              "clusterId" : ObjectId("598df72eee032936603c5e81")
      }
        shards:
              {  "_id" : "r1",  "host" : "r1/10.0.0.4:30011,10.0.0.5:30011,10.0.0.6:30011",  "state" : 1 }
              {  "_id" : "r2",  "host" : "r2/10.0.0.4:30012,10.0.0.5:30012,10.0.0.6:30012",  "state" : 1 }
              {  "_id" : "r3",  "host" : "r3/10.0.0.4:30013,10.0.0.5:30013,10.0.0.6:30013",  "state" : 1 }
        active mongoses:
              "3.4.7" : 3
       autosplit:
              Currently enabled: yes
        balancer:
              Currently enabled:  yes
              Currently running:  no
                      Balancer lock taken at Sat Oct 14 2017 14:21:46 GMT+0000 (Coordinated Universal Time) by ConfigServer:Balancer
              Failed balancer rounds in last 5 attempts:  3
              Last reported error:  could not find host matching read preference { mode: "primary" } for set r1
              Time of Reported error:  Sat Aug 12 2017 06:47:04 GMT+0000 (Coordinated Universal Time)
              Migration Results for the last 24 hours:
                      No recent migrations
        databases:
              {  "_id" : "TestAiCraftDatabase3",  "primary" : "r2",  "partitioned" : false }
              {  "_id" : "XyZDB",  "primary" : "r2",  "partitioned" : false }
      
      

        1. image.png
          78 kB
          Kalpesh Chheda [X]
        2. MongodbPerServerConfig.txt
          2 kB
          Kalpesh Chheda [X]

            Assignee:
            mark.agarunov Mark Agarunov
            Reporter:
            KalpeshChheda Kalpesh Chheda [X]
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: