1.Mongodb聚合查询报错:
项目在对一个单表45W数据量的表进行聚合查询时,报错
Caused by: com.mongodb.MongoCommandException: Command failed with error 43: 'Cursor not found (namespace: 'yunding_cloud_event.aiqin_track_task', id: 1115817773325134966).' on server 172.17.150.62:20000. The full response is { "ok" : 0.0, "errmsg" : "Cursor not found (namespace: 'yunding_cloud_event.aiqin_track_task', id: 1115817773325134966).", "code" : 43 }
at com.mongodb.connection.ProtocolHelper.getCommandFailureException(ProtocolHelper.java:164)
at com.mongodb.connection.InternalStreamConnection.receiveCommandMessageResponse(InternalStreamConnection.java:295)
at com.mongodb.connection.InternalStreamConnection.sendAndReceive(InternalStreamConnection.java:255)
at com.mongodb.connection.UsageTrackingInternalConnection.sendAndReceive(UsageTrackingInternalConnection.java:98)
at com.mongodb.connection.DefaultConnectionPool$PooledConnection.sendAndReceive(DefaultConnectionPool.java:441)
at com.mongodb.connection.CommandProtocolImpl.execute(CommandProtocolImpl.java:80)
at com.mongodb.connection.DefaultServer$DefaultServerProtocolExecutor.execute(DefaultServer.java:189)
at com.mongodb.connection.DefaultServerConnection.executeProtocol(DefaultServerConnection.java:264)
at com.mongodb.connection.DefaultServerConnection.command(DefaultServerConnection.java:126)
at com.mongodb.connection.DefaultServerConnection.command(DefaultServerConnection.java:118)
at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:226)
at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:197)
at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:189)
at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:99)
at com.mongodb.operation.CommandOperationHelper.executeWrappedCommandProtocol(CommandOperationHelper.java:92)
at com.mongodb.operation.CommandReadOperation.execute(CommandReadOperation.java:55)
at com.mongodb.Mongo$3.execute(Mongo.java:826)
at com.mongodb.MongoDatabaseImpl.executeCommand(MongoDatabaseImpl.java:166)
at com.mongodb.MongoDatabaseImpl.runCommand(MongoDatabaseImpl.java:138)
at com.mongodb.MongoDatabaseImpl.runCommand(MongoDatabaseImpl.java:133)
at org.springframework.data.mongodb.core.MongoTemplate$4.doInDB(MongoTemplate.java:440)
at org.springframework.data.mongodb.core.MongoTemplate$4.doInDB(MongoTemplate.java:437)
at org.springframework.data.mongodb.core.MongoTemplate.execute(MongoTemplate.java:497)
... 96 common frames omitted
项目使用spring Data,Jpa。网上未十分明确的找到错误原因及解决办法,但一篇stackoverflow帖子提到可能是数据量太大,超出Spring Data支持,后尝试增加查询条件缩小需聚合数量,果然不再报错,最后解决办法为对原本全量查询改为增加时间范围的查询。
2.idea环境无法启动服务,启动编译阶段获取不了config类的信息。
解决办法为先勾选配置项
然后查看resource目录下有没git.properties,没有的话手动创建一个
然后启动成功