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

Aggregation: {"codeName" : "UnknownError"}

    XMLWordPrintable

    Details

    • Type: Question
    • Status: Closed
    • Priority: Major - P3
    • Resolution: Incomplete
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Aggregation Framework
    • Labels:
      None
    • Backwards Compatibility:
      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

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved: