-
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 }
