djongo icon indicating copy to clipboard operation
djongo copied to clipboard

allowDiskUse for MongoDB

Open Pushpit07 opened this issue 4 years ago • 4 comments

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 avatar Jun 02 '21 06:06 Pushpit07

@Pushpit07 just encountered the same problem, did you manage to solve it?

kalideir avatar Jul 08 '21 13:07 kalideir

The same problem

Miando avatar Jul 15 '21 10:07 Miando

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

panrobot avatar Aug 11 '21 12:08 panrobot

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

unuaunco avatar Aug 15 '22 05:08 unuaunco