Skip to content

Instantly share code, notes, and snippets.

@no7dw

no7dw/currentOp-waitingForLock-true

Created December 21, 2019 11:15
Show Gist options
  • Save no7dw/3a7303eb2776063ee7017c5074719163 to your computer and use it in GitHub Desktop.
Save no7dw/3a7303eb2776063ee7017c5074719163 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
currentOp-waitingForLock-true
[
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6265179",
"connectionId" : 6265179.0,
"client" : "10.8.88.229:1478",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "3.3.2"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.4.0, LE, mongodb-core: 3.3.2"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951010.0,
"lsid" : {
"id" : UUID("dc3ff1d9-1372-4601-95f7-18ab9fc844e8"),
"uid" : BinData(0, "p3XUolfQdFzJ2a5D1MVQybdfT5p6L7Pz.. 8 more bytes")
},
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(632091),
"op" : "query",
"ns" : "p2p.Account",
"command" : {
"find" : "Account",
"filter" : {
"userId" : "560643aba8e70ae707de6ff5"
},
"projection" : {
},
"limit" : 1.0,
"singleBatch" : true,
"batchSize" : 1.0,
"returnKey" : false,
"showRecordId" : false,
"lsid" : {
"id" : UUID("dc3ff1d9-1372-4601-95f7-18ab9fc844e8")
},
"$clusterTime" : {
"clusterTime" : Timestamp(1576901496, 78),
"signature" : {
"hash" : BinData(0, "7jbvlZdVyJd/DMuSTwYW/9Oq5JM="),
"keyId" : NumberLong(6751435534133886978)
}
},
"$db" : "p2p"
},
"planSummary" : "IXSCAN { userId: 1 }",
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(500240)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6265169",
"connectionId" : 6265169.0,
"client" : "10.8.88.229:1458",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "3.3.2"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.4.0, LE, mongodb-core: 3.3.2"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016950964.0,
"lsid" : {
"id" : UUID("af546ff9-66c4-4267-8756-801eeab20692"),
"uid" : BinData(0, "p3XUolfQdFzJ2a5D1MVQybdfT5p6L7Pz.. 8 more bytes")
},
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(341323),
"op" : "insert",
"ns" : "p2p.Log",
"command" : {
"insert" : "Log",
"documents" : [
{
"_id" : ObjectId("5dfd9b7985438c51491ae2b1"),
"userId" : "",
"orderId" : "",
"type" : "out",
"interfaceName" : "queryProtocolSign",
"server" : "custodian",
"httpMethod" : "post",
"url" : "https://ncustodian.kaolalicai.cn/api/v1/recharge/query_protocol_sign",
"body" : {
"platformUserNo" : "5b7f67c63f0123000fafff29",
"expectPayCompany" : "XWBANK"
},
"retryTimes" : 4.0,
"response" : {
"code" : 0.0,
"data" : {
"protocol" : "210727199509191865",
"platformUserNo" : "5b7f67c63f0123000fafff29",
"expectPayCompany" : "XWBANK",
"protocolStatus" : "SUCCESS",
"code" : "0",
"status" : "SUCCESS"
}
},
"createdAt" : ISODate("2019-12-21T04:11:37.272+0000"),
"updatedAt" : ISODate("2019-12-21T04:11:37.272+0000"),
"__v" : 0.0
}
],
"ordered" : true,
"lsid" : {
"id" : UUID("af546ff9-66c4-4267-8756-801eeab20692")
},
"txnNumber" : NumberLong(23),
"$clusterTime" : {
"clusterTime" : Timestamp(1576901496, 72),
"signature" : {
"hash" : BinData(0, "7jbvlZdVyJd/DMuSTwYW/9Oq5JM="),
"keyId" : NumberLong(6751435534133886978)
}
},
"$db" : "p2p"
},
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(3)
}
},
"Database" : {
"acquireCount" : {
"w" : NumberLong(4)
}
},
"Collection" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(516556)
}
},
"oplog" : {
"acquireCount" : {
"w" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6265168",
"connectionId" : 6265168.0,
"client" : "10.8.88.229:1456",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "3.3.2"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.4.0, LE, mongodb-core: 3.3.2"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951020.0,
"lsid" : {
"id" : UUID("b690edd5-31dc-4a4f-a23d-9eea8f70a4af"),
"uid" : BinData(0, "p3XUolfQdFzJ2a5D1MVQybdfT5p6L7Pz.. 8 more bytes")
},
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(701123),
"op" : "query",
"ns" : "p2p.InvestRepaymentPlan",
"command" : {
"find" : "InvestRepaymentPlan",
"filter" : {
"userId" : "57f3579031f41146f0f294c3",
"status" : "pending"
},
"projection" : {
},
"returnKey" : false,
"showRecordId" : false,
"lsid" : {
"id" : UUID("b690edd5-31dc-4a4f-a23d-9eea8f70a4af")
},
"$clusterTime" : {
"clusterTime" : Timestamp(1576901496, 72),
"signature" : {
"hash" : BinData(0, "7jbvlZdVyJd/DMuSTwYW/9Oq5JM="),
"keyId" : NumberLong(6751435534133886978)
}
},
"$db" : "p2p"
},
"planSummary" : "IXSCAN { userId: 1, status: 1 }",
"numYields" : 2.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6265158",
"connectionId" : 6265158.0,
"client" : "10.8.88.229:1436",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "3.3.2"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.4.0, LE, mongodb-core: 3.3.2"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951134.0,
"lsid" : {
"id" : UUID("5406e31d-7e4f-461b-b7a5-73855a70d56a"),
"uid" : BinData(0, "p3XUolfQdFzJ2a5D1MVQybdfT5p6L7Pz.. 8 more bytes")
},
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(872677),
"op" : "query",
"ns" : "p2p.Account",
"command" : {
"find" : "Account",
"filter" : {
"userId" : "596db9aa1595af31bee6debe"
},
"projection" : {
},
"limit" : 1.0,
"singleBatch" : true,
"batchSize" : 1.0,
"returnKey" : false,
"showRecordId" : false,
"lsid" : {
"id" : UUID("5406e31d-7e4f-461b-b7a5-73855a70d56a")
},
"$clusterTime" : {
"clusterTime" : Timestamp(1576901496, 71),
"signature" : {
"hash" : BinData(0, "7jbvlZdVyJd/DMuSTwYW/9Oq5JM="),
"keyId" : NumberLong(6751435534133886978)
}
},
"$db" : "p2p"
},
"planSummary" : "IXSCAN { userId: 1 }",
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6265078",
"connectionId" : 6265078.0,
"client" : "10.8.88.76:49230",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951336.0,
"secs_running" : NumberLong(1),
"microsecs_running" : NumberLong(1387273),
"op" : "getmore",
"ns" : "p2p.InvestRepaymentPlan",
"command" : {
"getMore" : NumberLong(2318139418241),
"collection" : "InvestRepaymentPlan",
"batchSize" : 1000.0,
"$readPreference" : {
"mode" : "secondaryPreferred"
},
"$db" : "p2p"
},
"originatingCommand" : {
"find" : "InvestRepaymentPlan",
"filter" : {
"status" : "pending",
"userId" : "5781ec2f4aa15a25dc9ba6b1"
},
"projection" : {
},
"$db" : "p2p"
},
"planSummary" : "IXSCAN { userId: 1, status: 1 }",
"numYields" : 13.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(15),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(14),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(14),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(501600)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264783",
"connectionId" : 6264783.0,
"client" : "10.8.88.229:62972",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951122.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(867499),
"op" : "query",
"ns" : "new_bear.user",
"command" : {
"find" : "user",
"filter" : {
"_id" : ObjectId("560a096e3b24861c750d8fdf")
},
"projection" : {
},
"limit" : 1.0,
"singleBatch" : true,
"batchSize" : 1.0,
"$db" : "new_bear"
},
"planSummary" : "IDHACK",
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264781",
"connectionId" : 6264781.0,
"client" : "10.8.88.229:62968",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951042.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(704108),
"op" : "command",
"ns" : "new_bear.asset",
"command" : {
"aggregate" : "asset",
"pipeline" : [
{
"$match" : {
"userId" : "59033bd2ea9eb0220b40214d",
"status" : {
"$ne" : "fail"
}
}
},
{
"$project" : {
"num" : "$num",
"totalNum" : "$totalNum",
"expectedEarning" : "$expectedEarning",
"accruedInterest" : {
"$ifNull" : [
"$accruedInterest",
0.0
]
},
"name" : "$product.name",
"term" : "$product.term",
"productId" : {
"$ifNull" : [
"$product.id",
"$product.productId"
]
}
}
},
{
"$group" : {
"_id" : "$productId",
"name" : {
"$first" : "$name"
},
"term" : {
"$first" : "$term"
},
"num" : {
"$sum" : "$num"
},
"totalNum" : {
"$sum" : "$totalNum"
},
"expectedEarning" : {
"$sum" : "$expectedEarning"
},
"accruedInterest" : {
"$sum" : "$accruedInterest"
}
}
}
],
"cursor" : {
"batchSize" : 1000.0
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { userId: 1 }",
"numYields" : 2.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(5),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(509808)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264766",
"connectionId" : 6264766.0,
"client" : "10.8.88.229:62938",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951160.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(851194),
"op" : "query",
"ns" : "new_bear.conditionConfig",
"command" : {
"find" : "conditionConfig",
"filter" : {
"type" : "overviewBanner",
"config.endTime" : {
"$gt" : 1576901249276.0
},
"config.startTime" : {
"$lt" : 1576901249276.0
},
"status" : "enabled"
},
"sort" : {
"config.priority" : -1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { type: 1 }",
"numYields" : 2.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(500499)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264764",
"connectionId" : 6264764.0,
"client" : "10.8.88.229:62928",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951144.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(130782),
"op" : "query",
"ns" : "new_bear.conditionConfig",
"command" : {
"find" : "conditionConfig",
"filter" : {
"config.endTime" : {
"$gt" : 1576901496750.0
},
"config.startTime" : {
"$lt" : 1576901496750.0
},
"status" : "enabled",
"config.page" : "home",
"type" : "popup"
},
"sort" : {
"config.priority" : 1.0,
"createdAt" : -1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { type: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1010944)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264760",
"connectionId" : 6264760.0,
"client" : "10.8.88.229:62920",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951158.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(176933),
"op" : "update",
"ns" : "new_bear.asset",
"command" : {
"q" : {
"_id" : ObjectId("5bb0c4c18d65601f134286e3")
},
"u" : {
"$setOnInsert" : {
"createdAt" : ISODate("2019-12-21T04:11:36.752+0000")
},
"$set" : {
"accruedInterest" : 220.04,
"interestDays" : 439.0,
"updatedAt" : ISODate("2019-12-21T04:11:36.752+0000")
}
},
"multi" : false,
"upsert" : false
},
"planSummary" : "IDHACK",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(4)
}
},
"Database" : {
"acquireCount" : {
"w" : NumberLong(4)
}
},
"Collection" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1007247)
}
},
"oplog" : {
"acquireCount" : {
"w" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264756",
"connectionId" : 6264756.0,
"client" : "10.8.88.229:62912",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951018.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(640699),
"op" : "query",
"ns" : "new_bear.investLimit",
"command" : {
"find" : "investLimit",
"filter" : {
"limitTypeName" : "平衡型"
},
"projection" : {
},
"limit" : 1.0,
"singleBatch" : true,
"batchSize" : 1.0,
"$db" : "new_bear"
},
"planSummary" : "COLLSCAN",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(500574)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264754",
"connectionId" : 6264754.0,
"client" : "10.8.88.229:62904",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951015.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(625481),
"op" : "query",
"ns" : "new_bear.newTicketTask",
"command" : {
"find" : "newTicketTask",
"filter" : {
"endTime" : {
"$gte" : 1576901496936.0
},
"startTime" : {
"$lte" : 1576901496936.0
},
"$or" : [
{
"userIds" : "58906ec2488585ab68d56dde"
},
{
"userIds" : [
]
}
],
"productId" : "5c52be61696a93000e1ee46c"
},
"sort" : {
"_id" : -1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { endTime: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(501608)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6265059",
"connectionId" : 6265059.0,
"client" : "10.8.88.76:49192",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016953617.0,
"secs_running" : NumberLong(15),
"microsecs_running" : NumberLong(15501286),
"op" : "command",
"ns" : "p2p.TransactionFlow",
"command" : {
"aggregate" : "TransactionFlow",
"pipeline" : [
{
"$match" : {
"userId" : "55e535a2b8b58560470920ae",
"type" : {
"$in" : [
410.0,
-410.0,
-21.0,
21.0,
29.0,
-22.0,
22.0,
-39.0,
39.0,
23.0,
-23.0,
-24.0,
-25.0,
24.0,
25.0,
-26.0,
-27.0,
-28.0,
28.0,
-42.0,
42.0,
31.0,
31.0,
-31.0,
-43.0,
43.0,
35.0,
-35.0,
33.0,
-33.0,
-37.0,
-37.0,
-41.0,
37.0,
41.0,
-36.0,
36.0,
-32.0,
-32.0,
32.0,
40.0,
-38.0,
38.0,
-34.0,
34.0,
40.0,
30.0,
-30.0
]
},
"time" : {
"$gt" : 1575734400000.0
}
}
},
{
"$project" : {
"userId" : 1.0,
"amount" : {
"$cond" : {
"if" : {
"$gt" : [
"$type",
0.0
]
},
"then" : "$amount",
"else" : {
"$subtract" : [
0.0,
"$amount"
]
}
}
}
}
},
{
"$group" : {
"_id" : "$userId",
"total" : {
"$sum" : "$amount"
}
}
}
],
"cursor" : {
"batchSize" : 1000.0
},
"$db" : "p2p"
},
"planSummary" : "IXSCAN { userId: 1, type: 1, time: 1 }",
"numYields" : 58.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(61),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(60),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(60),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1000242)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264753",
"connectionId" : 6264753.0,
"client" : "10.8.88.229:62902",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951136.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(131951),
"op" : "query",
"ns" : "new_bear.ticketTask",
"command" : {
"find" : "ticketTask",
"filter" : {
"$nor" : [
{
"expand.isRepeat" : false,
"usedTimes" : {
"$gte" : 1.0
}
}
],
"endTime" : {
"$gte" : 1576901494704.0
},
"startTime" : {
"$lt" : 1576901494704.0
},
"$or" : [
{
"$or" : [
{
"userIds" : "5c7a193a9eb10067c5d217fe"
},
{
"userIds" : [
]
}
],
"productId" : "5c52be61696a93000e1ee46c"
},
{
"$or" : [
{
"userIds" : "5c7a193a9eb10067c5d217fe"
},
{
"userIds" : [
]
}
],
"$and" : [
{
"productMinTerm" : {
"$lte" : 365.0
}
},
{
"productMaxTerm" : {
"$gte" : 365.0
}
}
]
}
]
},
"sort" : {
"_id" : -1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { endTime: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1006253)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264738",
"connectionId" : 6264738.0,
"client" : "10.8.88.229:62852",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "2.2.34"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.4.0, LE, mongodb-core: 2.1.18"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951026.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(920625),
"op" : "query",
"ns" : "new_bear.userTicket",
"command" : {
"find" : "userTicket",
"filter" : {
"title" : "关注微信",
"userId" : "59a425cf3259ad9d0de11490"
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { userId: 1, type: 1, status: 1, endTime: 1 }",
"numYields" : 11.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(13),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(12),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(12),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264733",
"connectionId" : 6264733.0,
"client" : "10.8.88.229:62836",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "2.2.34"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.4.0, LE, mongodb-core: 2.1.18"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016950885.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(395492),
"op" : "command",
"ns" : "new_bear.asset",
"command" : {
"aggregate" : "asset",
"pipeline" : [
{
"$match" : {
"userId" : "58fb08b8d6487d129b9ff3fa",
"status" : {
"$ne" : "fail"
}
}
},
{
"$project" : {
"num" : "$num",
"totalNum" : "$totalNum",
"expectedEarning" : "$expectedEarning",
"accruedInterest" : {
"$ifNull" : [
"$accruedInterest",
0.0
]
},
"name" : "$product.name",
"term" : "$product.term",
"productId" : {
"$ifNull" : [
"$product.id",
"$product.productId"
]
}
}
},
{
"$group" : {
"_id" : "$productId",
"name" : {
"$first" : "$name"
},
"term" : {
"$first" : "$term"
},
"num" : {
"$sum" : "$num"
},
"totalNum" : {
"$sum" : "$totalNum"
},
"expectedEarning" : {
"$sum" : "$expectedEarning"
},
"accruedInterest" : {
"$sum" : "$accruedInterest"
}
}
}
],
"cursor" : {
"batchSize" : 1000.0
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { userId: 1 }",
"numYields" : 6.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(9),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(8),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(8),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264732",
"connectionId" : 6264732.0,
"client" : "10.8.88.229:62828",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "2.2.34"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.4.0, LE, mongodb-core: 2.1.18"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.161+0800",
"opid" : -1016951012.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(623412),
"op" : "query",
"ns" : "new_bear.newTicketTask",
"command" : {
"find" : "newTicketTask",
"filter" : {
"endTime" : {
"$gte" : 1576901496936.0
},
"startTime" : {
"$lte" : 1576901496936.0
},
"$or" : [
{
"userIds" : "58906ec2488585ab68d56dde"
},
{
"userIds" : [
]
}
],
"productId" : "5c90bc9d4bbfc6000ebb7f37"
},
"sort" : {
"_id" : -1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { endTime: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(501970)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264752",
"connectionId" : 6264752.0,
"client" : "10.8.88.229:62900",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016951030.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(658377),
"op" : "update",
"ns" : "new_bear.userTicket",
"command" : {
"q" : {
"endTime" : {
"$lt" : 1576901315813.0
},
"status" : 50.0,
"type" : "rate_limit",
"userId" : "59c4cfb40519cc579aaf717c"
},
"u" : {
"$setOnInsert" : {
"createdAt" : ISODate("2019-12-21T04:08:35.814+0000")
},
"$set" : {
"status" : 10.0,
"updatedAt" : ISODate("2019-12-21T04:08:35.814+0000")
}
},
"multi" : true,
"upsert" : false
},
"planSummary" : "IXSCAN { userId: 1, type: 1, status: 1, endTime: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(3)
}
},
"Database" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Collection" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(501391)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264727",
"connectionId" : 6264727.0,
"client" : "10.8.88.229:62806",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "2.2.34"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.4.0, LE, mongodb-core: 2.1.18"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016951148.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(130806),
"op" : "query",
"ns" : "new_bear.operation",
"command" : {
"find" : "operation",
"filter" : {
"status" : "enabled",
"articleId" : "1318",
"userId" : "58a66115151d668c05fb8d9b"
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { userId: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1011354)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264782",
"connectionId" : 6264782.0,
"client" : "10.8.88.229:62970",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016951031.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(658503),
"op" : "update",
"ns" : "new_bear.asset",
"command" : {
"q" : {
"_id" : ObjectId("5dedb11aec24387b80fa1a50")
},
"u" : {
"$setOnInsert" : {
"createdAt" : ISODate("2019-12-21T04:11:36.951+0000")
},
"$set" : {
"accruedInterest" : 61.67,
"interestDays" : 12.0,
"updatedAt" : ISODate("2019-12-21T04:11:36.951+0000")
}
},
"multi" : false,
"upsert" : false
},
"planSummary" : "IDHACK",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(4)
}
},
"Database" : {
"acquireCount" : {
"w" : NumberLong(4)
}
},
"Collection" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(501857)
}
},
"oplog" : {
"acquireCount" : {
"w" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264403",
"connectionId" : 6264403.0,
"client" : "10.8.88.76:43928",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016951193.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(220951),
"op" : "command",
"ns" : "new_bear.asset",
"command" : {
"aggregate" : "asset",
"pipeline" : [
{
"$match" : {
"userId" : "5753e4f901c9b8fbfd74dba0",
"status" : {
"$ne" : "fail"
}
}
},
{
"$project" : {
"num" : "$num",
"totalNum" : "$totalNum",
"expectedEarning" : "$expectedEarning",
"accruedInterest" : {
"$ifNull" : [
"$accruedInterest",
0.0
]
},
"name" : "$product.name",
"term" : "$product.term",
"productId" : {
"$ifNull" : [
"$product.id",
"$product.productId"
]
}
}
},
{
"$group" : {
"_id" : "$productId",
"name" : {
"$first" : "$name"
},
"term" : {
"$first" : "$term"
},
"num" : {
"$sum" : "$num"
},
"totalNum" : {
"$sum" : "$totalNum"
},
"expectedEarning" : {
"$sum" : "$expectedEarning"
},
"accruedInterest" : {
"$sum" : "$accruedInterest"
}
}
}
],
"cursor" : {
"batchSize" : 1000.0
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { userId: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1007134)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264399",
"connectionId" : 6264399.0,
"client" : "10.8.88.76:43920",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016951034.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(665867),
"op" : "query",
"ns" : "new_bear.operation",
"command" : {
"find" : "operation",
"filter" : {
"status" : "enabled",
"articleId" : "1322",
"userId" : "5cf5d2bb4860a55321e457c3"
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { userId: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(500598)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264397",
"connectionId" : 6264397.0,
"client" : "10.8.88.76:43916",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016950842.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(124867),
"op" : "query",
"ns" : "new_bear.order",
"command" : {
"find" : "order",
"filter" : {
"oType" : {
"$in" : [
-19.0,
-23.0
]
},
"asset_id" : "5d24a39277f5ff669d36f276"
},
"sort" : {
"_id" : -1.0
},
"projection" : {
},
"limit" : 1.0,
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { asset_id: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264396",
"connectionId" : 6264396.0,
"client" : "10.8.88.76:43914",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016951013.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(634206),
"op" : "query",
"ns" : "new_bear.asset",
"command" : {
"find" : "asset",
"filter" : {
"_id" : {
"$in" : [
ObjectId("5dd5db61b9938b3231fc1320"),
ObjectId("5dc9876b4d07842e821f8f7c"),
ObjectId("5dc8e3e1f90a9873fd3da903"),
ObjectId("5dbc2b63ea397944906d591e"),
ObjectId("5dbb78902f7f5b6f3cb4f46f"),
ObjectId("5daba4c43a4ae03670f4c321"),
ObjectId("5da74a5d3a7cbe44801d08db"),
ObjectId("5da749f617dca47ac0b526cb"),
ObjectId("5da7491801aa377a8409934c"),
ObjectId("5da52ed83acfcf53fc51a64d"),
ObjectId("5d9fb199d8be8f0551af1a5d"),
ObjectId("5d8ff431eaded82a532fc211"),
ObjectId("5d8c0696cd93a84e4a1326e2"),
ObjectId("5d864ac4a4c798584d74212d"),
ObjectId("5d7f8b513a8a582ee89af9cf")
]
}
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { _id: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(500300)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264393",
"connectionId" : 6264393.0,
"client" : "10.8.88.76:43908",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016951112.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(757342),
"op" : "query",
"ns" : "new_bear.ticketTask",
"command" : {
"find" : "ticketTask",
"filter" : {
"$nor" : [
{
"expand.isRepeat" : false,
"usedTimes" : {
"$gte" : 1.0
}
}
],
"endTime" : {
"$gte" : 1576901347392.0
},
"startTime" : {
"$lt" : 1576901347392.0
},
"$or" : [
{
"$or" : [
{
"userIds" : "59505f63fe090f02140ea4d1"
},
{
"userIds" : [
]
}
],
"productId" : "5c90bc9d4bbfc6000ebb7f37"
},
{
"$or" : [
{
"userIds" : "59505f63fe090f02140ea4d1"
},
{
"userIds" : [
]
}
],
"$and" : [
{
"productMinTerm" : {
"$lte" : 90.0
}
},
{
"productMaxTerm" : {
"$gte" : 90.0
}
}
]
}
]
},
"sort" : {
"_id" : -1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { endTime: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(501128)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264390",
"connectionId" : 6264390.0,
"client" : "10.8.88.76:43902",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016950824.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(102762),
"op" : "query",
"ns" : "new_bear.newTicketTask",
"command" : {
"find" : "newTicketTask",
"filter" : {
"endTime" : {
"$gte" : 1576901496883.0
},
"startTime" : {
"$lte" : 1576901496883.0
},
"$or" : [
{
"userIds" : "59c0a5750dc206b15605ffd3"
},
{
"userIds" : [
]
}
],
"productId" : "5c52c031c42156000e7ee079"
},
"sort" : {
"_id" : -1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { endTime: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264385",
"connectionId" : 6264385.0,
"client" : "10.8.88.76:43892",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016951001.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(541890),
"op" : "query",
"ns" : "new_bear.abTest",
"command" : {
"find" : "abTest",
"filter" : {
"type" : "showAccruedInterest20190315"
},
"projection" : {
},
"limit" : 1.0,
"singleBatch" : true,
"batchSize" : 1.0,
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { type: 1 }",
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(502411)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264382",
"connectionId" : 6264382.0,
"client" : "10.8.88.76:43886",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016951108.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(767144),
"op" : "command",
"ns" : "new_bear.order",
"command" : {
"aggregate" : "order",
"pipeline" : [
{
"$match" : {
"uid" : "56e116395e181b3ccc9dcb04",
"oType" : {
"$in" : [
16.0,
15.0,
14.0,
20.0,
17.0,
23.0,
21.0,
46.0,
45.0
]
},
"status" : 1.0
}
},
{
"$group" : {
"_id" : "",
"total" : {
"$sum" : "$amount"
}
}
}
],
"cursor" : {
"batchSize" : 1000.0
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { uid: 1, oType: 1, status: 1 }",
"numYields" : 2.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(5),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(503036)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264361",
"connectionId" : 6264361.0,
"client" : "10.8.88.76:43800",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "2.2.34"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.9.0, LE, mongodb-core: 2.1.18"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016951017.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(680320),
"op" : "query",
"ns" : "new_bear.ticketTask",
"command" : {
"find" : "ticketTask",
"filter" : {
"$nor" : [
{
"expand.isRepeat" : false,
"usedTimes" : {
"$gte" : 1.0
}
}
],
"endTime" : {
"$gte" : 1576901142836.0
},
"startTime" : {
"$lt" : 1576901142836.0
},
"$or" : [
{
"$or" : [
{
"userIds" : "57ab1e936f9d78424ed2903d"
},
{
"userIds" : [
]
}
],
"productId" : "5c90bc9d4bbfc6000ebb7f37"
},
{
"$or" : [
{
"userIds" : "57ab1e936f9d78424ed2903d"
},
{
"userIds" : [
]
}
],
"$and" : [
{
"productMinTerm" : {
"$lte" : 90.0
}
},
{
"productMaxTerm" : {
"$gte" : 90.0
}
}
]
}
]
},
"sort" : {
"_id" : -1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { endTime: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264394",
"connectionId" : 6264394.0,
"client" : "10.8.88.76:43910",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016951007.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(619381),
"op" : "query",
"ns" : "new_bear.userTicket",
"command" : {
"find" : "userTicket",
"filter" : {
"startTime" : {
"$lte" : 1576901147313.0
},
"status" : 50.0,
"type" : {
"$in" : [
"rate_limit"
]
},
"userId" : "5837f2174ccd2a951f9cf702"
},
"sort" : {
"type" : 1.0,
"amount" : -1.0,
"endTime" : 1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { userId: 1, type: 1, status: 1, endTime: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(500453)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264391",
"connectionId" : 6264391.0,
"client" : "10.8.88.76:43904",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016951036.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(659990),
"op" : "query",
"ns" : "new_bear.abTest",
"command" : {
"find" : "abTest",
"filter" : {
"type" : "showAccruedInterest20190315"
},
"projection" : {
},
"limit" : 1.0,
"singleBatch" : true,
"batchSize" : 1.0,
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { type: 1 }",
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(502378)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264389",
"connectionId" : 6264389.0,
"client" : "10.8.88.76:43900",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.162+0800",
"opid" : -1016950831.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(114037),
"op" : "query",
"ns" : "new_bear.abTest",
"command" : {
"find" : "abTest",
"filter" : {
"type" : "AbTestAssetListNormalShowBonusRate"
},
"projection" : {
},
"limit" : 1.0,
"singleBatch" : true,
"batchSize" : 1.0,
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { type: 1 }",
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264775",
"connectionId" : 6264775.0,
"client" : "10.8.88.229:62956",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016951035.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(660045),
"op" : "query",
"ns" : "new_bear.rate",
"command" : {
"find" : "rate",
"filter" : {
"type" : "bonusRate",
"status" : "enabled",
"assetId" : "5d8acb83f0c1aa29455df861"
},
"sort" : {
"startDate" : 1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { assetId: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(500065)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264763",
"connectionId" : 6264763.0,
"client" : "10.8.88.229:62926",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016951029.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(655440),
"op" : "query",
"ns" : "new_bear.rate",
"command" : {
"find" : "rate",
"filter" : {
"type" : "bonusRate",
"status" : "enabled",
"assetId" : "5d4d1667aff0535922726716"
},
"sort" : {
"startDate" : 1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { assetId: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(500900)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264351",
"connectionId" : 6264351.0,
"client" : "10.8.88.76:43768",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "2.2.34"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.9.0, LE, mongodb-core: 2.1.18"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016951143.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(832179),
"op" : "command",
"ns" : "new_bear.order",
"command" : {
"aggregate" : "order",
"pipeline" : [
{
"$match" : {
"uid" : "55b348d1b4bc07c7dbf06df2",
"oType" : -22.0,
"status" : 2.0
}
},
{
"$group" : {
"_id" : null,
"total" : {
"$sum" : "$amount"
}
}
}
],
"cursor" : {
"batchSize" : 1000.0
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { uid: 1, oType: 1, status: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(500252)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264770",
"connectionId" : 6264770.0,
"client" : "10.8.88.229:62946",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016951014.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(635332),
"op" : "query",
"ns" : "new_bear.ticketTask",
"command" : {
"find" : "ticketTask",
"filter" : {
"$nor" : [
{
"expand.isRepeat" : false,
"usedTimes" : {
"$gte" : 1.0
}
}
],
"endTime" : {
"$gte" : 1576901277873.0
},
"startTime" : {
"$lt" : 1576901277873.0
},
"$or" : [
{
"$or" : [
{
"userIds" : "55bdb98128f3dfcb7f2eae74"
},
{
"userIds" : [
]
}
],
"productId" : "5c52be61696a93000e1ee46c"
},
{
"$or" : [
{
"userIds" : "55bdb98128f3dfcb7f2eae74"
},
{
"userIds" : [
]
}
],
"$and" : [
{
"productMinTerm" : {
"$lte" : 365.0
}
},
{
"productMaxTerm" : {
"$gte" : 365.0
}
}
]
}
]
},
"sort" : {
"_id" : -1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { endTime: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(508432)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264768",
"connectionId" : 6264768.0,
"client" : "10.8.88.229:62942",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016951023.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(648423),
"op" : "query",
"ns" : "new_bear.order",
"command" : {
"find" : "order",
"filter" : {
"oType" : {
"$in" : [
-19.0,
-23.0
]
},
"asset_id" : "5c1c67ac318b9c234ee7b62a"
},
"sort" : {
"_id" : -1.0
},
"projection" : {
},
"limit" : 1.0,
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { asset_id: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(516685)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6265176",
"connectionId" : 6265176.0,
"client" : "10.8.88.229:1472",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "3.3.2"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.4.0, LE, mongodb-core: 3.3.2"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016950840.0,
"lsid" : {
"id" : UUID("9dff242e-7e35-4a64-a271-0ada1ddf6f14"),
"uid" : BinData(0, "p3XUolfQdFzJ2a5D1MVQybdfT5p6L7Pz.. 8 more bytes")
},
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(136182),
"op" : "query",
"ns" : "p2p.InvestRepaymentPlan",
"command" : {
"find" : "InvestRepaymentPlan",
"filter" : {
"userId" : "59a425cf3259ad9d0de11490",
"status" : "pending"
},
"projection" : {
},
"returnKey" : false,
"showRecordId" : false,
"lsid" : {
"id" : UUID("9dff242e-7e35-4a64-a271-0ada1ddf6f14")
},
"$clusterTime" : {
"clusterTime" : Timestamp(1576901496, 78),
"signature" : {
"hash" : BinData(0, "7jbvlZdVyJd/DMuSTwYW/9Oq5JM="),
"keyId" : NumberLong(6751435534133886978)
}
},
"$db" : "p2p"
},
"planSummary" : "IXSCAN { userId: 1, status: 1 }",
"numYields" : 3.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(5),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264746",
"connectionId" : 6264746.0,
"client" : "10.8.88.229:62884",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "2.2.34"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.4.0, LE, mongodb-core: 2.1.18"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016951024.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(655373),
"op" : "query",
"ns" : "new_bear.user",
"command" : {
"find" : "user",
"filter" : {
"_id" : ObjectId("5d5a4d4fe4366e7aae93dfce")
},
"projection" : {
},
"limit" : 1.0,
"singleBatch" : true,
"batchSize" : 1.0,
"$db" : "new_bear"
},
"planSummary" : "IDHACK",
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(501054)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6265174",
"connectionId" : 6265174.0,
"client" : "10.8.88.229:1468",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "3.3.2"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.4.0, LE, mongodb-core: 3.3.2"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016950967.0,
"lsid" : {
"id" : UUID("c9c5665f-b3f9-4ef7-82d8-4402289a0400"),
"uid" : BinData(0, "p3XUolfQdFzJ2a5D1MVQybdfT5p6L7Pz.. 8 more bytes")
},
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(356573),
"op" : "insert",
"ns" : "p2p.Log",
"command" : {
"insert" : "Log",
"documents" : [
{
"_id" : ObjectId("5dfd9b798f0763512cdaa391"),
"userId" : "569e2bde00cdcbe7d871d3e9",
"orderId" : "5dfd9b6c8f0763512cdaa386",
"type" : "out",
"interfaceName" : "repaymentFreeze",
"server" : "custodian",
"httpMethod" : "post",
"url" : "https://ncustodian.kaolalicai.cn/api/v1/user/freeze",
"body" : {
"generalFreezeRequestNo" : "5dfd9b6c8f0763512cdaa386",
"platformUserNo" : "569e2bde00cdcbe7d871d3e9",
"amount" : 5.11
},
"retryTimes" : 4.0,
"response" : {
"code" : 0.0,
"data" : {
"code" : "0",
"status" : "SUCCESS"
}
},
"createdAt" : ISODate("2019-12-21T04:11:37.259+0000"),
"updatedAt" : ISODate("2019-12-21T04:11:37.259+0000"),
"__v" : 0.0
}
],
"ordered" : true,
"lsid" : {
"id" : UUID("c9c5665f-b3f9-4ef7-82d8-4402289a0400")
},
"txnNumber" : NumberLong(66),
"$clusterTime" : {
"clusterTime" : Timestamp(1576901496, 78),
"signature" : {
"hash" : BinData(0, "7jbvlZdVyJd/DMuSTwYW/9Oq5JM="),
"keyId" : NumberLong(6751435534133886978)
}
},
"$db" : "p2p"
},
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(3)
}
},
"Database" : {
"acquireCount" : {
"w" : NumberLong(4)
}
},
"Collection" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(510197)
}
},
"oplog" : {
"acquireCount" : {
"w" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn4615816",
"connectionId" : 4615816.0,
"client" : "10.8.90.51:27757",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "3.2.2"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-957.21.3.el7.x86_64"
},
"platform" : "Node.js v10.17.0, LE, mongodb-core: 3.2.2"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016951150.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(117468),
"op" : "command",
"ns" : "new_bear.asset",
"command" : {
"aggregate" : "asset",
"pipeline" : [
{
"$match" : {
"userId" : "56d5a03cb6559d0279889a20",
"status" : {
"$nin" : [
"fail"
]
}
}
},
{
"$project" : {
"num" : true
}
},
{
"$group" : {
"_id" : null,
"amount" : {
"$sum" : "$num"
}
}
}
],
"cursor" : {
},
"$clusterTime" : {
"clusterTime" : Timestamp(1576901496, 78),
"signature" : {
"hash" : BinData(0, "7jbvlZdVyJd/DMuSTwYW/9Oq5JM="),
"keyId" : NumberLong(6751435534133886978)
}
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { userId: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1004188)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn4607880",
"connectionId" : 4607880.0,
"client" : "10.8.90.51:10896",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016951028.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(687771),
"op" : "query",
"ns" : "new_bear.rate",
"command" : {
"find" : "rate",
"filter" : {
"type" : "bonusRate",
"status" : "enabled",
"assetId" : "5c082f9ca5423908efaf24fc"
},
"sort" : {
"startDate" : 1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { assetId: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(507659)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn4608721",
"connectionId" : 4608721.0,
"client" : "10.8.90.51:44041",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016951033.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(657402),
"op" : "query",
"ns" : "new_bear.rate",
"command" : {
"find" : "rate",
"filter" : {
"type" : "bonusRate",
"status" : "enabled",
"assetId" : "5c0fe061bfc83f3fe03a86ad"
},
"sort" : {
"startDate" : 1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { assetId: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(500373)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn4607885",
"connectionId" : 4607885.0,
"client" : "10.8.90.51:4383",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "3.2.2"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-957.21.3.el7.x86_64"
},
"platform" : "Node.js v10.17.0, LE, mongodb-core: 3.2.2"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016951025.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(649151),
"op" : "query",
"ns" : "new_bear.order",
"command" : {
"find" : "order",
"filter" : {
"asset_id" : "5c9113deb5054a7850146a48",
"oType" : {
"$in" : [
-19.0,
-23.0
]
}
},
"sort" : {
"_id" : -1.0
},
"projection" : {
},
"limit" : 1.0,
"returnKey" : false,
"showRecordId" : false,
"$clusterTime" : {
"clusterTime" : Timestamp(1576901496, 78),
"signature" : {
"hash" : BinData(0, "7jbvlZdVyJd/DMuSTwYW/9Oq5JM="),
"keyId" : NumberLong(6751435534133886978)
}
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { asset_id: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(500795)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6265087",
"connectionId" : 6265087.0,
"client" : "10.8.88.76:49248",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016951131.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(895876),
"op" : "update",
"ns" : "p2p.Portfolio",
"command" : {
"q" : {
"_id" : ObjectId("5d070bc6cc91dc06153d7cd2")
},
"u" : {
"$set" : {
"amountNotCut" : 0.0000000000000002498001805406602,
"amount" : 0.0,
"userId" : "5a4265fd6d361b07be249b69",
"updatedAt" : ISODate("2019-12-21T04:11:36.727+0000")
},
"$setOnInsert" : {
"__v" : 0.0,
"createdAt" : ISODate("2019-12-21T04:11:36.727+0000")
}
},
"multi" : false,
"upsert" : true
},
"planSummary" : "IDHACK",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(4)
}
},
"Database" : {
"acquireCount" : {
"w" : NumberLong(4)
}
},
"Collection" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
},
"oplog" : {
"acquireCount" : {
"w" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264759",
"connectionId" : 6264759.0,
"client" : "10.8.88.229:62918",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.177+0800",
"opid" : -1016951135.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(130648),
"op" : "query",
"ns" : "new_bear.user",
"command" : {
"find" : "user",
"filter" : {
"_id" : ObjectId("5a8f95fbc8680628da4c7e95")
},
"projection" : {
},
"limit" : 1.0,
"singleBatch" : true,
"batchSize" : 1.0,
"$db" : "new_bear"
},
"planSummary" : "IDHACK",
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1006833)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn3547763",
"connectionId" : 3547763.0,
"client" : "10.8.90.52:47685",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.178+0800",
"opid" : -1016950872.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(177280),
"op" : "command",
"ns" : "new_bear.agendaJobs",
"command" : {
"findandmodify" : "agendaJobs",
"query" : {
"$or" : [
{
"name" : "appCalculateAccuredInterest",
"lockedAt" : null,
"nextRunAt" : {
"$lte" : ISODate("2019-12-21T02:55:58.387+0000")
},
"disabled" : {
"$ne" : true
}
},
{
"name" : "appCalculateAccuredInterest",
"lockedAt" : {
"$exists" : false
},
"nextRunAt" : {
"$lte" : ISODate("2019-12-21T02:55:58.387+0000")
},
"disabled" : {
"$ne" : true
}
},
{
"name" : "appCalculateAccuredInterest",
"lockedAt" : {
"$lte" : ISODate("2019-12-21T02:45:53.387+0000")
},
"disabled" : {
"$ne" : true
}
}
]
},
"sort" : {
"nextRunAt" : 1.0,
"priority" : -1.0
},
"new" : true,
"remove" : false,
"upsert" : false,
"update" : {
"$set" : {
"lockedAt" : ISODate("2019-12-21T02:55:53.387+0000")
}
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { name: 1, nextRunAt: 1, priority: -1, lockedAt: 1, disabled: 1 }, IXSCAN { name: 1, nextRunAt: 1, priority: -1, lockedAt: 1, disabled: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(3)
}
},
"Database" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Collection" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn3547762",
"connectionId" : 3547762.0,
"client" : "10.8.90.52:51668",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.178+0800",
"opid" : -1016951140.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(857898),
"op" : "command",
"ns" : "new_bear.agendaJobs",
"command" : {
"findandmodify" : "agendaJobs",
"query" : {
"$or" : [
{
"name" : "autoFixOrder",
"lockedAt" : null,
"nextRunAt" : {
"$lte" : ISODate("2019-12-21T02:55:33.377+0000")
},
"disabled" : {
"$ne" : true
}
},
{
"name" : "autoFixOrder",
"lockedAt" : {
"$exists" : false
},
"nextRunAt" : {
"$lte" : ISODate("2019-12-21T02:55:33.377+0000")
},
"disabled" : {
"$ne" : true
}
},
{
"name" : "autoFixOrder",
"lockedAt" : {
"$lte" : ISODate("2019-12-21T02:45:28.377+0000")
},
"disabled" : {
"$ne" : true
}
}
]
},
"sort" : {
"nextRunAt" : 1.0,
"priority" : -1.0
},
"new" : true,
"remove" : false,
"upsert" : false,
"update" : {
"$set" : {
"lockedAt" : ISODate("2019-12-21T02:55:28.377+0000")
}
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { name: 1, nextRunAt: 1, priority: -1, lockedAt: 1, disabled: 1 }, IXSCAN { name: 1, nextRunAt: 1, priority: -1, lockedAt: 1, disabled: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(3)
}
},
"Database" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Collection" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(501906)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn3547755",
"connectionId" : 3547755.0,
"client" : "10.8.90.52:65451",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "2.2.36"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-957.21.3.el7.x86_64"
},
"platform" : "Node.js v8.16.2, LE, mongodb-core: 2.1.20"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.178+0800",
"opid" : -1016951043.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(670535),
"op" : "command",
"ns" : "new_bear.agendaJobs",
"command" : {
"findandmodify" : "agendaJobs",
"query" : {
"$or" : [
{
"name" : "weixinSignRemind",
"lockedAt" : null,
"nextRunAt" : {
"$lte" : ISODate("2019-12-21T02:55:03.353+0000")
},
"disabled" : {
"$ne" : true
}
},
{
"name" : "weixinSignRemind",
"lockedAt" : {
"$exists" : false
},
"nextRunAt" : {
"$lte" : ISODate("2019-12-21T02:55:03.353+0000")
},
"disabled" : {
"$ne" : true
}
},
{
"name" : "weixinSignRemind",
"lockedAt" : {
"$lte" : ISODate("2019-12-21T02:44:58.353+0000")
},
"disabled" : {
"$ne" : true
}
}
]
},
"sort" : {
"nextRunAt" : 1.0,
"priority" : -1.0
},
"new" : true,
"remove" : false,
"upsert" : false,
"update" : {
"$set" : {
"lockedAt" : ISODate("2019-12-21T02:54:58.353+0000")
}
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { name: 1, nextRunAt: 1, priority: -1, lockedAt: 1, disabled: 1 }, IXSCAN { name: 1, nextRunAt: 1, priority: -1, lockedAt: 1, disabled: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(3)
}
},
"Database" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Collection" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(501538)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264362",
"connectionId" : 6264362.0,
"client" : "10.8.88.76:43804",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "2.2.34"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.9.0, LE, mongodb-core: 2.1.18"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.178+0800",
"opid" : -1016951130.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(153198),
"op" : "query",
"ns" : "new_bear.abTest",
"command" : {
"find" : "abTest",
"filter" : {
"type" : "AbTestAssetListNormalShowBonusRate"
},
"projection" : {
},
"limit" : 1.0,
"singleBatch" : true,
"batchSize" : 1.0,
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { type: 1 }",
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1007293)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn3547759",
"connectionId" : 3547759.0,
"client" : "10.8.90.52:49455",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.178+0800",
"opid" : -1016951151.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(114018),
"op" : "command",
"ns" : "new_bear.agendaJobs",
"command" : {
"findandmodify" : "agendaJobs",
"query" : {
"$or" : [
{
"name" : "p2pFixRepaymentNotEnoughOrder",
"lockedAt" : null,
"nextRunAt" : {
"$lte" : ISODate("2019-12-21T02:59:38.511+0000")
},
"disabled" : {
"$ne" : true
}
},
{
"name" : "p2pFixRepaymentNotEnoughOrder",
"lockedAt" : {
"$exists" : false
},
"nextRunAt" : {
"$lte" : ISODate("2019-12-21T02:59:38.511+0000")
},
"disabled" : {
"$ne" : true
}
},
{
"name" : "p2pFixRepaymentNotEnoughOrder",
"lockedAt" : {
"$lte" : ISODate("2019-12-21T02:49:33.511+0000")
},
"disabled" : {
"$ne" : true
}
}
]
},
"sort" : {
"nextRunAt" : 1.0,
"priority" : -1.0
},
"new" : true,
"remove" : false,
"upsert" : false,
"update" : {
"$set" : {
"lockedAt" : ISODate("2019-12-21T02:59:33.511+0000")
}
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { name: 1, nextRunAt: 1, priority: -1, lockedAt: 1, disabled: 1 }, IXSCAN { name: 1, nextRunAt: 1, priority: -1, lockedAt: 1, disabled: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(3)
}
},
"Database" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Collection" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1017860)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn4607881",
"connectionId" : 4607881.0,
"client" : "10.8.90.51:63530",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "3.2.2"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-957.21.3.el7.x86_64"
},
"platform" : "Node.js v10.17.0, LE, mongodb-core: 3.2.2"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.178+0800",
"opid" : -1016950869.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(143509),
"op" : "query",
"ns" : "new_bear.order",
"command" : {
"find" : "order",
"filter" : {
"asset_id" : "5d40ccf414d26c23614171f2",
"oType" : {
"$in" : [
-19.0,
-23.0
]
}
},
"sort" : {
"_id" : -1.0
},
"projection" : {
},
"limit" : 1.0,
"returnKey" : false,
"showRecordId" : false,
"$clusterTime" : {
"clusterTime" : Timestamp(1576901497, 9),
"signature" : {
"hash" : BinData(0, "rC5dR1omXadbay14U+yCEvTpHLc="),
"keyId" : NumberLong(6751435534133886978)
}
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { asset_id: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264762",
"connectionId" : 6264762.0,
"client" : "10.8.88.229:62924",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.178+0800",
"opid" : -1016951192.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(142353),
"op" : "query",
"ns" : "new_bear.user",
"command" : {
"find" : "user",
"filter" : {
"_id" : ObjectId("5ba2559d3a4be72c371a706a")
},
"projection" : {
},
"limit" : 1.0,
"singleBatch" : true,
"batchSize" : 1.0,
"$db" : "new_bear"
},
"planSummary" : "IDHACK",
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1003867)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6265047",
"connectionId" : 6265047.0,
"client" : "10.8.88.76:49116",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "2.2.34"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-514.26.2.el7.x86_64"
},
"platform" : "Node.js v8.9.0, LE, mongodb-core: 2.1.18"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.178+0800",
"opid" : -1016951211.0,
"secs_running" : NumberLong(1),
"microsecs_running" : NumberLong(1020452),
"op" : "query",
"ns" : "p2p.InvestRepaymentPlan",
"command" : {
"find" : "InvestRepaymentPlan",
"filter" : {
"status" : "pending",
"userId" : "54d7ae8ca0cb138d17bc1694"
},
"projection" : {
},
"$db" : "p2p"
},
"planSummary" : "IXSCAN { userId: 1, status: 1 }",
"numYields" : 3.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(5),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6265077",
"connectionId" : 6265077.0,
"client" : "10.8.88.76:49228",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.178+0800",
"opid" : -1016951223.0,
"secs_running" : NumberLong(1),
"microsecs_running" : NumberLong(1031401),
"op" : "update",
"ns" : "p2p.Portfolio",
"command" : {
"q" : {
"_id" : ObjectId("5d1d7e70cc91dc06155a136d")
},
"u" : {
"$set" : {
"amountNotCut" : 0.0,
"amount" : 0.0,
"userId" : "5ad9fdf9dcaae834ca39fe4a",
"updatedAt" : ISODate("2019-12-21T04:11:36.717+0000")
},
"$setOnInsert" : {
"__v" : 0.0,
"createdAt" : ISODate("2019-12-21T04:11:36.717+0000")
}
},
"multi" : false,
"upsert" : true
},
"planSummary" : "IDHACK",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(4),
"w" : NumberLong(4)
}
},
"Database" : {
"acquireCount" : {
"w" : NumberLong(4)
}
},
"Collection" : {
"acquireCount" : {
"w" : NumberLong(3)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
}
},
"oplog" : {
"acquireCount" : {
"w" : NumberLong(1)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn4608178",
"connectionId" : 4608178.0,
"client" : "10.8.90.51:22859",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.178+0800",
"opid" : -1016951021.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(657723),
"op" : "query",
"ns" : "new_bear.rate",
"command" : {
"find" : "rate",
"filter" : {
"type" : "bonusRate",
"status" : "enabled",
"assetId" : "5c1a58148ceec36f3e495dae"
},
"sort" : {
"startDate" : 1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { assetId: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(500225)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn4607878",
"connectionId" : 4607878.0,
"client" : "10.8.90.51:53694",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "3.2.2"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-957.21.3.el7.x86_64"
},
"platform" : "Node.js v10.17.0, LE, mongodb-core: 3.2.2"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.205+0800",
"opid" : -1016950993.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(508396),
"op" : "command",
"ns" : "p2p.UserCashFlow",
"command" : {
"aggregate" : "UserCashFlow",
"pipeline" : [
{
"$match" : {
"userId" : "555dded20e3292b6c8e6a0e8",
"type" : {
"$nin" : [
"expire"
]
}
}
},
{
"$group" : {
"_id" : null,
"balance" : {
"$sum" : "$amount"
}
}
}
],
"cursor" : {
},
"$clusterTime" : {
"clusterTime" : Timestamp(1576901495, 55),
"signature" : {
"hash" : BinData(0, "6FvN1sxDGaQEDev8cZUmUBi/0XY="),
"keyId" : NumberLong(6751435534133886978)
}
},
"$db" : "p2p"
},
"planSummary" : "IXSCAN { userId: 1, type: 1 }",
"numYields" : 4.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(7),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(6),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(6),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(503352)
}
}
}
}
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn4607876",
"connectionId" : 4607876.0,
"client" : "10.8.90.51:64755",
"clientMetadata" : {
"driver" : {
"name" : "nodejs",
"version" : "2.2.34"
},
"os" : {
"type" : "Linux",
"name" : "linux",
"architecture" : "x64",
"version" : "3.10.0-957.21.3.el7.x86_64"
},
"platform" : "Node.js v10.17.0, LE, mongodb-core: 2.1.18"
},
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.205+0800",
"opid" : -1016951138.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(110698),
"op" : "query",
"ns" : "new_bear.rate",
"command" : {
"find" : "rate",
"filter" : {
"type" : "bonusRate",
"status" : "enabled",
"assetId" : "5c63277aa6f100444efd85ed"
},
"sort" : {
"startDate" : 1.0
},
"projection" : {
},
"$db" : "new_bear"
},
"planSummary" : "IXSCAN { assetId: 1 }",
"numYields" : 1.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(3),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1027860)
}
}
}
},
{
"host" : "a53d01266.cloud.st3:3001",
"desc" : "conn6264755",
"connectionId" : 6264755.0,
"client" : "10.8.88.229:62910",
"active" : true,
"currentOpTime" : "2019-12-21T12:11:38.205+0800",
"opid" : -1016951142.0,
"secs_running" : NumberLong(0),
"microsecs_running" : NumberLong(144719),
"op" : "query",
"ns" : "new_bear.user",
"command" : {
"find" : "user",
"filter" : {
"_id" : ObjectId("56d447b080d0b51e1f24823e")
},
"projection" : {
},
"limit" : 1.0,
"singleBatch" : true,
"batchSize" : 1.0,
"$db" : "new_bear"
},
"planSummary" : "IDHACK",
"numYields" : 0.0,
"locks" : {
"Global" : "w",
"Database" : "w",
"Collection" : "w",
"Metadata" : "W"
},
"waitingForLock" : true,
"lockStats" : {
"Global" : {
"acquireCount" : {
"r" : NumberLong(2),
"w" : NumberLong(1)
}
},
"Database" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Collection" : {
"acquireCount" : {
"r" : NumberLong(1),
"w" : NumberLong(1)
}
},
"Metadata" : {
"acquireCount" : {
"W" : NumberLong(1)
},
"acquireWaitCount" : {
"W" : NumberLong(1)
},
"timeAcquiringMicros" : {
"W" : NumberLong(1000126)
}
}
}
}
]
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment