mongodb分页显示错误解决过程

database

{"timestamp":1584239124980,"status":500,"error":"Internal Server Error","message":"Query failed with error code 96 and error message "Executor error during find command :: caused by ::

Sort operation used more than the maximum 33554432 bytes of RAM.

Add an index, or specify a smaller limit." on server 192.168.1.135:7315; nested exception is com.mongodb.MongoQueryException: Query failed with error code 96 and error message "Executor error during find command :: caused by :: Sort operation used more than the maximum 33554432 bytes of RAM. Add an index, or specify a smaller limit." on server 192.168.1.135:7315","path":"/excel/screenResult"}

公司的mongoDB给设置了3G的内存使用。通过free top 。。。命令还是啥的我不知道,反正跟我说只用到了300m。但是还是出了这个500错误。

通过异常信息很清楚看出,排序部分内存有32m的限制,所以3G根本没用上,取消这个排序限制就ok了。

以上是 mongodb分页显示错误解决过程 的全部内容, 来源链接: utcz.com/z/532675.html

回到顶部