-
Type:
Question
-
Resolution: Incomplete
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Aggregation Framework
-
None
-
Fully Compatible
I have index on "claimId" field, I am aggregating to find duplicate values on "claimId" field. Aggregation with below query is working on Lower Environments (2Million documents). Failing with error on PROD enviroment (500 Million documents)
Aggregation Query:
db.CLAIMS_ENTITY_COMM.aggregate([
{ "$group": {
"_id": { "claimId": "$claimId" },
"dups": { "$push": "$_id" },
"count": { "$sum": 1 }
}},
{ "$match": { "count": { "$gt": 1 } }},
{$out: "CLAIMS_ENTITY_COMM_DUPS"}
],{allowDiskUse : true}).forEach(function(doc) {
doc.dups.shift();
db.CLAIMS_ENTITY_COMM_DUPS.insert(doc);
});
Response with error:
2019-11-02T05:22:33.799-0400 E QUERY [js] Error: command failed: {
"ok" : 0,
"errmsg" : "assertion src/mongo/db/pipeline/value.cpp:1344",
"code" : 8,
"codeName" : "UnknownError",
"operationTime" : Timestamp(1572686553, 5),
"$clusterTime" : {
"clusterTime" : Timestamp(1572686553, 5),
"signature" : {
"hash" : BinData(0,"EojyCQa6HKeiJIetOsbAZcljbcM="),
"keyId" : NumberLong("6704370801467981855")
}
}
} : aggregate failed :
_getErrorWithCode@src/mongo/shell/utils.js:25:13
doassert@src/mongo/shell/assert.js:18:14
_assertCommandWorked@src/mongo/shell/assert.js:536:17
assert.commandWorked@src/mongo/shell/assert.js:620:16
DB.prototype._runAggregate@src/mongo/shell/db.js:260:9
DBCollection.prototype.aggregate@src/mongo/shell/collection.js:1062:12
@(shell):1:1
- related to
-
SERVER-43151 Error in aggregation assertion at value.cpp:1368
-
- Closed
-