问题一
服务器重启后同样的查询没再出错。
问题一日志及问题二存储过程见附件。
问题二执行存储过程语句:
var rc=db.hero.t_user.count();var ic=parseInt((rc+10000000)/10000000)*10000000;db.eval("db_test3("+rc+","+(ic-rc)+",5000)")
//执行插入10000000条,每5000条批量插入一次,如果出错了再次执行以便凑成整千万条数据。
附件:
测试集群组结构:
> db.listReplicaGroups()
{
"Group": [
{
"HostName": "sdbserver2",
"Status": 1,
"dbpath": "/opt/sequoiadb/database/cata/11800/",
"Service": [
{
"Type": 0,
"Name": "11800"
},
{
"Type": 1,
"Name": "11801"
},
{
"Type": 2,
"Name": "11802"
},
{
"Type": 3,
"Name": "11803"
}
],
"NodeID": 2
},
{
"HostName": "sdbserver1",
"Status": 1,
"dbpath": "/opt/sequoiadb/database/cata/11800/",
"Service": [
{
"Type": 0,
"Name": "11800"
},
{
"Type": 1,
"Name": "11801"
},
{
"Type": 2,
"Name": "11802"
},
{
"Type": 3,
"Name": "11803"
}
],
"NodeID": 6
}
],
"GroupID": 1,
"GroupName": "SYSCatalogGroup",
"PrimaryNode": 6,
"Role": 2,
"Status": 1,
"Version": 42,
"_id": {
"$oid": "59157131d34f610ad6ee171a"
}
}
{
"Group": [
{
"HostName": "sdbserver1",
"Status": 1,
"dbpath": "/opt/sequoiadb/database/data/11820/",
"Service": [
{
"Type": 0,
"Name": "11820"
},
{
"Type": 1,
"Name": "11821"
},
{
"Type": 2,
"Name": "11822"
}
],
"NodeID": 1004
}
],
"GroupID": 1000,
"GroupName": "datagroup",
"PrimaryNode": 1004,
"Role": 0,
"Status": 1,
"Version": 22,
"_id": {
"$oid": "59157200d34f610ad6ee171e"
}
}
{
"Group": [
{
"HostName": "sdbserver2",
"dbpath": "/opt/sequoiadb/database/coord/11810",
"Service": [
{
"Type": 0,
"Name": "11810"
},
{
"Type": 1,
"Name": "11811"
},
{
"Type": 2,
"Name": "11812"
}
],
"NodeID": 5,
"Status": 1
},
{
"HostName": "sdbserver1",
"dbpath": "/opt/sequoiadb/database/cata/11810",
"Service": [
{
"Type": 0,
"Name": "11810"
},
{
"Type": 1,
"Name": "11811"
},
{
"Type": 2,
"Name": "11812"
}
],
"NodeID": 7,
"Status": 1
}
],
"GroupID": 2,
"GroupName": "SYSCoord",
"Role": 1,
"Status": 1,
"Version": 5,
"_id": {
"$oid": "59157293d34f610ad6ee171f"
}
}
{
"Group": [
{
"HostName": "sdbserver2",
"Status": 1,
"dbpath": "/opt/sequoiadb/database/data/11820/",
"Service": [
{
"Type": 0,
"Name": "11820"
},
{
"Type": 1,
"Name": "11821"
},
{
"Type": 2,
"Name": "11822"
}
],
"NodeID": 1005
}
],
"GroupID": 1002,
"GroupName": "datagroup2",
"PrimaryNode": 1005,
"Role": 0,
"Status": 1,
"Version": 3,
"_id": {
"$oid": "592250b45bd89916f57062d2"
}
}
{
"Group": [
{
"HostName": "sdbserver3",
"Status": 1,
"dbpath": "/opt/sequoiadb/database/data/11820/",
"Service": [
{
"Type": 0,
"Name": "11820"
},
{
"Type": 1,
"Name": "11821"
},
{
"Type": 2,
"Name": "11822"
}
],
"NodeID": 1007
}
],
"GroupID": 1003,
"GroupName": "datagroup3",
"PrimaryNode": 1007,
"Role": 0,
"Status": 1,
"Version": 5,
"_id": {
"$oid": "592251675bd89916f57062d3"
}
}