-
Type:
Bug
-
Resolution: Duplicate
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: Aggregation Framework
-
None
-
ALL
my query:
db.transactions.aggregate([{$group:{_id:{hash:"$hash"},count:{$sum:1}}},{$match:{count:{$gt:1}}}],{allowDiskUse:true})
I use this query to find duplicates of hash field, but every time I get below error msg when I execute this query. this transaction collection contain 0.5 billion documents, so it takes a while to aggregate, which it's totally understandable, but getting error msg is something I didn't understand. because I execute the same query at another smaller transaction collection in another database where it contain just maybe tens of thousands of documents, and it worked. but for 0.5 billion documents collection, it doesn't work.
error msg:
uncaught exception: Error: command failed: {
"ok" : 0,
"errmsg" : "assertion src\\mongo\\db\\pipeline\\value.cpp:1365",
"code" : 8,
"codeName" : "UnknownError"
} : aggregate failed :
_getErrorWithCode@src/mongo/shell/utils.js:25:13
doassert@src/mongo/shell/assert.js:18:14
_assertCommandWorked@src/mongo/shell/assert.js:583:17
assert.commandWorked@src/mongo/shell/assert.js:673:16
DB.prototype._runAggregate@src/mongo/shell/db.js:266:5
DBCollection.prototype.aggregate@src/mongo/shell/collection.js:1012:12
@(shell):1:1
- duplicates
-
-
- Closed
-