Details
-
Question
-
Resolution: Incomplete
-
Major - P3
-
None
-
None
-
None
-
Fully Compatible
Description
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
|
Attachments
Issue Links
- related to
-
SERVER-43151 Error in aggregation assertion at value.cpp:1368
-
- Closed
-