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

$out incorrectly throws BSONObj size error on v5.0.8

    XMLWordPrintableJSON

Details

    • Fully Compatible
    • ALL
    • v6.0, v5.0, v4.4
    • Hide

      Steps followed:

      1. Launch M10 cluster on Atlas and load sample dataset.
      2. In the shell, use sample_mflix db
      3. Run aggregation command: db.movies.aggregate([{$out: "movies2"}])

       

      On version 4.4.13:

      The command runs successfully and movies2 collection is created.

       

      On version 5.0.8:

      The command fails with the error:

      PlanExecutor error during aggregation :: caused by :: BSONObj size: 16836845 (0x100E8ED) is invalid. Size must be between 0 and 16793600(16MB) First element: insert: "tmp.agg_out.045d5052-e014-4830-8d16-5b985ebfc46e"

      Show
      Steps followed: Launch M10 cluster on Atlas and load sample dataset. In the shell, use sample_mflix db Run aggregation command: db.movies.aggregate( [{$out: "movies2"}] )   On version 4.4.13: The command runs successfully and movies2 collection is created.   On version 5.0.8: The command fails with the error: PlanExecutor error during aggregation :: caused by :: BSONObj size: 16836845 (0x100E8ED) is invalid. Size must be between 0 and 16793600(16MB) First element: insert: "tmp.agg_out.045d5052-e014-4830-8d16-5b985ebfc46e"
    • QE 2022-05-30, QE 2022-06-13, QE 2022-06-27, QE 2022-07-11, QE 2022-07-25, QE 2022-08-08, QE 2022-08-22
    • 170

    Description

      In version 5, aggregation with $out as final stage is throwing BSONObj size (16MB) error even though individual documents are much smaller. It seems to be measuring the total size of all the documents in the result set.

      Attachments

        1. screenshot-1.png
          screenshot-1.png
          27 kB
        2. screenshot-2.png
          screenshot-2.png
          36 kB
        3. screenshot-3.png
          screenshot-3.png
          76 kB

        Activity

          People

            mihai.andrei@mongodb.com Mihai Andrei
            awanish@assetplus.io Awanish Raj
            Votes:
            2 Vote for this issue
            Watchers:
            17 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: