错误如下:

在mongodb分页查询 页码过大时： Query failed with error code 292 and error message 'Executor error during find command :: caused by :: Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.' on server xxx:27017; nested exception is com.mongodb.MongoQueryException: Query failed with error code 292 and error message 'Executor error during find command :: caused by :: Sort exceeded memory limit of 104857600 bytes, but did not opt in to external sorting. Aborting operation. Pass allowDiskUse:true to opt in.' on server xxx:27017

错误原因：

mongodb默认排序内存为32M,超出索引内存，抛出异常

解决方案创建索引

以管理员身份进入终端命令行(第一mongo 为自定义容器名称)

docker exec -it mongo mongo admin

选择数据库

use admin

登录

db.auth("kngdommongo","kingdom123456");

创建索引

db.feer.mqtt.data.createIndex({ "createTime" : -1 })

查看索引

db.feer.mqtt.data.getIndexes()

删除索引

db.feer.mqtt.data.dropIndex("createTime_-1")