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

Attempting to run an aggregation with $out or $merge in a transaction on a sharded cluster leaves idle cursors open

    • Type: Icon: Bug Bug
    • Resolution: Fixed
    • Priority: Icon: Major - P3 Major - P3
    • 4.4.14, 5.0.7, 5.3.0-rc2, 5.3.0-rc3
    • Affects Version/s: None
    • Component/s: None
    • Labels:
      None
    • Fully Compatible
    • ALL
    • v5.3, v5.2, v5.1, v5.0, v4.4, v4.2
    • Hide

      server-61769-repro.patch
      ./buildscripts/resmoke.py run --storageEngine=wiredTiger --storageEngineCacheSizeGB=.50 --suite=sharding jstests/sharding/server-61769.js --log=file

      Show
      server-61769-repro.patch ./buildscripts/resmoke.py run --storageEngine=wiredTiger --storageEngineCacheSizeGB=.50 --suite=sharding jstests/sharding/server-61769.js --log=file
    • QE 2021-12-27, QE 2022-01-10, QE 2022-02-07, QE 2022-02-21, QE 2022-03-07, QE 2022-01-24

      The $out and $merge aggregation pipeline stages are not allowed in transaction. Attempting to do so will fail with OperationNotSupportedInTransaction. On sharded collections, when the client attempts to run $out or $merge in a transaction, it will fail with OperationNotSupportedInTransaction as expected, but it is leaving idle cursors open.

      Repro test attached.

        1. server-61769-repro.patch
          1 kB
          Jordi Serra Torrens

            Assignee:
            jennifer.peshansky@mongodb.com Jennifer Peshansky (Inactive)
            Reporter:
            jordi.serra-torrens@mongodb.com Jordi Serra Torrens
            Votes:
            0 Vote for this issue
            Watchers:
            6 Start watching this issue

              Created:
              Updated:
              Resolved: