Details
-
Bug
-
Resolution: Cannot Reproduce
-
Blocker - P1
-
None
-
2.4.0
-
None
-
Linux - x64 server
-
Linux
Description
Running an aggregate operation against a collection of 50 million documents in a nonsharded env. The operation is taking hours (> 6 ) to
finish, because of the nature of the call - requires a complete scan of indexes and possibily documents. Averege document size is about 600 bytes
and also has several indexes (20).
The problem is with the cancel. I am trying to kill the operation using killOp(). However,the aggregation is continuing without getting interrupted for several hours.
Currentop() is recognizing the request - 'killPending' :true.
Aggregation is something like.
{$group:{ _id :
{org: "$org"}, user:{$last:\"$author\"},logintime:{$last:\"$logintime\"}, "{$group:{_id: $author,total:{$sum:\"$time\"},count: {$sum:1}}}