Details
-
Bug
-
Resolution: Incomplete
-
Major - P3
-
None
-
3.4.10
-
None
-
Windows Server 2016
Description
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 }
|
|