-
Type: Bug
-
Resolution: Incomplete
-
Priority: 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 }