Uploaded image for project: 'Core Server'
  1. Core Server
  2. SERVER-44945

aggregate failed at assertion src\\mongo\\db\\pipeline\\value.cpp:1365

    • Type: Icon: Bug Bug
    • Resolution: Duplicate
    • Priority: Icon: Major - P3 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
      

            Assignee:
            carl.champain@mongodb.com Carl Champain (Inactive)
            Reporter:
            liqy0906@gmail.com chris li
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Created:
              Updated:
              Resolved: