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

        Issue Links

          is related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-71238 BSONObjectTooLarge

          • Major - P3 - Major loss of function.
          • Closed
          related to

          Bug - A problem which impairs or prevents the functions of the product. SERVER-68845 BSONObjectTooLarge when $merge during aggregation

          • Major - P3 - Major loss of function.
          • Closed

          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: