allowDiskUse for MongoDB
Sort exceeded memory limit
OrderedDict([('ok', 0.0), ('errmsg', 'Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting.'), ('code', 16819), ('codeName', 'Location16819')])
How to include allowDiskUse in my python script?
@Pushpit07 just encountered the same problem, did you manage to solve it?
The same problem
If you are using Mongo >= 4.4 as a dirty hack you can edit djongo/sql2mongo/query.py line:
255: cur = self.db[self.left_table].find(**kwargs).allow_disk_use(True)
I don't know what impact it may have on your server under a heavy load so don't blame me if something blow up :)
You can also try with this: https://www.djongomapper.com/get-started/#using-pymongo-commands
Remember to add: objects = models.DjongoManager() to your model in your models.py
6.0 version of mongo uses allowDiskUse value by default. So it should'n be a great impact with adding of allow_disk_use method as @panrobot described before https://www.mongodb.com/docs/manual/reference/parameters/#mongodb-parameter-param.allowDiskUseByDefault