pymongo.errors.OperationFailure:Overflow sort stage buffered data usage exceeds in internal limit
来源:互联网 发布:想加盟淘宝网店 编辑:程序博客网 时间:2024/05/16 16:10
用pymongo接口调用find().sort()方法时,出现错误。报错内容为:
>>> pymongo.errors.OperationFailure: database error: Plan executor error during find: Overflow sort stage buffered data usage of 33574037 bytes exceeds internal limit of 33554432 bytes
这是因为在做sort()时,超过了32MB的in-memory sort。解决方法是可以在mongodb的相应数据库修改该内存上限。
如,我的原代码是:
>>> client = MongoClient('localhost',27018)>>> db = client['NetEase']>>> col = db['comment_content']>>> for item in col.find().sort('page_index',pymongo.ASCENDING): ... print item['page_index']
那么就修改为
>>> mongo --port=27018>>> use NetEase>>>db.adminCommand({setParameter: 1, internalQueryExecMaxBlockingSortBytes: <limit in bytes>})
就好了.
0 0
- pymongo.errors.OperationFailure:Overflow sort stage buffered data usage exceeds in internal limit
- Mongo遇到 Overflow sort stage buffered data usage of ? bytes exceeds internal limit of ?
- mongodb: "Overflow sort stage buffered data usage of 33557904 bytes exceeds internal limit of 33554"
- 【MongoDB】sort stage buffered data usage of 33554446 bytes exceeds internal limit of 33554432 bytes
- com.mongodb.MongoException: Runner error: Overflow sort stage buffered data 错误分析
- pymongo报错 pymongo.errors.OperationFailure: Authentication failed.
- python 查询 MongoDB 数据库pymongo.errors.OperationFailure: cursor id '26777532088498352' not valid at se
- pymongo.errors.OperationFailure: not authorized on test to execute command { listCollections: 1, cur
- pymongo异常-OperationFailure: command SON(...)
- Field in data file exceeds maximum length
- SQLLDR错误Field in data file exceeds maximum length
- sqlldr时候Field in data file exceeds maximum length
- [转贴]【sqlldr】 “Field in data file exceeds maximum length ”解决办法
- 【sqlldr】 “Field in data file exceeds maximum length ”解决办法
- R - Set execution time limit in loop - Stack Overflow
- SORT usage
- Java IO: Buffered和Data
- sqlldr: ield in data file exceeds maximum length in sqlldr datafile.
- CloudLab "server refused our key"
- NYOJ-21-三个水杯
- leetcode #12 in cpp
- Inversion count implemented with merge sort
- 深度学习之Google Deepmind的alphago人工智能算法技术演变历程
- pymongo.errors.OperationFailure:Overflow sort stage buffered data usage exceeds in internal limit
- 16个自媒体平台吐血推荐
- 成为C++高手之实战项目
- android sdk content loader 0% eclipse
- 不像电影,现实是慢慢好转——北漂18年(56)
- IntelliJ IDEA 使用心得与常用快捷键
- IntelliJ Idea 常用快捷键列表
- 【华为OJ】【086-密码强度等级】
- C经典 联合体union