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

Aggregation pipelines can fail due to QueryPlanKilled in sharding suites with migrations

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 8.0.0-rc1
    • Affects Version/s: None
    • Component/s: None
    • Catalog and Routing
    • Fully Compatible
    • ALL
    • v8.0
    • CAR Team 2024-04-01, CAR Team 2024-04-15
    • 113

      This is an example of failed execution that failed with the following error:

      Error: command failed: {
          "ok" : 0,
          "errmsg" : "PlanExecutor error during aggregation :: caused by :: collection dropped. UUID 81589e40-e8f1-44fe-b9a7-7f74ffbb5053",
          "code" : 175,
          "codeName" : "QueryPlanKilled",
          "$clusterTime" : {
              "clusterTime" : Timestamp(1709040950, 29),
              "signature" : {
                  "hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
                  "keyId" : NumberLong(0)
              }
          },
          "operationTime" : Timestamp(1709040950, 29)
      } with original command request: {
          "aggregate" : "expression_sample_rate",
          "pipeline" : [
              {
                  "$match" : {
                      "$sampleRate" : 0.5
                  }
              },
              {
                  "$count" : "n"
              }
          ],
          "cursor" : {    },
          "lsid" : {
              "id" : UUID("2b2afcc3-5730-4baf-965e-effe829cdac1")
          },
          "$clusterTime" : {
              "clusterTime" : Timestamp(1709040950, 3),
              "signature" : {
                  "hash" : BinData(0,"AAAAAAAAAAAAAAAAAAAAAAAAAAA="),
                  "keyId" : NumberLong(0)
              }
          }
      } on connection: connection to localhost:20003 : aggregate failed :
      _getErrorWithCode@src/mongo/shell/utils.js:24:13
      doassert@src/mongo/shell/assert.js:18:14
      _assertCommandWorked@src/mongo/shell/assert.js:761:25
      assert.commandWorked@src/mongo/shell/assert.js:855:16
      DB.prototype._runAggregate@src/mongo/shell/db.js:265:12
      DBCollection.prototype.aggregate@src/mongo/shell/collection.js:981:21
      @jstests/core/sample_rate.js:27:30
      failed to load: jstests/core/sample_rate.js

       

       

            Assignee:
            silvia.surroca@mongodb.com Silvia Surroca
            Reporter:
            tommaso.tocci@mongodb.com Tommaso Tocci
            Votes:
            0 Vote for this issue
            Watchers:
            8 Start watching this issue

              Created:
              Updated:
              Resolved: