Question 118679 in Mongodb Question posted in
The official documentation can be found here.

When downloading a large file from GridFSBucket mongodb gets Sort exceeded memory limit error

I’m trying to download a large file (larger then 100 MB) from gridFs:

 ObjectId objectId = new ObjectId(item.RawDataFileId);
 file = gridFsBucket.DownloadAsBytes(objectId);

I get this error:

MongoDB.Driver.MongoCommandException: Command find failed: Executor error during find command :: caused by :: Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting..

The app (.net core) is running on a windows service if it counts, I get this error only on the server, in the local environment everything is working perfectly.

Tags:

2

Answers


  1. 0

    My crew and I had the same problem a long time ago, and we did not find any reasonable issue and/or any details about it on Stack Overflow/Google.

    So we investigate this issue in other environments (not dev/test) and find out that the issue is no longer happening.

    After continuing to investigate this issue, I started to clean space from the test server itself (where the issue was happening) and it started to work without any further errors (Althouse even before there was enough space).

    Still can not point the finger at why it happened, but I do encourage you to check the disk space.

    P.S. If you do find out why it was happening, please post it here because there are not enough details about this error.

    Login or Signup to reply.
  2. 0

    Make sure that fs.chunks has proper indexes. (It should have indexes, if not do create index explititly)

    db.fs.chunks.createIndex( { files_id: 1, n: 1 }, { unique: true } );
    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search