Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Pymongo crashes when ordering by anything different than ID #98

Closed
Gonzalo933 opened this issue May 21, 2018 · 1 comment
Closed

Pymongo crashes when ordering by anything different than ID #98

Gonzalo933 opened this issue May 21, 2018 · 1 comment

Comments

@Gonzalo933
Copy link

I like to sort my experiments by "last activity" and recently the number of experiments stored on my DB has increased.

Today I opened sacredboard, and it crashed whenever I try to go to the next page or increase the number of entries per page. I can post the whole stack trace but this is the important bit:

pymongo.errors.OperationFailure: Executor error during find command: OperationFailed: Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit.

I think that the problem is that sorting by any other field that is not "ID" triggers this error. I currently have 60 experiments on the DB.

@chovanecm
Copy link
Owner

chovanecm commented May 21, 2018

Hi Gonzalo, this is unfortunately a known issue and an open point. Please try adding some database indices to the fields you'd like to sort by. See #70.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants