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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Aggregation Framework
    • Labels:
      None
    • Operating System:
      ALL

      Description

      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
      

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: