$out incorrectly throws BSONObj size error on v5.0.8

XMLWordPrintableJSON

    • 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
    • None
    • 3
    • None
    • None
    • None
    • None
    • None
    • None

      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.

        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

            Assignee:
            Mihai Andrei
            Reporter:
            Awanish Raj
            Votes:
            2 Vote for this issue
            Watchers:
            17 Start watching this issue

              Created:
              Updated:
              Resolved: